HomeworkLib
Question

Design an E/R diagram to model the following information about cars, rental agencies, and drivers. Drivers...

Design an E/R diagram to model the following information about cars, rental agencies, and drivers. Drivers reserve cars from rental agencies. A car is uniquely distinguished by its VIN number, and has a model name and color. A rental agency is uniquely distinguished by its name, and has an address. A driver is uniquely distinguished by his/her SSN, and has a name, address, license registration number, and age. A driver can reserve any number of cars, and each of these cars could be reserved through different rental agencies. Any given car is rented through a unique rental agency (which presumably owns the car). Every reservation is for a unique car, handled by a unique rental agency, and can list up to 10 (designated) drivers. However, a reservation must have at least one driver.

engineering   Computer-Science   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

ERD has been designed for car rental by agencies to drivers scenario

The Entities and their relationships identified are

  1. Car Rental Agency ( Rental_Agency_ID is the primary key)
  2. Car (VIN is the primary key and Rental_Agency_ID is the foreign key referencing Car Rental Agency )
  3. Driver (SSN is the primary key)
  4. Car Reservation (Reservation_ID is the primary key while Rental_Agency_ID, SSN, VIN are foreign keys referencing Car Rental agency , Driver and car entities )
  5. Many rental agencies allow many reservations as many to many relatiohnsip
  6. One rental agency owns many cars as one to many relationship
  7. One car can be reserved by a driver at one particular date and time as one to one relationship
  8. Many cars has many reservations as many to many relationship
  9. One driver may reserve many cars from many rental agencies on different dates or same date when one trip is completed in a few hours or in a half day as one to many relationship

The ERD is below

0 0
Add a comment
Know the answer?
Add Answer to:
Design an E/R diagram to model the following information about cars, rental agencies, and drivers. Drivers...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Can someone who knows how to draw data model on mySQL help me out? Budget car...

    Can someone who knows how to draw data model on mySQL help me out? Budget car rental company has offices located across the continental USA. They would like to track the local address ( all pieces address, state, city, zip),and the contact phone number for that office location. They would also like information about employees working at that office including their names, date of birth, start of employment, contract phone number, and roles. Offices typically have more than one employee...

  • draw a conceptual model for the following information. The system needs to record details of all...

    draw a conceptual model for the following information. The system needs to record details of all registered vehicles driven in the local government area. A vehicle is identified by a Vehicle Identification Number (VIN). Background reading on a VIN is available from several sites such as ​AutoCheck​. The government wishes to record the type of vehicle, such as motorbike, car, truck etc, the year the vehicle was manufactured and the model such as CX3, as vehicle attributes. Vehicles are produced...

  • Create ER model to a taxi company

    The company is composed of many offices: Each office has:o A name, a city and a telephone number.o Each office has a Manager, several taxi owners, drivers and one administrative staff. The Manager is responsible for the day-to-day running of the office:1. Check the number of Jobs2. Check the number of complete jobs3. Check the number of failed jobs and the reason.Each manager has a name, ID, Office number, address, age(Less than 64) and telephone number (can have more than...

  • Design a database through an E/R diagram to store information about a flight mission planning system....

    Design a database through an E/R diagram to store information about a flight mission planning system. The aircrafts in the system have a unique id, model, width, height, maximum velocity and fuel capacity information. The aircrafts may be in two types: cargo plane or fighter. In addition to aircrafts information, cargo planes have extra information named load capacity and fighter planes have bomb capacity. The pilots in the system have name information, which consists of forename and surname. In addition,...

  • Design an E/R diagram for the following situation about books, authors, book publishers, book sellers, and...

    Design an E/R diagram for the following situation about books, authors, book publishers, book sellers, and book stores. Books have an ISBN number (the key), a name, ant type of printing (e.g. hardcover or soft cover). A book can be written by many authors and one author can write many books. Authors have an NSSF number (key) and a name. Publishers are the companies that manage the printing and production of books (e.g. ‘Prentice hall’). Publishers have a name (key),...

  • You were requested to design a database to store the data concerning a large mechanic shop....

    You were requested to design a database to store the data concerning a large mechanic shop. Your database has to store the following: For each car, you want to store the make, model, year, color, engine info, license plate, VIN (vehicle identification number), and a field for general notes. Additionally, for each car, you need to keep information about the owner. For each owner, you need to store the client ID, the name, address information, phone number, and email. An...

  • Design ER diagrams for the three problems below based on the information given. Use Visio or...

    Design ER diagrams for the three problems below based on the information given. Use Visio or another drawing program: I will not grade hand-drawn diagrams. Your diagrams will include entities, attributes, relationships, candidate keys (PKs), and cardinality and participation constraints. Use the style of ER notation shown in the ER slides (also in Elmasri & Navathe, 6th edition, Figure 7.2 and Figure 7.14). Be sure to use good naming practice with your entities, relationships, and attributes. If you make any...

  • Zipcar: “It’s Not About Cars—It’s About Urban Life” Imagine a world in which no one owns...

    Zipcar: “It’s Not About Cars—It’s About Urban Life” Imagine a world in which no one owns a car. Cars would still exist, but rather than owning cars, people would just share them. Sounds crazy, right? But Scott Griffith, CEO of Zipcar, the world’s largest car-share company, paints a picture of just such an imaginary world. And he has nearly 800,000 passionate customers—or Zipsters, as they are called—who will back him up. Zipcar specializes in renting out cars by the hour...

  • This is about database system. Thank you. Question B1 Create a Crow's Foot ERD with the...

    This is about database system. Thank you. Question B1 Create a Crow's Foot ERD with the business rules described below. Write all appropriate connectivities and cardinalities in the ERD. A music store would like to develop a database to manage information about the CDs, or vinyl collection, the customers and transactions information. It stores the relationships between artists, albums, tracks, customers and transactions. Here is the list of requirements for the database: The collection consists of albums. An album is...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT