Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Business rules, and ER diagram with cardinality. TWO E-R diagrams for this problem) Instructions for Problem 1: (1) Create business rule(s) for the assigned business
Business rules, and ER diagram with cardinality. TWO E-R diagrams for this problem) 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 Problem scenarios for Prob 1: You are assigned ONE problem (by last name) from the following (all have associative entity) Last Name A-G H-P Q-Z Business Scenario 1. DRIVER receives ClITATION, POLICE issues CITATION 2. TUTOR has APPOINMENT. STUDENT comes to APPOINTMENT 3. CUSTOMER books RENTAL-CONTRACT, CAR is rented in RENTAL-CONTRACT 4. STUD-ORG makes BOOKING (of ROOM), ROOM is booked in No-credit exercises BOOKING 5. (Library) PATRON has CHECK-OUT, BOOK appears in CHECK-OUT 1) All entities are in CAPS 2) No attribute except keys (PK, FK) 3) All relationships are already given; please do NOT introduce" your own relationship in other words, ONLY depict what is explicitly given
Step 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