IT-330 ERD Exercise

Figure: see image.

You must read handout on E-R Model before answering questions in this assignment. The questions are based on an attached E-R Diagram here.

  • How many tables are used in this design?
  • How many total relationships are present?
  • Give a count of mandatory relationships.
  • Which table is a bridging entity?
  • How many M:N relationships are implemented in this design?
  • Which 2 tables have multiple relationships between them?
  • Which table has a composite primary key?
  • How many 1:1 relationships are implemented in this design?
  • How many total foreign keys are in this diagram?
  • What is the minimum number of relationships required in this database? (Not the same number as the total relationships!)
Academic Honesty!
It is not our intention to break the school's academic policy. Posted solutions are meant to be used as a reference and should not be submitted as is. We are not held liable for any misuse of the solutions. Please see the frequently asked questions page for further questions and inquiries.
Kindly complete the form. Please provide a valid email address and we will get back to you within 24 hours. Payment is through PayPal, Buy me a Coffee or Cryptocurrency. We are a nonprofit organization however we need funds to keep this organization operating and to be able to complete our research and development projects.