See the glossary and index of your book for term definitions, but DO NOT copy and paste. Write them in your own words.

  1. Why is it not possible to represent N:M relationships with the same strategy used to represent 1:N relationships?
  2. What is an associative entity?  What is an association relationship?  Give and describe an example of an association relationship other than one shown in the textbook.  Illustrate your answer using an IE Crow’s Foot E-R diagram.
  3. Give and describe an example of a 1:N relationship with an ID-dependent weak entity, other than one shown in the textbook. Illustrate your answer using an IE Crow’s Foot E-R diagram.
  4. Create a relational database design for the data model you developed for question 5 in Assignment 6 (from last week). (Remember that in a database design you cannot have N:M relationships. You must use intersection tables.) For each entity in the E-R model (Illustrate your answer using an IE Crow’s Foot E-R diagram), specify a table structureshowing the data types, additional column properties, and identify all primary and foreign keysAlso document referential integrity constraint enforcement actions and any business rules that you think are important.
  • Use Microsoft Visio to create your Crow’s Foot Diagrams and Access to show your database model.
  • Please submit your assignment as a Word document with accompanying Visio and Access files (required). 
  • Give the Visio and Access files names that include your last name so I can identify them from other student files.
  • Number and restate each question before your answer in your Word doc. 
  • This assures that you answer each question and that I know which question you’re answering.
  • Paste cropped screen shots of the Visio diagrams and screen shots of the SQL Statements into the Word document and make sure they are legible.
  • Submission of all work is expected to look professional. Neatness and clear organization are taken into consideration when grading all assignments.