Learning Goal: I’m working on a business question and need an explanation and an

Place your order now for a similar assignment and have exceptional work written by our team of experts, At affordable rates

For This or a Similar Paper Click To Order Now

Learning Goal: I’m working on a business question and need an explanation and answer to help me learn.
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

For This or a Similar Paper Click To Order Now

Leave a Comment

Your email address will not be published. Required fields are marked *

Why Choose Us

A descriptive paragraph that tells clients how good you are and proves that you are the best choice that they’ve made. This paragraph is also for those who are looking out for a reliable car repair.

Top Quality and Well-Researched Papers

We always make sure that writers follow all your instructions precisely. You can choose your academic level: high school, college/university or professional, and we will assign a writer who has a respective degree.

Original & Confidential

We use several writing tools checks to ensure that all documents you receive are free from plagiarism. Our editors carefully review all quotations in the text. We also promise maximum confidentiality in all of our services.

Professional and Experienced Academic Writers

We have a team of professional writers with experience in academic and business writing. Many are native speakers and able to perform any task for which you need help.

Free Unlimited Revisions

If you think we missed something, send your order for a free revision. You have 10 days to submit the order for review after you have received the final document. You can do this yourself after logging into your personal account or by contacting our support.

Guarantee Service

All papers are always delivered on time. In case we need more time to master your paper, we may contact you regarding the deadline extension. In case you cannot provide us with more time, a 100% refund is guaranteed.

24/7 Customer Support

Our support agents are available 24 hours a day 7 days a week and committed to providing you with the best customer experience. Get in touch whenever you need any assistance.

Scroll to Top