Rent-a-Car is a car rental company with a large fleet of cars and it offersshort term rentalto both individual and corporate customers. To rent a car, a customer mustbe registered. If the customer is an individual, the customer name, an emailand a contact number arerequired. If the customer is a corporate customer, the company registrationnumber, the year it isestablished, email addressand a contact numbermust be supplied. If customerregistration is unsuccessful, the customer data is not recorded. Otherwise, a customer ID is generated.Individual customersthen need to supply credit card information which includes card holder name, card number,date of issue, expirydate and security code before any rental can be made. If the customer is corporate, an accountis createdfor payment purpose. The account is identified by account numberandit recordsthe outstanding balance. Arentalrequestcan be made not more than 3 months in advance. To rent, acustomer selectsa collection dateand time, a return dateand time, a collection location, a return locationand a car model.Upon a successful rental, the customer will receive a rental code. A rental status recordsthat the rental is pending collection. The other valid values for status are cancelled, not collected,collected orcompleted. The rental chargeis computed basedon the type of day(weekdays, weekends), the time periods (peak, non-peak), the rental durationand the car model. 30% of the charge are payable at the time of reservationfor an individual customer, and70% of the charge is payable upon collection.The payment is paid using the credit card ofthe individual customer. For eachpayment, the payment date, payment number, payment amount and the transaction type(either deposit, balance, extension fee, service fee orrefund) are recorded A corporate customeris sent a bill via email at the end of every month or whenever the account balance exceeds $2000. The bill should display the rentals with the corresponding charge. When a corporate payment is received, the payment date, payment number and payment amount is recorded and the balance updated.Tomake a collection, acustomer must entera rentalcode to unlocktheassigned car.               ICT330Tutor-Marked AssignmentSINGAPORE UNIVERSITY OF SOCIAL SCIENCES (SUSS)Page 3of 7A rentalcan be cancelled at least one week before collection, without incurring a penalty. If that happens, then in thecaseof a rental by individual, a refund is made to thecredit card and in the case of a rental by corporate customer, the amount is deducted from the outstanding balance. If a rental is cancelled less than one week before collection or if the car is not collected within 24 hours of the stated collection date and time, a 30%penaltyis imposed(no refund or no deduction of outstanding balance).If a car is not collected within 24 hours, the rental is automatically cancelled. Cancelled rentalsandrentals withno collectionare recorded to determine whether a customer should be blacklisted. When the customer collects the car,the car registrationnumber is recorded. A customer may choose to extend the rental periodat any time before the car is returned. The additional rental charges due to the extension is payable if the extension is successful processed. Thepayment for the extension is paid using the credit card associated with the individual customer at the time of the request or added to the account balance of the corporate customer.Aservice fee of $70 appliesonly if the extension is made less than 6 hours before the return is due. Note that the rental period cannot be shortened.The actual return dateand timewillbe recorded in the rental detailwhen the car is returned. Analyse and apply the data requirements to design a database for this new information system. Construct an ER model from the statements of requirements to represent the data model for Rent-a-Car. In your ER model, provide the relevant (i)entities, with entities name, relevant attributes and identifier (ii)relationships with maximum and minimum cardinalities and relationship name.