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. Without the detailed instructions, use experience gained in creating the first model to construct a similar conceptual model 3. Download an existing Microsoft Access database file; open the database, then find and identify different database objects.
Section| Deliverable| Points|
Part B, Step 4| YourName_Lab1.vsd (Visio Diagram)| 28|
Part C, Step 6| YourName_Lab1C_Questions.docx| 12|
B. Lab Steps:
1. Get the Database from DocSharing:
a. Download the Lab1_Nwind.accdb file from your course “DocSharing” panel (Labs view) and save the file to your local drive. b. Download the Lab1C_Questions.docx from your course “DocSharing” and save the file to your local drive. 2. Using Citrix for MS Visio and/or MS Access
c. If you are using the Citrix remote lab, follow the login instructions located in the iLab tab in Course Home. d. You will have to upload the Lab1_Nwind.accdb file to your Citrix drive. Follow the instructions for uploading files to Citrix, located in the iLab tab in Course Home.
Part A: Become Familiar with MS Visio|
Step 1: Locate the Microsoft Office 2007 Applications|
a. If you are using Citrix, click on the Microsoft Office 2007 Applications folder b. If you are using Visio on a local computer, select Microsoft Office 2007 from your Program Menu | Step 2: Start Visio 2007|
a. Click on Microsoft Visio 2007, and Microsoft Visio should open like the following screen.Figure 1- a b. Click the “OK” button on the Privacy Options dialog box to enable online help and to close the dialog. You should then see the following screen:Figure b Figure 1- b
c. From the Templates Categories, click to select the “Software and Database” category. See next screen capture.Figure c Figure 1- c
d. Figure 1- d
Under Featured Templates, notice that “Database Model Diagram” is selected. Double click on the diagram inside the orange box to select this template set, or click the “Create” button on the right side of the screen. The Visio Database Model Diagram template opens as follows:| Step 3: Set Visio Database Options for Crow’s Foot Notation| a. Change Visio settings to use “Crow’s Foot” notation for the model diagrams. NOTE: This notation will most closely match the models used in your textbook. From the Database menu, select Options. Figure 2- a b. Select the Document option to display the following dialog box:Figure 2- b c. Make sure the options selected in the General tab match the selections in the above image.Options in the Table tab should match the selections in the following image:Figure 2- cNotice the options selected:Figure 2- d d. Options selected in the Relationship tab should match the following image:Figure 2- e e. Click the “OK” button to close the dialog box. Then use the Zoom tool to increase the page size to 75% as shown below.Figure 2- f
Step 4: Develop the Conceptual Model for a Two-Table Database| Now that all settings are correct, it’s time to model a simple database. The database will include two entities. a. To create the first entity, drag and drop the entity...