Answered step by step
Verified Expert Solution
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started