Ilab Instructions

2268 Words10 Pages
Lab 1 of 7: Introduction to MS Visio and MS Access Scenario/Summary: 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…show more content…
In the Database Properties pane, enter the Physical Name CUSTOMERS. The conceptual name will also change because the “Sync names when typing” check box is checked. Notice that the entity name in the entity shape on the worksheet changes as well. See below.Figure 3- b c. Click to select Columns in the Catgories list in the Properties pane, and enter the entity attributes (columns). d. Enter the Physical Name for the Customer Identification Number (CustID). The data type will automatically show the default data type, CHAR(10). Designate CustID as the primary key. Continue to add the remaining columns as shown:CustFirstName (Customer First Name)CustLastName (Customer Last Name)CustStreet (Customer Street)CustCity (Customer City)CustST (Customer State)CustPostalCode (Customer Postal Code)CustPhone (Customer Telephone)Your Visio diagram should match the image below:Figure 3- c e. Create the second entity in the same manner, beginning with dragging and dropping a second entity shape from the Shapes pane to the worksheet. Name the entity Orders.Figure 3- d f. Add the following attributes to the Orders entity: OrderNumber (Order Number) designated as primary key OrderDate (Order Date) OrderQty (Order Quantity) OrderStatus (Order Status)Your Visio ERD should now look like the one shown
Open Document