Including attribute data types and required fieldlengths and

2. Given a situation containing entities, business rules, and data requirements, create the conceptual model of the database using a database modeling tool.

3. Given an existing relational database schema, evaluate and alter the database design for efficiency.

You will then complete an MS Access database based on the model developed in

Visio, creating the necessary tables and relationships.

3. create a new MS Access database based on the ERD.

D. Deliverables

Lab

Part A: Create a Visio ERD from Data Requirements and Business Rules
Step 1: Open Visio
a. Open Microsoft Office, Visio application, or
Step 2: Identify and Create the Entities
3. Based on the information provided below, create the necessary entities for the Pages in Time database. If you need assistance to create the entities, refer to iLabs from Weeks 1 and 2. Pages in Time You have determined that you will need at least the following entities to resolve the relationships that exist in the data. CUSTOMERS Preferred Contact Method ORDERS Number ISBN Number Title ID Name (store data in smallest parts!) Short Biography
Step 3: Identify and Create Attributes (fields)
NOTE: Because you are creating your diagram in Visio, it will be easier to create the attributes prior to the relationships. a. Refer to the data requirements from Step 2 of this iLab. If you have not already created the attributes (fields) in your ERD, add them at this time.


Step 5: Identify the Relationships
a. Using the information below on the business rules for Pages in Time, create the relationships between the entities created in Step 2. 1. Each customer can place many orders over time, but each order is placed by only one customer. 2. Each order may include many books, and a book may be included on many orders.
End of Part A
Part B: Create the Access Database from the ERD
Preparation

Step 1: Start MS Access and Open a New Blank Database
b. Save the database as YourNameLab3. c. Note: If you are unsure how to complete any steps in this iLab, refer to the previous week's iLabs.



a. Use the information from your Visio diagram to identify and create relationships in Access.
Step 4: Determine and Specify the Data Types
a. Using the information below, select the data type for each attribute (field) in your diagram, and set the type in the attribute properties. (Refer to the Week 2 iLab if you are not sure how to do this. Where allowed, estimate the field length needed.) As the data types and field lengths are not included in the data requirements, you should make a selection based on your knowledge of the type of data and approximation of length required. The Visio and Access data type equivalents are shown below. Date/Time Currency
Step 7: Create the Relationships
a. Open the database relationships window.


Lab 3 Final Deliverables
a. YourNameLab3.vsdx (Visio Diagram)—from Lab 3 Part A
END OF LAB