Computer Science Design an Extended Entity Relationship Model with appropriate cardinality and appropriate entity names which can later be used in SQL to test queries and validate entity relations for...

Computer Science Design an Extended Entity Relationship Model with appropriate cardinality and appropriate entity names which can later be used in SQL to test queries and validate entity relations for the following case. The car hire company caters for both corporate and individual customer hire. Corporate customers are allocated a type, gold, silver or bronze based on the frequency of hire arranged in the contract. Vehicles on corporate and/or individual hire can be collected at any centre and dropped at any centre (with no surcharge for a different centre). Hire charges are based on vehicle classifications (e.g. Luxury Saloon, Basic Hatchback ....) Each classification will include a variety of models (e.g. Ford Fiesta 1.1, Fiat Panda ....are in the ‘Basic Hatchback’ classification). Charges for classifications are by the day. A customer collecting a car at a particular centre will be charged according to the charges for that centre.