Question: Write an ERD with Primary Keys, Foreign Keys, verbs that represent the relationship and mark the upper and lower bounds for each diagram. A large
Write an ERD with Primary Keys, Foreign Keys, verbs that represent the relationship and mark the upper and lower bounds for each diagram.
- A large amusement park wants to track customers to better understand how customers navigate throughout the park. The park knows the following: each customer can have multiple devices, but each device is assigned to a single customer. Each device can connect to many rides and each ride can have many devices connected to it. For each customer we want to know the customer name, address, email, and phone. For each device we want to know the name of the device, the device manufacturer, and the operating system. For each ride, we want to know the ride name and address. We also want to know the date, start time, and end time a device connects to a ride.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
