Preview

Bis245 Ilab

Satisfactory Essays
Open Document
Open Document
2683 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Bis245 Ilab
A. Lab # : BSBA BIS245A-1 B. Lab 1 of 7 : Introduction to MS Visio and MS Access C. Lab Overview--Scenario/Summary TCOs: 1. Given a business situation in which managers require information from a database, determine, analyze and classify that information so that reports can be designed to meet the requirements. 2. Given a situation containing entities, business rules, and data requirements, create the conceptual model of the database using a database modeling tool. Scenario: You have been asked to create two conceptual database models using MS Visio Database Model Diagram Template. The purpose of this lab is to have you gain familiarity with the various modeling tools needed to create a conceptual model (entity relationship diagram) of a database. You will create two conceptual models. You will then open an existing Access database to explore database objects and to experiment with simple data manipulation using filters and sorts and to begin elementary work with relationships. Upon completing this lab, you will be able to 1. relying on detailed instructions, create a simple conceptual model for a two-table database using MS Visio; 2. use experience gained in creating the first model to construct a similar conceptual model without the instructions; and 3. download an existing Microsoft Access database file. Open the database; find and identify different database objects in this database.

Page 1 of 31

D. Deliverables Section Part B Step 4 Part C Step 6 E. Lab Steps Preparation 1. Get the Database from Doc Sharing: a. Download Lab1_Nwind.accdb file from your course Doc Sharing panel (Labs view), and Save the file to your local drive b. Download Lab1C_Questions.docx from your course Doc Sharing panel, and Save the file to your local drive. 2. Using Citrix for MS Visio and/or MS Access a. If you are using the Citrix remote lab, follow the login instructions located in the iLab tab in Course Home. b. You will have to upload the Lab1_Nwind.accdb file to your
Continue Reading
View Writing Issues

