Database Design and Development

This article discusses the logical design and ER diagram for database design and development. It covers various business rules and assumptions, including car parking areas, employee categories, and customer categories. The article also provides a bibliography for further reading.

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.