Assignment #2

  (80 points)

  1. Read Chapter #2 "The Relational Model".

  2. Answer 25 Review Questions at the end of the chapter. Your answers must include the page number(s) of where the topic is introduced in the textbook. To provide you an example, I have answered the first question in the link above.

  3. Create a database as described in pages 118-135 of the class textbook AND as shown the video Creating Relationships (CC). Your database must contain three tables "CUSTOMER", "CONTACT", and "PHONE-NUMBER" that have been created and populated with data. Finally, your database must contain a 1:N relationship between the CUSTOMER and the CONTACT tables AND a 1:N relationship between the CUSTOMER and the PHONE-NUMBER tables. Enter your first and last name as one of the customers. Save your database as "assignment2.aacdb". (Data)

  4. Upload both files to YOUR-CLASS-WEBSITE.   Help


Grading Rubric
Required Elements Points Possible Does not meet requirements Meets some requirements Meets or exceeds all requirements Your Score
1. Answered the Review Questions at the end of the chapter. (2 points each) 50 0 25 0 __/50
2. Created a MS Access file similar to the file created in the video that meets the requirements listed above. 30 0 15 30 __/30
Total points __/80