[Solved] Draw Entity Relationship Diagram Least A4 Size Important Criteria Clarity Readability Enti Q37244619
Draw a Entity-Relationship Diagram. It should be at least A4size.The important criteria are clarity and readability.Entities in the ERD should fully represent the informationcontained in the data. That is, include all the attributesand any other necessary information. It should conform to theUnified Modelling Language.
PLEASE base the design on the description, that is,treat the description like requirements. Failure to adhere to thedescription is very poor professional practice
Description
The car hire firm Wheels-4-U, requires a database system tomanage their fleet of hire vehicles. Each vehicle in the fleet hasa unique fleet membership number (N 3). Also recorded is thevehicle’s registration number (S 7), colour (S 20), and make (S 8)and model (S 8). Along with the make and model combination, alsorecorded is the number of doors (N 1), body style (hatch, sedan,SUV, or coupe), and trim level (standard, sport, luxury).
Each Wheels-4-U depot has an identification code (N 2). Alsorecorded is the depot’s address (A), 1 to 4 phone numbers (S 14),and a fax number (S 14). The current location (depot) of vehiclesavailable for hire is recorded.
Wheels-4-U has several different types of daily hire tariffs,for example, depending on the type of driver (e.g. under 21) orvaried driving locations (city or country). For each type, anidentification code (S 2) is recorded only with a description ofthe conditions under which it applies (S 50). For each make/modelof car, the daily rental tariff ($ 3) is recorded for each of thetariff types.
When a vehicle is hired, the depot from which it is hired, thehire time and date (D) are recorded. The intended drop off depotalso recorded. The hirer (client) involved is recorded along withthe type (S 2) and number (S 20) of the credit card to be used topay for that hire. (For security reasons neither cash nor chequesare accepted by Wheels-4-U.) There will be one person recorded asbeing the nominated driver of the hired vehicle (this does not haveto be the hirer). A vehicle’s kilometreage (N 5) (distancetravelled) is recorded when it is hired. At any one time only onevehicle is on hire to a customer. Also recorded is the applicabletariff type and the number of hire days (N 2). Optional insurancemaybe taken for each hire. An insurance policy number (N 5), policytype (excess reduction, excess removal, or full cover) and cost ($3) is recorded.
A make and model of vehicle may also be booked for a futurehiring, in which case, the nominated pick-up depot, the startingtime and date for the booking (D), and the intended number of hiredays (N2) are recorded. An optional preferred colour (S 12) may berecorded. A client may make any number of bookings.
Wheels-4-U records the individual details of any client thefirst time that the person or the company has business with thecompany. A client’s name (C), address (A) and one or two contactphone numbers (S 14) are recorded along with a generated uniqueclient identifier. This identifier is used for all subsequentreferences to that client. If the client is a company, they musthave a (single) nominated person also recorded as theirrepresentative. The details of such representatives are recorded asthough they were person clients. A (person) client’s driver’slicense number (S 12) is recorded the first time that they hire avehicle or are a nominated driver.
For each vehicle, a service history is kept. It contains foreach past service, (scheduled or repair service), the date (D), thecost ($ 4), a service description (S 50) and the identification ofthe depot where the servicing was done. A vehicle may have had noneor several past services. For all vehicles, the next scheduledservice has the associated kilometrage (N 5), date-to-be-done-by(D) and the depot to do the servicing recorded.
Only after the vehicle is returned an invoice is generated forthe vehicle hired (with a unique invoice ID (N 10) that containsthe details or the hirer (and company if applicable), the vehiclehired, the return depot, an indication that the vehicle passed aquality check (a ‘Yes’ or ‘No’) and the final cost ($ 5) based onthe number of days and the daily rental tariff. The date paid (D)is also recorded and if it has not been recorded the invoice isconsidered unpaid.
Expert Answer
Answer to Draw a Entity-Relationship Diagram. It should be at least A4 size.The important criteria are clarity and readability. En… . . .
OR
