You may complete this assignment as a team of two or individually, your choice.
You may complete this assignment as a team of two or individually, your choice. Either way, you must sign up for a Database Assignment Group in Canvas People in order to submit your answer to this assignment. If you choose to do this assignment by yourself, you will be a group of 1.
Objective:
Create a relational database for Monty’s Appliance Repair Services invoicing process and represent the database as an ERD using Crow’s feet notation.
Information about Acme’s Invoicing Process:
Monty’s customer product pricing is based on various factors, therefore the price for a particular service may vary from customer to customer. Monty bills for only one repair order per invoice, but there could be multiple invoices per repair if the technician needs to complete the repair in stages. Customers may have multiple appliances, but each appliance requires a separate repair order because different technicians may handle the repairs.
These are the attributes that Monty stores in its invoice files:
- customer address
- appliance serial number
- appliance description
- customer contact
- customer name
- customer number
- date of order
- date repaired
- employee name
- employee number
- invoice date
- invoice number
- item description
- item number
- item type (service or part)
- item UoM (unit of measure, such as hour or each)
- payment terms
- payment terms ID
- price per unit
- quantity on hand (for parts)
- quantity sold
- repair order number
Required:
- Design a set of relational tables to store this data. Hint: You should have 8 or 9 tables.
- Identify the primary key for each table.
- Identify any foreign keys.
- Draw an ERD using crow’s feet formatting to show the relationships and cardinality amongst the tables of the database. Make sure that the cardinalities are clearly shown. I recommend using a flowcharting tool such as Visio or Drawio to complete this assignment
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
