Question: Draw an ERD with Primary Keys, Foreign Keys, verbs that represent the relationship and mark the upper and lower bounds for each diagram. A large

Draw an ERD with Primary Keys, Foreign Keys, verbs that represent the relationship and mark the upper and lower bounds for each diagram.

  1. 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.
  2. A team can play in many championship events and a championship event will host many teams. For each team we want to capture the team name, sport, and birth year. For the championship event, we want to capture the name of the event and the event address. We also want to know the date a team plays in championship event and the result of the event.

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 General Management Questions!