Read the following narrative: Tiny's Motorcycle Maintenance is a specialist Harley Davidson mobile mechanic service. Tiny...
Fantastic news! We've Found the answer you've been seeking!
Question:
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.
Expert Answer:
Answer rating: 100% (QA)
Here is the Entity Relationship Diagram ERD for Tinys Motorcycle Maintenance service created using d... View the full answer
Related Book For
Database Systems Design Implementation and Management
ISBN: 978-1285196145
11th edition
Authors: Carlos Coronel, Steven Morris
Posted Date:
Students also viewed these finance questions
-
f a ball has a maximum displament of 250 and a maximum height of 140, what was its initial angle of release ?
-
Briefly describe ASCII and Unicode and draw attention to any relationship between them. [3 marks] (b) Briefly explain what a Reader is in the context of reading characters from data. [3 marks] A...
-
Your job is identify the data files for a database Sales and Job Costing System for LongDistance Golf, Inc. LongDistance Golf, Inc. is a golf club manufacturer that produces a comprehensive line of...
-
The unadjusted trial balance of Mesa Inc., at the company's year end of December 31 follows: Additional information and adjustment data: 1. The 12-month insurance policy was purchased and was...
-
List and describe two properties of etchants.
-
Find the velocity, acceleration, and speed of a particle with the given position function. Sketch the path of the particle and draw the velocity and acceleration vectors for the specified value of t....
-
Kingston Corp., a manufacturing company, uses the perpetual inventory method for all inventory accounts. Direct materials, direct labor, and applied overhead are recorded on cost sheets similar to...
-
The Bussell Company exchanged the following assets during 2010: 1. Acquired a newer machine by paying $4,000 cash and giving up a machine that originally cost $40,000, has a book value of $25,000,...
-
What leadership styles would you use with these difficult 3 8 employees? Why? CLO 2
-
In April 2005, the SEC announced settlement with Coca- Cola Company of charges of fraud and false and misleading financial reporting. The charges arose from gallon push-ing at Coca- Colas Japanese...
-
Adjusting Entry Information 1. Depreciation has not been booked for the year. Depreciation is $10,000. 2. Unearned revenue earned as of yearend is $1,000 3. Federal Income Tax is $15,000 4. Bad Debt...
-
Below is the loan repayment schedule for the month 35 of a home loan. The borrower repays the same amount with both the principal and the interest (P&I) at the end of each month. Month Loan...
-
QUESTION #2 : The age of the internet as well as the ensuing rise of social networking in the form of FaceBook, Instagram, Twitter and TikTok has significantly changed the way individuals process and...
-
Laurie has been working full-time since graduating from Concordia's JMSB in December 2019. She is a resident of Quebec and is looking to make her first Registered Retirement Savings Plan (RRSP's)...
-
How would I go about making a dequeue method given that we have _front _rear and _size variables as well as a linkedList to stare it in. assuming all test cases should pass public T dequeue() { //to...
-
Mark opens his own company and completes the following transactions in May: 5/1 Mark invests $14,000 into the business. 5/3 Purchased $3,800 of equipment on account. 5/4 Paid $560 premium for a...
-
Paulo is using probability distribution to determine the time to use for a particular activity on his project. He estimates that if he puts his best workers on the task that they will finish in 8...
-
One Way Cellular accountants have assembled the following data for the year ended September 30, 2014: Prepare the operating activities section using the indirect method for One Way Cellulars...
-
Identify the foreign keys.
-
List all of the attributes of a movie.
-
What is data analytics? Briefly explain explanatory and predictive analytics.
-
Full IFRS and IFRS for SMEs do not permit recognition on the income statement of extraordinary items. What are the rules in the United States for extraordinary items? Evaluate the pros and cons of...
-
IFRS for SMEs has been referred to as IFRS lite. One of the differences between full IFRS and IFRS for SMEs is that full IFRS allows for judgment in making choices about proper accounting, whereas...
-
The 2009 European fraud survey cautions against the manipulation of asset impairment writedowns due to the subjective factors used and judgment needed to draw conclusions about the proper amount of...
Study smarter with the SolutionInn App