Er model - qrentals database system

Assignment Help Database Management System
Reference no: EM132099369

Assignment

ER model - QRentals database system

136_database.jpg

Assumption and Business rules

1. Customers may make enquires on booking by a phone call but actually have not made booking due to some reasons. Even though the details of customers are still kept in the system.

2. If multiple people co-hire a car, only one person is recorded as a customer.

3. If a booking is cancelled, the relevant details of booking is still kept in the system but the corresponding rental activity is not executed.

4. Not all cars are rented. For example, some luxury limos may never been rented.

5. QR assumes all cars should be parked at the locations belonging to QR's property when the cars are not being rented.

6. QR requires each employee is working at one and only one location.

7. The customers only pick up and drop off the car at the QR specified locations.

8. Each car is categorized to one and only type.

9. Each booking is processed by one employee and each booking requires to specify a category of the booked car (for example, book a minivan.)

10. The database doesn't record any damage of car during a rental activity, and doesn't record the payment in this model.

Note: 1) The attribute of car photo/image is not required to implement compulsorily in assignment 2. It could be implemented optionally.

2) There may be some other business rules that can be considered in this case study. You can list them if they make sense.

Reference no: EM132099369

Questions Cloud

Was there a dnp-prepared nurse leading the translation : Describe a situation in which a new clinical practice was put into place. Was there a DNP-prepared nurse leading the translation of the practice from research.
Define the differences in roles and education : Compare the PhD and DNP degrees. Define the differences in roles and education associated with the two degrees. Describe future opportunities for DNP-prepared.
How often are the challenges the authors discuss : How often are the challenges the authors discuss on page 195 and 196 actually issues? If you were to rewrite that section, what challenges would you include?
What is the impact of a complete rfi and rfp process : What is the impact of a well- defined and complete RFI and RFP process on identification and selection of a healthcare information system?
Er model - qrentals database system : ER model - QRentals database system - If a booking is cancelled, the relevant details of booking is still kept in the system but the corresponding rental
Review your strategic communications plan : Do your communications plan, written communication and presentation plan all align to meet the objectives of your goal? Explain how they align.
Prepare a vertical analysis of the income statement data : Prepare a vertical analysis of the 2017 income statement data for Farris Company and Ratzlaff Company in columnar form
Explain the concept of strategy : Explain the concept of "strategy" and the connection between strategic planning and competitive advantage.
Analyze the phases of group development : Evaluate dimensions of group participation, including leadership, task roles, maintenance roles, goal achievement, power, and diversity.

Reviews

Write a Review

Database Management System Questions & Answers

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd