Part D

EER Diagram with Assumption

• Here EER diagrams were split into two pages due to the length
• Assumptions:
  1. Assumed Interview was a weak entity based on an interview not being able to take place without reliance on the existence of a job posting, interviewer, and interviewee.
  2. Assumed employee will always be said interviewer in application
  3. assumed product_type is basically its name
  4. assumed sale would have its own OrderId, to keep track of separate orders and give it uniqueness without relying on so many external factors
  5. assumed payment is a weak entity because you cant have a payment without an employee to give it to