You May Also Find These Documents Helpful

  • Good Essays

    NT2670 Lab1 2
    • 1472 Words
    • 7 Pages

    NT2670 Lab1 2

    Each lab in this manual requires that you answer questions, save images of your screen, or perform other activities that you document in a worksheet named for the lab, such as lab1_2_worksheet. Your instructor will provide you with the worksheet files that you must complete for each lab. As you perform the exercises in each lab, open the appropriate worksheet file using WordPad, fill in the required information, and save the file to your…

    • 1472 Words
    • 7 Pages
    Good Essays
    Read More
  • Satisfactory Essays

    DBM 380 (Data Base Management) Complete Course Material Essay Example
    • 395 Words
    • 2 Pages

    DBM 380 (Data Base Management) Complete Course Material Essay Example

    DBM 380 (Data Base Management) Complete Course Material Click on The Link Below to Purchase A+ Work http://hwminute.com/downloads/dbm-380-data-base-management-complete-course-material/ DBM 380 Week 1 DQ 2.docx DBM 380 Week 1 DQ 1.docx DBM 380 Week 1 Individual Assignment Database Design Paper.docx DBM 380 Week 2 DQ 2.docx DBM 380 Week 2 Individual Assignment; Database Management Systems Paper.docx DBM 380 Week 2 DQ 1.docx DBM 380 Week 3 DQ 1.docx DBM 380 Week 3 DQ 2.docx DBM 380 Week 3 Individual Assignment Driving Log.accdb DBM 380 Week 3 Individual Assignment Driving Log.zip DBM 380 Week 3 Individual Assignment ERD.pdf DBM 380 Week 3 Individual Assignment ERD.zip DBM 380 Week 3 Individual Assignment.zip DBM 380 Week 3 Individual Assignment ERD.pdf DBM 380 Week 3 Individual Assignment ERD.zip DBM 380 Week 4 DQ 1.docx DBM 380 Week 4 DQ 2.docx DBM 380 Week 4 Explaination Of Normalization.docx DBM 380 Week 4 Individual Assignment ERD.zip DBM 380 Week 4 Indiviual Assignment Driving Log Relationships.accdb DBM 380 Week 4 Indiviual Assignment Driving Log Relationships.zip DBM 380 Week 4 Individual Assignment ERD.pdf DBM 380 Week 5 DQ 1.docx DBM 380 Week 5 DQ 2.docx DBM 380 Week 5 LT Database FINAL.accdb DBM 380 Week 5 LT Database FINAL.zip DBM 380 Week 5 LT Huffman PowerPoint REVISED.pptx DBM 380 Week 5 LT Huffman Trucking SR-ht-003.docx DBM 380 Week 5 LT Huffman Trucking SR-ht-003.docx $30.00 – Purchase DBM 380 (Data Base Management) Complete Course Material Click on The Link Below to Purchase A+ Work http://hwminute.com/downloads/dbm-380-data-base-management-complete-course-material/ DBM 380 Week 1 DQ 2.docx DBM 380 Week 1 DQ 1.docx DBM 380 Week 1 Individual Assignment Database Design Paper.docx DBM 380 Week 2 DQ 2.docx DBM 380 Week 2 Individual Assignment; Database Management Systems Paper.docx DBM 380 Week 2 DQ 1.docx DBM 380 Week 3 DQ 1.docx DBM 380 Week 3 DQ 2.docx DBM 380 Week 3 Individual Assignment Driving…

    • 395 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Good Essays

    CMGT 400 Week 1 DQs
    • 676 Words
    • 3 Pages

    CMGT 400 Week 1 DQs

    The project for CIS336 is designed to touch all aspects of the fundamental concepts of database design and logical data modeling covered during the class. The project is team centered and each team will be responsible for designing, developing, and demonstrating the functionality of a database created based on a defined set of business specifications. At the end of the session, each project team will submit the database designed by the team and demonstrate the database's ability to deliver the required information as outlined in the project specifications. All aspects of the project will be ...…

    • 676 Words
    • 3 Pages
    Good Essays
    Read More
  • Satisfactory Essays

    Ilab Instructions
    • 2258 Words
    • 10 Pages

    Ilab Instructions

    Relying on detailed instructions, create a simple conceptual model for a two-table database using MS Visio.…

    • 2258 Words
    • 10 Pages
    Satisfactory Essays
    Read More
  • Satisfactory Essays

    DBM 380 Week 1 Individual Database Design Paper
    • 352 Words
    • 2 Pages

    DBM 380 Week 1 Individual Database Design Paper

    • Define relational database architecture. Consider Microsoft® Access*', Microsoft SQL Server®', Oracle®, IBM DB2®, and so on.…

    • 352 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Satisfactory Essays

    BU224 unit 1
    • 893 Words
    • 4 Pages

    BU224 unit 1

    3. Insert your answers below, or in the appropriate space provided for in the question. Your answers should follow the APA format with citations to your sources and, at the bottom of your last page, a list of references. Your answers should also be in Standard English with correct spelling, punctuation, grammar, and style (double spaced, in Times New Roman, 12-point, black font). Respond to questions in a thorough manner, providing specific examples of concepts, topics, definitions, and other elements asked for in the questions.…

    • 893 Words
    • 4 Pages
    Satisfactory Essays
    Read More
  • Satisfactory Essays

    BIS 220
    • 808 Words
    • 4 Pages

    BIS 220

    With the advancements in technology we all are introduced to new or improved forms. There are times when advancing and learning of new technologies is a wonderful thing as long as one can also retain new information along with previously learned knowledge. In last week’s teachings we have learned new functions and capabilities as well as had a refresher course on the Microsoft PowerPoint program. Along with this informative we have also learned of the importance of the system development life cycle (SDLC) in regards to the planning, organizing, and implementing of information systems to include the project management of IT acquisitions, hardware and software selections.…

    • 808 Words
    • 4 Pages
    Satisfactory Essays
    Read More
  • Satisfactory Essays

    Bis 220
    • 454 Words
    • 2 Pages

    Bis 220

    In opening a new business we must take a look at the types of information systems to use to launch our business out the public. As a new nostalgic record store we must see ways for us to buy and sell records. In this summary I will be proposing two types of information systems with descriptions of each type and why it would be best suited for our record store.…

    • 454 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Powerful Essays

    Assignment1
    • 354 Words
    • 5 Pages

    Assignment1

    What problem would you encounter if you tried to create a listing by last name?…

    • 354 Words
    • 5 Pages
    Powerful Essays
    Read More
  • Good Essays

    ba245
    • 1404 Words
    • 4 Pages

    ba245

    Bryant Adam. “Hannah Paramore, on keeping Strengths from Running Amok “The New York Time Business Day…

    • 1404 Words
    • 4 Pages
    Good Essays
    Read More
  • Satisfactory Essays

    Efficiency and Collaboration Proposal
    • 400 Words
    • 2 Pages

    Efficiency and Collaboration Proposal

    Possessing the right collaborative tools when conducting business is essential; we have been using Microsoft Excel at Party Plates for quite some time now. In the search for a database that will be more compatible to hold and organize the data of the company, the capabilities of Microsoft Access will be what we are looking for. We want to highlight some keys elements that would help us in making that for the future of our business.…

    • 400 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Satisfactory Essays

    Ist 7060 Project Scope And Communication Research Paper
    • 550 Words
    • 3 Pages

    Ist 7060 Project Scope And Communication Research Paper

    4. Technical requirements: - Latest SQL server i.e., SQL server 2014 sp1 (basic SQL commands), the latest version of Microsoft Visio 2013, Microsoft excel 2013 and Oracle Database 10g were the technical requirements of this…

    • 550 Words
    • 3 Pages
    Satisfactory Essays
    Read More
  • Good Essays

    Data Modeling Tools
    • 498 Words
    • 2 Pages

    Data Modeling Tools

    Visio 2003 provides specific solutions for Database diagrams that support the IDEF1X modeling technique, relational notations, object-relationship models, entity-level and schema-level diagrams, and product data models using EXPRESS-G notation. Diagrams can be created by dragging shapes to a drawing page or by reverse engineering an existing database structure from a variety of compatible databases, including Microsoft SQL Server™, Microsoft Access, Oracle, and IBM's DB2.…

    • 498 Words
    • 2 Pages
    Good Essays
    Read More
  • Good Essays

    Data Analysis and Data Modeling in Visio
    • 1049 Words
    • 5 Pages

    Data Analysis and Data Modeling in Visio

    This section will explain how to use Microsoft Visio to create conceptual Entity-Relationship data models. Microsoft Visio has built-in database tools for creating logical data models (those that apply the relational database theory to your entity-relationship diagrams), and not very good at conceptual modeling. As a result, using the MS Visio database tools to create the conceptual model diagrams can sometimes feel like trying to jam a round peg into a square hole.…

    • 1049 Words
    • 5 Pages
    Good Essays
    Read More
  • Good Essays

    Sql Server
    • 973 Words
    • 4 Pages

    Sql Server

    The purpose of this paper is to provide a comprehensive review of the SQL Server 2005 Express Edition for Beginners tutorial. The SQL Server 2005 Express database tutorial helps users understand what a database is, it explains how to create tables within a database and how users can covert flat databases into relational databases. This tutorial was basically designed to give users the basic knowledge of creating data bases. Databases are nothing more than a collection of files that work together to store data in a structured way. Some databases are made up simple files and others may require that severs manages connections to files within in a database to authenticate users that’s accessing those files. One of the main focuses of databases is how well organizations manage their database and maintains the accuracy of their data. Companies may want to use databases instead of text files because they provides them with more efficient data integrity, they can store more data, they can retrieve data in multiple ways, databases also provides organizations with the ability to protect their data from unauthorized users and protects their data from being corrupt. Relational Database Management Systems makes managing data for companies easier and it takes care of the difficult tasks associate with integrating data into their applications. Relational databases are the most common type of databases that are used today. The eliminate data redundancy which could cause companies to enter inaccurate data into their databases. Before relational databases were created data was managed by mainframe computers and the storage capacity was limited and very expensive to maintain. Relational databases reduces the amount of space on reel-to-real tapes that each database record required and they also reduced the cost of storing data and provided data integrity. Data integrity refers to the accuracy of the data that organizations are storing. With relational databases…

    • 973 Words
    • 4 Pages
    Good Essays
    Read More

Related Topics