Read the following narrative: Tiny's Motorcycle Maintenance is a specialist Harley Davidson mobile mechanic service. Tiny...

Transcribed Image Text:

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. 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. 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.

Answer rating: 100% (QA)

Based on the provided narrative here is an EntityRelationship Diagram ERD representing the Tinys Mot... View the full answer