University Database Design: QRentals ER Diagram and System Design

This document presents a comprehensive solution to a database design assignment for the QRentals car rental system. The assignment focuses on developing an Entity Relationship (ER) diagram to model the database's conceptual schema. The solution includes an ER diagram, assumptions, and business rules that guide the design process. The assumptions cover customer documentation, employee assignments, database administrator responsibilities, and insurance policies. The business rules address car categorization, rental cost recording, system processing time, and the importance of detailed data recording for business improvement. The document also provides a bibliography of relevant academic sources used in the development of the database design.

Running head: DATABASE DESIGN AND DEVELOPMENT
Database Design and Development: QRentals database system
Name of the Student
Name of the University
Author’s Note

1
DATABASE DESIGN AND DEVELOPMENT
ER Diagram
Assumptions and Business rules
The following assumptions are made for the development of the ER Diagram.
 The customers have all the necessary document and the licence that is required
for booking the car from the QR Rental system.
 It is also assumed that more than one employee is assigned to a car for the
management of the service and delivery of the car to the customer who have
booked the car for rental.

2
DATABASE DESIGN AND DEVELOPMENT
 It is assumed that the database administrator would add the details of the
customer and the employee accurately in the database table for the
management of the errors in the database.
 It is assumed that each of the car is insured with an insurance policy and the
information system is used for recording the details of the insurance for
reducing the effort of management.
The business rules identified for the development of the information system are listed
below:
 Categorizing the cars into different segments such as SUV, Sedan, Luxury
limos, etc. and the location of the parking of the car should be recorded into
the information system for increasing the security of the cars.
 The cost of hiring the cars should also be recorded for the calculation of the
rental cost.
 The processing time of each of the request of the customer or the employee
using the system should be minimum and the database tables should be
connected with each other using the foreign key such that the accurate result
of the query can be generated.
 All the details of the cars, employees and the customers should be recorded in
the database such that it can be used by the organization to improve the current
business process.

3
DATABASE DESIGN AND DEVELOPMENT
Bibliography
Arasu, A., Babcock, B., Babu, S., Cieslewicz, J., Datar, M., Ito, K., Motwani, R., Srivastava,
U. and Widom, J., 2016. Stream: The stanford data stream management system. In Data
Stream Management (pp. 317-336). Springer Berlin Heidelberg.
Bhatt, S., Manadhata, P.K. and Zomlot, L., 2014. The operational role of security information
and event management systems. IEEE Security & Privacy, 12(5), pp.35-41.
Buede, D.M. and Miller, W.D., 2016. The engineering design of systems: models and
methods. John Wiley & Sons.
Dabbagh, M. and Lee, S.P., 2014. An approach for integrating the prioritization of functional
and nonfunctional requirements. The Scientific World Journal, 2014.
Dennis, A., Wixom, B.H. and Tegarden, D., 2015. Systems analysis and design: An object-
oriented approach with UML. John Wiley & Sons.
Di Sarno, C., Garofalo, A., Matteucci, I. and Vallini, M., 2016. A novel security information
and event management system for enhancing cyber security in a hydroelectric dam.
International Journal of Critical Infrastructure Protection, 13, pp.39-51.