Assignment: Lab: Introduction to MS Visio and MS Access
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 Notation Template. The purpose of this iLab 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 databaseto exploredatabase objectsand 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 conceptualmodel without the instructions; and
3. download an existing Microsoft Access database file. Open the database;find and identify different database objects in this database.
Lab 1 Part C Questions:
1. Entities in the conceptual model eventually are converted to tables in the database, and the attributes convert to the fields within the tables. Given this information, list the attributes (fields) found in the supplier table.
2. With the Customers table sorted in alphabetical order by city, what is the name of the first customer to appear in the table?
3. Who are the customers located in the Tennessee?
4. List the tables along with the primary key for each.
5. List the tables related to the Orders table.
6. Open query Inventory on Hold by double clicking that query. What data is in this query (give the column names)? What is the Quantity on Hold for Northwind Dried Plums?