12 May Given the following business rules for the Happy Customer Garag
Given the following business rules for the Happy Customer Garage: 1. A customer can own many cars. 2. Some customers do not own cars. 3. A car is owned by one and only one customer. 4. A car may generate one or more maintenance records. 5. Each maintenance record is generated by one and only one car. 6. Some cars have not (yet) generated a maintenance procedure. 7. Each maintenance procedure can use many parts. (Comment: A maintenance procedure may include multiple maintenance actions, each one of which may or may not use parts. For example, 10,000-mile check may include the installation of a new oil filter and a new air filter. But tightening an alternator belt does not require a part.) 8. A part may be used in many maintenance records. (Comment: Each time an oil change is made, an oil filter is used. Therefore, many oil filters may be used during some period of time. Naturally, you are not using the same oil filter each time – but the part classified as “oil filter” shows up in many maintenance records as time passes.) Tasks a. Draw an ER diagram showing the manager’s conceptual view of Happy Customer Garage. (5 marks) b. Using Crow’s Foot notation, transform the ERD into a normalised, logical, (relational) model, resolving any M:N relationships, and showing connectivity and cardinality. Add appropriate attributes to each relation and define primary and foreign keys. (5 marks) c. Summarise your proposed implementation in a simple data dictionary in tabular form, showing all designer-defined objects in the database including indexes on the customer name in the CUSTOMER table and product name in the PRODUCT, a SEQUENCE to generate unique maintenance record numbers starting from 1000, and a TRIGGER that sets a flag when a part’s quantity on hand falls below a designated minimum. The data dictionary should show the data types and any constraints on attributes. (5 marks) d. Provide a SQL script file to define the database…
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.