Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Readings In Database Systems

Authors: Michael Stonebraker

2nd Edition

0934613656, 9780934613651

More Books

Students also viewed these Databases questions

Question

2. Use a point system or model papers when grading essays.

Answered: 1 week ago