Consider the following requirements when answering Questions 1 and 2: OntarioTech IT Sales & Services database:...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Consider the following requirements when answering Questions 1 and 2: OntarioTech IT Sales & Services database: Your task is to design an Entity-Relationship diagram and its relational schema for the company's database, which includes computer sales and service tickets. Your ER diagram must reflect the requirements/specifications and business rules given below: · An IT sales representative may sell many computers, however a computer is sold by only one representative: A representative writes an invoice for each computer sold; A customer may purchase any number of computers, but each computer is purchased by a single customer; . A customer receives an invoice for each computer purchased; · A customer may not come to OntarioTech to purchase a computer, but to have a computer repaired instead; . If a customer brings one or more computers in for repair, a repair/service ticket is generated/written for each computer; • OntarioTech keeps a record or service history for each of the computers repaired. Repair tickets are referenced by the computer's serial number; A computer brought in for repair can be serviced by many technicians, and each technician may work on multiple computers; · A computer repair may require computer parts (e.g. memory, GPU, mainboard, harddrive, etc.) or just a software refresh or something that does not require any parts: • Computer parts should be kept in the database even if they are not used in a repair. . A service has an associated hourly rate. Consider the following requirements when answering Questions 1 and 2: OntarioTech IT Sales & Services database: Your task is to design an Entity-Relationship diagram and its relational schema for the company's database, which includes computer sales and service tickets. Your ER diagram must reflect the requirements/specifications and business rules given below: · An IT sales representative may sell many computers, however a computer is sold by only one representative: A representative writes an invoice for each computer sold; A customer may purchase any number of computers, but each computer is purchased by a single customer; . A customer receives an invoice for each computer purchased; · A customer may not come to OntarioTech to purchase a computer, but to have a computer repaired instead; . If a customer brings one or more computers in for repair, a repair/service ticket is generated/written for each computer; • OntarioTech keeps a record or service history for each of the computers repaired. Repair tickets are referenced by the computer's serial number; A computer brought in for repair can be serviced by many technicians, and each technician may work on multiple computers; · A computer repair may require computer parts (e.g. memory, GPU, mainboard, harddrive, etc.) or just a software refresh or something that does not require any parts: • Computer parts should be kept in the database even if they are not used in a repair. . A service has an associated hourly rate. Consider the following requirements when answering Questions 1 and 2: OntarioTech IT Sales & Services database: Your task is to design an Entity-Relationship diagram and its relational schema for the company's database, which includes computer sales and service tickets. Your ER diagram must reflect the requirements/specifications and business rules given below: · An IT sales representative may sell many computers, however a computer is sold by only one representative: A representative writes an invoice for each computer sold; A customer may purchase any number of computers, but each computer is purchased by a single customer; . A customer receives an invoice for each computer purchased; · A customer may not come to OntarioTech to purchase a computer, but to have a computer repaired instead; . If a customer brings one or more computers in for repair, a repair/service ticket is generated/written for each computer; • OntarioTech keeps a record or service history for each of the computers repaired. Repair tickets are referenced by the computer's serial number; A computer brought in for repair can be serviced by many technicians, and each technician may work on multiple computers; · A computer repair may require computer parts (e.g. memory, GPU, mainboard, harddrive, etc.) or just a software refresh or something that does not require any parts: • Computer parts should be kept in the database even if they are not used in a repair. . A service has an associated hourly rate. Consider the following requirements when answering Questions 1 and 2: OntarioTech IT Sales & Services database: Your task is to design an Entity-Relationship diagram and its relational schema for the company's database, which includes computer sales and service tickets. Your ER diagram must reflect the requirements/specifications and business rules given below: · An IT sales representative may sell many computers, however a computer is sold by only one representative: A representative writes an invoice for each computer sold; A customer may purchase any number of computers, but each computer is purchased by a single customer; . A customer receives an invoice for each computer purchased; · A customer may not come to OntarioTech to purchase a computer, but to have a computer repaired instead; . If a customer brings one or more computers in for repair, a repair/service ticket is generated/written for each computer; • OntarioTech keeps a record or service history for each of the computers repaired. Repair tickets are referenced by the computer's serial number; A computer brought in for repair can be serviced by many technicians, and each technician may work on multiple computers; · A computer repair may require computer parts (e.g. memory, GPU, mainboard, harddrive, etc.) or just a software refresh or something that does not require any parts: • Computer parts should be kept in the database even if they are not used in a repair. . A service has an associated hourly rate.
Expert Answer:
Answer rating: 100% (QA)
Refer diagram for ERD For the above diagram we have Pk as the Primary key ... View the full answer
Related Book For
Social Statistics for a Diverse Society
ISBN: 978-1483333540
7th edition
Authors: Chava Frankfort-Nachmias, Anna Leon-Guerrero
Posted Date:
Students also viewed these databases questions
-
PART A: Please draw an Entity Relationship Diagram for the following scenario: The state of Georgia is interested in designing a database that will track its researchers. Information of interest...
-
May Company has five salaried employees. Your task is to use the following information to calculate net pay for each employee: Assume the following: 1. FICA OASDI is 6.2% on $106,800; FICA Medicare...
-
The goal is to design an elevator control system so that the elevator will move from floor to floor rapidly and stop accurately at the selected floor. The elevator will contain from one to three...
-
A rectangular loop of wire with sides 0.20 and 0.35 m lies in a plane perpendicular to a constant magnetic field (see part a of the drawing). The magnetic field has a magnitude of 0.65 T and is...
-
The following items were taken from the December 31, 2012, financial statements of Whitehouse Corporation. (All dollars are in millions.) Prepare a classified balance sheet as of December 31,2012....
-
Cape Town Manufacturing had the following income statement and balance sheet items (in millions of rands, the South African currency): Income Statement For the Year Ended December 31, 20X1 Sales...
-
Most experts maintain that the computer frauds that are publicly revealed represent only the tip of the iceberg. Although the major threat to computer security is perceived by many to be external,...
-
The head of the accounting department at a major software manufacturer has asked you to put together a pro forma statement of the companys value under several possible growth scenarios and the...
-
Missouri's version of financing statement forms are in substantial compliance with the UCC formats approved by the International Association of Commercial Administrators.
-
Observe the following market data: Silver forward contracts (settled in cash) that mature in 4 months have a forward price of $512 per ounce. Silver forward contracts (settled in cash) that mature...
-
Q2 The production forecast for each month shown in table below. Given Regular time wage = $140 per hour, Production time for one product = 4 hours, Hiring cost = $2000, Layoff cost = $3000, monthly...
-
It cost the contractor $13,750 to manufacture their first unit. The company expects to experience a 93% unit learning curve. Estimate the cost of the 14th unit.
-
1.) Compare and contrast generic reimbursement methods used to pay providers and the incentives and risks they create for providers. 2) Critique the reimbursement methods used by Medicare.Include the...
-
Prepare one question about these three items. And answer the questions. And interpret the questions. 1.Cost Behaviors(PREPARE ONE QUESTION ) 2. High-Low method and Least-Squares Regression...
-
For a payroll application such as MYOB, what are three recommendations of actions (raise, create, reduce, and eliminate - blue ocean strategy) that could be taken to improve this mobile app service....
-
A & B in 2019 budgeted a net income after tax rate of 30% amounting to P1,680,000. Fixed costs for the year are estimated to be P2,100,000 and contribution margin is estimated to be 20% of sales...
-
> Question 2 - QUIZ - CH 06 - Con X Course Hero > Shipping - Unique Style Racing X G how to screenshot on asus vivobox +...
-
d) For die casting processes: 1. What are the most common metals processed using die casting and discuss why other metals are not commonly die casted? 2. Which die casting machines usually have a...
-
The condition and health of our environment is a growing concern. Let's examine the relationship between a country's gross national product (GNP) and the percentage of respondents willing to pay...
-
You decide to use Monitoring the Future 2011 data to investigate how young Americans feel about alcohol (ATDRINK) and cigarette use (ATSMOKE). You obtain the data displayed below. You should note...
-
The GSS 2010 measures the amount of hours individuals spend on the Internet per week. Males use the Internet 10.17 hrs per week (standard deviation = 11.71, N= 118), while women use the Internet 9.08...
-
Smith & Co, experienced the following six events in its first year of operations: 1. Shareholders contributed \($60,000\) cash. 2. Purchased land for \($40,000\) cash. 3. Borrowed \($18,000\) in cash...
-
Marilyn Miller began the second year of her floral business with \($12,000\) in cash in her bank account. Using the information below, all of which occurred during Year 2, prepare a statement of cash...
-
The following financial information is known about Pfizer, Inc. for the year ended December 31, 2015. (all amounts in millions): yom a. The balance of cash and cash equivalents was \($3,641\). b....
Study smarter with the SolutionInn App