Exercise 2 – Database Design
1. Use Microsoft Access to create TWO “BLANK databases” including all the tables for the TWO database designs shown on page 2 and page 3 of this document. Pay attention to the following two points while creating the tables for the two databases:
a. Use “Short Text” as the data type for the Primary Key attribute in EVERY table. For other attributes, choose the data type by using your judgment / common sense about the type of data being stored there; for example, StudentFname will be “Short Text” type while UnitPrice will be “Currency” type. Likewise, OrderQty will be “Number” type.
b. DO NOT use “AutoNumber” datatype for ANY attribute including the primary keys.
2. Create the TWO relationship diagrams among the tables in the two database files created in step 1. Pay attention to the following points while creating the relationships among tables for the two databases:
a. Note that every table must have the Primary Key correctly setup for the relationship diagram to be accurate.
b. While connecting the primary key to a foreign key, please note that sometimes the names of the primary key and foreign key may be different
c. All the attributes in each table must be clearly visible with no extra white space AND no scroll bar.
d. Make sure you save Each database file by prefixing the current name of the file with your FirstName_LastName.
3. For each database file, make a snip of the relationship diagram using the “snipping tool” just like we did earlier for exercise 1. Paste the snipped image onto a MS-Word file. You will have TWO images for relationship diagrams from the two databases. Below every image include a caption with a Figure number. Save the word file as your FirstName_LastName_Exercise2.
4. Double check everything before submitting the assignment.
5. Upload on Canvas the two database files and the MS-Word file with the snipped images. In total you will upload THREE files.
