COIT20247 - Database Design and Development Project for QRentals

This project outlines the database design and development for QRentals, a car hire service. It includes an ER diagram illustrating entities like car categories, insurance, bookings, locations, cars, people (customers and employees), and rental details. The design incorporates business rules and assumptions to efficiently track vehicles, customers, employees, and rental activities. The logical design specifies tables with primary and foreign keys, ensuring data integrity and relationships between entities. The database aims to support QRentals' enterprise management system by recording business data and facilitating efficient information queries. Desklib provides access to this and other solved assignments for students.

Running head: DATABASE DESIGN AND DEVELOPMENT
Database design and development
Name of the Student:
Name of the University:
Author Note

1
DATABASE DESIGN AND DEVELOPMENT
ER Diagram
Assumptions and Business Rules
The following business rules and Assumptions have been taken into consideration:
 There are various car parking areas which can consists of a number of cars.
 There are locations which can contain more than one employee who are involved with
the organization.

2
DATABASE DESIGN AND DEVELOPMENT
 The people are categorised into two sub categories customer and employee and the
employees are further divided into booking employees and rental employees. The
customers are divided into individual and corporate.
 The Booking employees will be concerned with the booking of the cars and the rental
employees would be concerned with the rental system of Booking Sytsem.
Logical Design
The logical design for the database is provided below:
Car Category (Category_Name (pk), Daily_Price)
Car Insuarance (Policy_Number (pk), Registration_Number (fk), Amount_Of_Premium,
Insurer_Name, Policy_Start_Date, Expiry_Date)
Car Booking (Reservation_Number (pk), Registration_Number (fk), Category_Name (fk),
Booking_Date, Booking_Description, Customer_ID (fk), Enquiry_ID (fk))
Location (Location_ID (pk), Location_Address, Location_Name)
Car (Registration_Number (pk), Maker, Model, Manufacturing_Date, Number_Of_Seats,
Location_ID (fk), Category_Name (fk), Vehicle_Image)
QR_People (People_Id (pk), People_Category, Employee_ID (fk), Customer_ID (fk))
Customers (Customer_ID (pk), IndividualID (fk), CorpotrateID (fk), Full_Name,
License_Number, Address, Phone_Number)
Employee (Employee_Id (pk), Salary, Last_Name, First_Name, DOB, Skill_Level,
Annual_Salary, Rental_Employee_ID (fk), Booking Employee_ID (fk))
Booking Employee (Booking_Employee_ID (pk), Employee_Name, Main-Duty)
Rental Employee (Rental_Employee_ID (pk), Employee_Name, Main-Duty)

3
DATABASE DESIGN AND DEVELOPMENT
Corporate Customer (Corprate_ID (pk), Orga nization_Name, ABN, Travel_Deal_Validity)
Individual Customer (Individual_ID (pk), Individual_Name,
Personal_Life_Insuarance_Details)
Enquiry (Enquiry_ID (pk), Customer_ID (fk), Issue)
Rental Details (Rebtal_ID (pk), Reservation_Number (fk), PickUp_Location,
DropOf_Location, PickUp_Time, DropOf_Location, Total_Cost, Vehicle_Image,
Rental_Employee_ID (fk))

4
DATABASE DESIGN AND DEVELOPMENT
Bibliography
Bugiotti, F., Cabibbo, L., Atzeni, P. and Torlone, R., 2014, October. Database design for
NoSQL systems. In International Conference on Conceptual Modeling (pp. 223-231).
Springer, Cham.
Elmasri, R. and Navathe, S., 2016. Fundamentals of database systems. London: Pearson.