For each of the following scenarios, write the scenario and create the ERD and The Schema Upload the ERD solution and schema for each of the scenarios above Place each on the same submission In the College of Business at Grambling for each class, a book may be required but, in some classes, they may need more than one book However, some professors do not require books In all cases no book is used for more than one course Grambling Air maintains a fleet of planes that all fly 120 passengers Never will they fly the plane unless 2 or more passengers are assigned to the plane A passenger of Grambling Air must be assigned to a single plane Grambling Marine makes boats for profit Each boat must be assigned one engine and a one trailer type However we stock many different engines and many different types of trailers that can be assigned to each boat Not every type of trailer and engine that Grambling Marine stocks is assigned to boats Next Write a short scenario that can be modeled into an ERD You can use what we did in class as a model Try to limit your scenario to minimum of 3 and a maximum of 5 entities Place this underneath the solution for the ERD and The Schema

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Sep 24, 2024

For each of the following scenarios, write the scenario and create the ERD and The Schema. Upload the ERD solution and schema for each of

For each of the following scenarios, write the scenario and create the ERD and The Schema. Upload the ERD solution and schema for each of the scenarios above. Place each on the same submission.

In the College of Business at Grambling for each class, a book may be required but, in some classes, they may need more than one book. However, some professors do not require books In all cases no book is used for more than one course.
Grambling Air maintains a fleet of planes that all fly 120 passengers. Never will they fly the plane unless 2 or more passengers are assigned to the plane. A passenger of Grambling Air must be assigned to a single plane.
Grambling Marine makes boats for profit. Each boat must be assigned one engine and a one trailer type. However we stock many different engines and many different types of trailers that can be assigned to each boat Not every type of trailer and engine that Grambling Marine stocks is assigned to boats.

Write a short scenario that can be modeled into an ERD. You can use what we did in class as a model. Try to limit your scenario to minimum of 3 and a maximum of 5 entities. Place this underneath the solution for the ERD and The Schema.