15 Marks SECTION C Answer all sub questions in this section. Read what is required from each question carefully and answer al 15 Marks SECTION C Answer all sub questions in this section. Read what is required from each question carefully and answer all parts of the question. Begin each Answer on a fresh page, and label the question on the answer booklet clearly Consider the following business rules and information to maintain a database of Car Rental Co. (CRC): The database maintains a list of all the Cars Subcontractors, Company revenues and customers Cars are to be described by such data as make, model, year of production, and engine size, and fuel type. number of passengers, registration number, purchase price, purchase date, rent price and insurance details All major repairs and maintenance are done by Subcontractors e., franchised garages), with whom CRC has long-term agreements. Therefore the data about garages to be kept in the database includes garage names, addresses, range of Services and the ike. Some garages require payments immediately after a repair has been made, with others CRC has made arrangements for Credit facilities Company expenditures are to be registered for all outgoings connected maintenance, insurance etc Similarly, the cash inflow coming from all Sources- Car hire, car sales, insurance claims-must be kept of file. CRC maintains reasonably stable cient base. Special credit card facilities are provided for payment These customers may also book in advance a particular car. All major credit cards care accepted. Personal details (such as name, address, telephone number, driving license number) about each customer are kept in the database. These reservations can be made for any period of time up to one month with purchases, repairs Using the information supplied, represent the data requirements for your logical database schema in a single ER diagram in your answer booklet. Your ERD should: ldentify the main entity types (3 marks) Identify attributes and associate them with entity or relationship types. Represent each attribute in your ER diagram (3 marks) You can decide the names of entities, atributes and relationships UPPERCASE to name your entities camelCasing to name attributes. note, you should Please use and use Identily the main relationship types between the entity types identified in part (a) and represent each relationship on your ER diagram. marks) (3 Show the primary and foreign key attributes for each entity (3 marks) Underline all the primary keys and put FK next to all the foreign keys aShow the multiplicity constraints for each relationship identfie in part (c) using either crows-foot or UML notation (3 marks) Remember to state any assumptions necessary to support your design.

Source link

Leave a Reply

Your email address will not be published.