Project 4 — E/R Diagrams

 

Academic Integrity: I completed this project without the assistance of others. I understand that cheating, helping others to cheat, or failing to report such actions is dishonest and wrong. Such acts could result in disciplinary action against me.

 

· Email your solution in an attached PDF file to both the instructor and the TA.

· The subject should be

“Project4 - " + Your First Name + Last Name e.g. Project4 - JohnDoe

· Your file name should be

“Project4 - " + Your First Name + Last Name + ".PDF” e.g. Project4 - JohnDoe.pdf

· Include your name inside the PDF file.

· For full credit, your assignment must be received by 11:59 pm on the due date.

 

For the following business artifacts, do the following:

· Draw an E/R diagram

· Reduce the diagram to relation schemas

· List all functional dependencies, i.e, all the primary keys and which of the other attributes are determined by them. ( student.id => name, tot_cred)

 

In your E/R diagram be sure to include the following (when applicable) :

Entity Sets

Attributes

  Atomic

  Composite

  Multi-valued

  Derived

  Primary Keys

Relationships

  Roles

  Participation

  Cardinality

Weak Entity Sets

  Discriminators

  Identifying Entity Sets

 

Moonlight Café—Receipt (25 points)

 

Moonlight Café—Price List (25 points)

 

Mulch Dispatch and Delivery System (50 points)

Mulch Delivery and Dispatch System Description

 

Mulch Order Data

Mulch Order Reports

 

Student Questions and Clarifications

 

 

DESIGN

1. List all functional dependencies and constraints that you see in the system

2. Build an ER diagram to include all database structures to support the functional requirements

3. Reduce the diagram to relation schemas