Q Purpose of this assignment The purpose of this assignment is to model data related to a given business environment, implement a database using a standard database management system, and issue SQL queries. Students must also answer detailed multiple choice questions about database concepts and operations. Description of assignment This assignment consists of the following: • Part 1: Developing an Entity Relationship (ER) diagram for a given project description • Part 2: Implementation of a matching database for the above ER diagram • Part 3: Writing SQL queries Part 1: [subtotal 40 marks] Create an ER diagram for a vehicle rental company. Vehicles are categories in to three classes; motor bikes, cars, and trucks. Trucks are of two types; light and heavy. The heavy trucks that are longer than 5 meters require a Medium Rigid Licence to drive. Customers are required to show their driver's licence and the credit card to book a vehicle. The company gets the address, phone number, and driver's licence number and credit card information from the customer. Customers can rent with an excess fee or without any excess fee which increases the rate. Rates are determined based on the car make and model, duration of rent, as well as the time of the year. For instance, the rates are 1.5% higher during school holidays. The car rental company has several branches with a number of staff members in each. Each branch has a manager in duty. A group of branches in an area have an area manager. The decision to offer discounts is made by a branch manager if the discount is greater than 10%. Customers who book online receive a 10% discount on the total cost of their rent. Employees of the company can also be customers and they will receive a 20% discount. Vehicles have to go through services after certain mileage. A report of vehicles the due dates of which are in the next 7 days needs to be generated every day. Part 2: [subtotal 30 marks] Create a database using MS Access that implements the specifications of your ER diagram. You should insert sufficient data into all of your tables so that you can test all of the SQL queries in B.3. For this part, you will need to submit your SQL codes that create the database schema (the database, tables, and relationships), and a set of SQL insert statements for the data records that you add to your tables. Part 3: [subtotal 5x6=30 marks] Write SQL statements for each of the following queries and insert the SQL code below each question in your submission. 1. Display employees who are also customers 2. Display the name of the employees who offered most discounts to customers 3. Display the make and model of the vehicle with the highest number of rents per branch 4. Display the employee who rented out most vehicles in each branch 5. Display vehicles the registration due dates of which are in the next 5 days (use the DATE function)