Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Read the following narrative: Tiny's Motorcycle Maintenance is a specialist Harley Davidson mobile mechanic service. Tiny travels to the customer's (who have an Id

image

Read the following narrative: Tiny's Motorcycle Maintenance is a specialist Harley Davidson mobile mechanic service. Tiny travels to the customer's (who have an Id and a name) chosen place of service. The customer can have more than one motorcycle that Tiny services. Each motorcycle has a vehicle Identification Number (VIN), a Make, a Model, a Year of manufacture, and an engine capacity measured in cubic centimetres (CC). Each motorcycle during it's life can be owned by many different customers. When Tiny services a motorcycle he records the date, location of the service, and the Total cost of the service. Tiny also records the tasks he performs (e.g. change engine oil). Each task has a different Hourly Rate. The spare parts that need replacing are also recorded, together with the price for the part and quantity used (e.g. oil filter and sparkplugs). Many of the tasks performed and the parts required are the same when servicing different motorcycles. The Total cost for the service is calculated based on cost for each tasks performed (time taken X Hourly Rate), and the cost of parts required (quantity X unit price). Draw an ERD based on this case study. Fully expand all M:M relationships into M:1 relationships. Introduce surrogate keys where required. The ERD may be neatly hand drawn or can be created in a package such as Visio or draw.io. The symbols in the ERD must conform to the symbols used throughout all ERD lectures this semester. Clearly indicate strong and/or weak entities, all identifiers and all relationship names.

Step by Step Solution

3.37 Rating (150 Votes )

There are 3 Steps involved in it

Step: 1

Here is the Entity Relationship Diagram ERD for Tinys Motorcycle Maintenance service created using d... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Systems Design Implementation and Management

Authors: Carlos Coronel, Steven Morris

11th edition

9781305323230, 1285196147, 1305323238, 978-1285196145

More Books

Students also viewed these Finance questions

Question

Discuss how investment advisors can help their behavioral clients.

Answered: 1 week ago

Question

Identify the foreign keys.

Answered: 1 week ago

Question

List all of the attributes of a movie.

Answered: 1 week ago