(Solved) : Using Answer Draw Entity Relationship Diagram Erd Diagram Hand Drawn Least A4 Size Import Q37250178 . . .
Using your answer to (a) draw up and Entity-Relationship Diagram(ERD). The diagram can be hand drawn. It should be at least A4size. The important criteria are consistency with part (a), clarityand readability.
Entities in the ERD should fully represent the informationcontained in the data dictionary. That is, include all theattributes and any other necessary information. It should alsoconform to the Unified Modelling Language specification discussedin lectures and the textbook. Using a different modelling languagewill result in a grade of Fail with a mark of 1, which allows forresubmission with a maximum mark of 50%. Using software that doesnot use UML is not an excuse.
In the case-study description the following notation is used toindicate the type of data items:
(N x) a digit string (integer) of length x
(S x) a character string of length x
($ x) x dollar digits and 2 cent digits
(C) a combination of
family name (S 20)
personal name (S 20)
title (S 4)
(A) a combination of
street address (S 45)
postcode (S 4)
(D) time and date or either
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, forexample, depending on the type of driver (e.g. under 21) or varieddriving 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, the hiretime and date (D) are recorded. The intended drop off depot alsorecorded. The hirer (client) involved is recorded along with thetype (S 2) and number (S 20) of the credit card to be used to payfor that hire. (For security reasons neither cash nor cheques areaccepted by Wheels-4-U.) There will be one person recorded as beingthe nominated driver of the hired vehicle (this does not have to bethe hirer). A vehicle’s kilometreage (N 5) (distance travelled) isrecorded when it is hired. At any one time only one vehicle is onhire to a customer. Also recorded is the applicable tariff type andthe number of hire days (N 2). Optional insurance maybe taken foreach hire. An insurance policy number (N 5), policy type (excessreduction, excess removal, or full cover) and cost ($ 3) isrecorded.
A make and model of vehicle may also be booked for a future hiring,in which case, the nominated pick-up depot, the starting time anddate for the booking (D), and the intended number of hire days (N2)are recorded. An optional preferred colour (S 12) may be recorded.A client may make any number of bookings.
Wheels-4-U records the individual details of any client the firsttime that the person or the company has business with the company.A client’s name (C), address (A) and one or two contact phonenumbers (S 14) are recorded along with a generated unique clientidentifier. This identifier is used for all subsequent referencesto that client. If the client is a company, they must have a(single) nominated person also recorded as their representative.The details of such representatives are recorded as though theywere person clients. A (person) client’s driver’s license number (S12) is recorded the first time that they hire a vehicle or are anominated driver.
For each vehicle, a service history is kept. It contains for eachpast service, (scheduled or repair service), the date (D), the cost($ 4), a service description (S 50) and the identification of thedepot where the servicing was done. A vehicle may have had none orseveral past services. For all vehicles, the next scheduled servicehas the associated kilometrage (N 5), date-to-be-done-by (D) andthe depot to do the servicing recorded.
Only after the vehicle is returned an invoice is generated for thevehicle hired (with a unique invoice ID (N 10) that contains thedetails 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 Using your answer to (a) draw up and Entity-Relationship Diagram (ERD). The diagram can be hand drawn. It should be at l…
OR