BN204 - Database technologies - Final Assessment Trimester 3, 2020 QUESTION 1 - Data Modelling [Total: 30 Marks] Create a Crow's Foot Notation Entity Relationship Diagram (ERD) to support the following business operations: An online car hiring system wants to keep track of their customers, vehicles, vehicle_models and booking status details in order to streamline their administration and operational tasks. The company has wisely chosen to hire you as a database designer. You are required to design the data model for the new database called "Smart_Hire" that satisfies the constraints and the user view requirements given below. User view 1 requirements: Customer visits the company website online and place orders. First, customer should register by entering their credentials (email, name, phone, address, and password). System allocates unique_id to the customer. User view 2 requirement: Each vehicle is identified by the licence number and current_mileage, daily hire_date and engine size must also be recorded. User view 3 requirements: One vehicle can be booked by many customers over time and over time a customer can book many vehicles registered in the system. Then, customers place their bookings by specifying the vehicle model and date_from the vehicle is required and the returning_date. In addition to that for each booking following information must be recorded booking_ID, customer_ID, Total_price, vehicle_Licence_number. User view 3 requirements: There is a booking_status entity which will store, status_code, availability of the vehicle and full payment is received or not. User view 4 requirements: The models of each vehicle is stored in the Model entity with model_code and model name. Every model may appear zero or more times in the vehicle table. User view 6 requirements: Customer payment details will be recoded in Payment table with the following information; payment_ID, booking_ID, customer_ID and Total_payment. For each booking there can be many payments, however each payment should belong to only one booking, Page 3 of 8