Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create an ER diagram based on the following requirements. Show entities, relationships, and attributes. Groundhog Bus - a bus charter company keeps track of: For

Create an ER diagram based on the following requirements. Show entities, relationships, and attributes. Groundhog Bus - a bus charter company keeps track of:

  • For each employed driver: fullname (composed of fname and lname), birthdate, age, unique SSN, unique dln (drivers license number).
  • For each bus owned: unique blpn (bus license plate number), make, model, year, no_of_seats.
  • For each charter assignment: unique caid (charter assignment id), datebegin, timebegin, dateend, timeend, startlocation, endlocation.

Additional requirements:

  • Each driver can be assigned to a number of charter assignments but does not have to be assigned to any.
  • Each bus can be assigned to a number of charter assignments but does not have to be assigned to any.
  • Each charter assignment must have one driver and one bus assigned to it.
  • Each driver is certified to drive one or more buses.
  • Each bus must have at least one driver certified for it.

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

Students also viewed these Databases questions

Question

What is the growth rate of GDP per capita?

Answered: 1 week ago