" Advanced Database " Please anyone can assest me with this?

Case Study.

VFR Renting is a nationwide vehicle rent company that provides vehicles for customers to rent. A rent agreement between the company and the customer set out the terms of the rent such as the rent period, rent charges and the restrictions of use. Vehicles can be either cars or vans. Both have attributes make, model, year made, license plate no, cost, odometer, maximum speed and number of passengers. Information specific to car is car class (standard, luxury, executive) whereas for mini vans are no of seaters. Rental charge for car depends on the car model (Vios, MyVi, City and etc.) and rental period (daily, weekly, monthly) whereas rental charge for van depends on model (Hiace, Quest, Odyssey and etc.) and rental period same as car. VFR Renting has one depot and one rent point in every major city. Vehicles are stored at a depot unless they are on rent to customers. A rent point is a place where a customer collects and returns their rent vehicle. One rent point has access to several depots and each depot may supply vehicles to many rent points. Employees of VFR Renting work at either a depot or at a rent point. Depot employees are mainly employed preparing vehicles for rent which may involve repairing or maintaining vehicles. Rent point employees are mainly office staff involved with sales and marketing. Depot employees do not move but rent point employees frequently move from one rent point to another as demand for workers varies. Note: You need to justify any additional assumption that you introduce.

1) Develop an E/R diagram using Crow Foot notation that you learn in the course for the case study described above. Make sure to indicate all cardinality constraints specified above. The E/R diagram should not contain redundant entity sets, relationships, or attributes. Also, use relationships whenever appropriate. You will be expected to use advanced modeling techniques (EER diagram)

Note: If you need to make any assumptions, include them in your answer.

2) Map the ER or EER diagram you created in part 1) into a set of relational tables at least in 3NF clearing showing the primary keys, foreign keys and attribute/column names assigned to each relation. You will be expected to justify any mapping issues by showing all the steps.