Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Draw and ER diagram that reflects the following elicited data requirements. The ER diagram must be drawn using word and abiding to the ER notation

image text in transcribed
Draw and ER diagram that reflects the following elicited data requirements. The ER diagram must be drawn using word and abiding to the ER notation presented in the lectures/book 1. You are asked to create a database for a busing company. You need to keep track of the differ- ent buses, each having a plate number, make year, and number of seats. You also need to keep track of drivers that work in the company. The information kept on each driver should include the license number, age, and name. Drivers cannot drive any bus, but rather each driver is as- signed with specific buses in the fleet he/she is allowed to drive (different drivers are permitted to drive different buses). Accordingly, a driver may be allowed drive many different buses, and a bus can be driven by many different drivers

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

Recommended Textbook for

Mastering Real Time Analytics In Big Data A Comprehensive Guide For Everyone

Authors: Lennox Mark

1st Edition

B0CPTC9LY9, 979-8869045706

More Books

Students also viewed these Databases questions

Question

2. Are my sources up to date?

Answered: 1 week ago