Question
Instructions for Problem 1: (1) Create business rule(s) for the assigned business scenario. You are FREE to make YOUR OWN assumptions clearly state your assumptions.
Instructions for Problem 1:
(1) Create business rule(s) for the assigned business scenario. You are FREE to make YOUR OWN assumptions clearly state your assumptions. Remember: for each relationship, you need to state from both directions.
(2) Based on the rules, create the ER diagram (ONE diagram reflecting all rules).
(3) Then make a/some change(s) in the assumptions that will lead to change(s) in cardinality (or even the relationship), and create the revised ER diagram.
Notes:
A) All entities are in CAPS;
B) No attribute except keys (PK, FK);
C) All relationships are already given; please do NOT introduce your own relationship; in other words, ONLY depict what is explicitly given.
Business Scenario:
(There will be 2 ER diagrams total)
TUTOR has APPOINMENT, STUDENT comes to APPOINTMENTStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started