Assignment #4

  (80 points)

  1. Read Chapter #4 "Data Modeling and the Entity-Relationship 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 an Entity-Relationship (E-R) diagram similar to the one shown below and created in the video Entity-Relationship Database Model (CC). In the video, I used the website SmartDraw to assist with creating an E-R diagram. The software Microsoft Visio could also be used. Insert a screen caption of your finished E-R diagram at the end of your review questions.

  4. Upload your file 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 an Entity-Relationship (E-R) diagram similar to the one shown above. 30 0 15 30 __/30
Total points __/80