08 Jun State clearly the assumptions that you made in developing
Question
Case Study: BlueRentals
BlueRentals is an organization that rents vehicles such as cars and vans. The Company has various outlets throughout the island. Each outlet has a number, address, and a manager who supervises the operation of the outlet. Each outlet is allocated a stock of vehicles for hire.
Information stored on the vehicles for hire includes: the vehicle registration number, model, current mileage, daily hire rate, and the current location (outlet) of each vehicle.
The clients may hire vehicles for various periods of time. Each individual hire agreement between a client and the Company is uniquely identified using a hire number. After each hire a member of staff checks the vehicle taking notes of any new fault(s), and the current mileage.
The Company has two types of clients: personal and business. The data stored on personal clients includes the client number, name, home address, phone number, and driving licence number. The data stored on business clients includes the client number, name of business, type of business, address, telephone, and fax numbers. The client number uniquely identifies each client and the information stored contains all past and current hire records.
Each staff member is associated with a single outlet but may be moved to an alternative outlet as required, although only the current location for each member of staff is stored. The data stored on the staff includes: staff number, name, job title and salary. The company also keeps track of the family members of the staff.
Question1:Design a detailed conceptual model using ER to define the information needs ofthe BlueRentals. Your report should cover the following
[60 marks]
- a) State clearly the assumptions that you made in developing the diagram; [5 marks]
- b) Identify all the real world entities. Give a candidate key and suitable attributes for each entity. Indicate clearly the multi- valued attributes. Show clearly the weakentities and determine its relationship with the owner entities.
- c) Identify the Super/ subtype entity available in the given scenario
- d) Identify the relationships among the entities. Indicate clearly the cardinality of each relationship. Show the attributes for each relationship, if any. Give any additional semantic feature of the relationships such as total participation or partialparticipation; [15 marks]
- e) Draw a complete ER diagram. [15 marks]
Question2:Use the ERD from Question 1 to derive the relations. Explain and justify the typesof integrity constraints that will be imposed on the proposed database.
[40 marks]
</pclass=”msonormal”>
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Writedemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.