Question: Help make business rules for ERD Diagram. Example: 1. Each CONCESSIONAIRE can be assigned to operate to at least one PARK 2. Each

Help make business rules for ERD Diagram.

 

Example: 

 

1. Each CONCESSIONAIRE can be assigned to operate to at least one PARK

2. Each PARK is assigned to one and only one CONCESSIONAIRE

ERD - The City of LA Recreations and Parks Concessions PK Concessionaire 


ERD - The City of LA Recreations and Parks Concessions PK Concessionaire Concessionaire D Name Contact Information: License Number Business Type Concession Type Permit Status PK FK Concession Product/Service Product D Name Description Price Availability Status Category Concessionaire D Park Visitor Compliance Status PK Visitor Agreement Start Date Name Agreement End Date Recreational Facility Contact Information PK OFK Facility ParkiD Name Park ParkID PK Name Location Size ConcessionSpaces FK Age Interest Membership Status Park D Location Capacity Facilities Available FK Park D

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!