OntarioTech IT Sales & Services database: Your task is to design an Entity-Relationship diagram and its...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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. Question 1 Design an ER diagram to model OntarioTech IT Sales & Services' database. Make assumptions about what pieces of information each entity should carry (e.g., attributes, primary and foreign keys, etc.). Please rules that are not captured in your diagram. Hand draw your diagram, take a photo and submit it. Submit an image file (jpg, png, bmp, pdf) with your diagram. Upload Choose a File Question 2 Based on the ER diagram you designed in (1). create its corresponding Relational Model. It's just text, not a diagram. 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. Question 1 Design an ER diagram to model OntarioTech IT Sales & Services' database. Make assumptions about what pieces of information each entity should carry (e.g., attributes, primary and foreign keys, etc.). Please rules that are not captured in your diagram. Hand draw your diagram, take a photo and submit it. Submit an image file (jpg, png, bmp, pdf) with your diagram. Upload Choose a File Question 2 Based on the ER diagram you designed in (1). create its corresponding Relational Model. It's just text, not a diagram.
Expert Answer:
Answer rating: 100% (QA)
Ans ER DIAGRAM NOTE Please Make all Entity names in Capital Let... 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...
-
1.What is the difference between Router and firewall 2.What is Packet filtering router 3.What is Stateful inspection firewall 4.What is Circuit level firewall 5.What is Application level firewall...
-
Use the following to prepare an income statement for Excel Technology, Inc., for the year ended June 30, 2011: Service revenues ...... $62,675 Rent expense ........ 12,000 Insurance expense ..........
-
The Feinstein Company has assembled the accompanying balance sheets and statement of income and retained earnings for 20X4. Feinstein Company Balance Sheets as of December 31 (in millions) Feinstein...
-
A small but growing firm has recently hired you to investigate a potential fraud. The company heard through its hot line that the purchases journal clerk periodically enters fictitious acquisitions....
-
MidCoast Airlines uses the following performance measures. Classify each of the performance measures below into the most likely balanced scorecard perspective it relates to. Label your answers using...
-
As the executive of XYZ airline, the IATA has invited you to join their annual general meeting. One of the agenda is to promote E-AWB (Electronic Air waybill) with a target for 100 percent...
-
The Ortega Food Company needs to ship 100 cases of hot tamales from its warehouse in San Diego to a distributor in New York City at minimum cost. The costs associated with shipping 100 cases between...
-
Let n be an integer, -5+- 10 for i=0,1,2,...,n, and y = 71 (a) Given 11 data points (,). i=0,..., n for n = 10, approximate the value of y at ar = 4.8 by using piecewise linear interpolation. (b) Let...
-
Data for the computation of total intangible assets follow: Deposits with advertising agency which will be used to promote goodwill P 45,000 Organization costs 50,000 Unamortized bond discount...
-
Vernon Company is considering investing in two new vans that are expected to generate combined cash inflows of $28,000 per year. The vans' combined purchase price is $92,000. The expected life and...
-
What two groups maintain legislative liaison offices within their organizations that serve as the formal point of contact between DoD and the Appropriations Committees in the House and Senate?
-
What should Rodriguez and Fulton's final decision be? Are there any other financing alternatives that should be considered?
-
Giulia Ferrato, a recent MBA graduate, has developed a high-quality piton, a tool used in mountain climbing. Owing to the security of a customer's offer to guarantee a significant level of demand for...
-
Calculating the IRR for Project Long Project Long is expected to provide five years of cash inflows and to require an initial investment of $100,000. The required rate of return or discount rate that...
-
Consider a closed, rigid tank with a volume of 0.8L, filled with cold water initially at 27C. The tank is filled such that there are no voids (air pockets) within. The initial pressure within the...
-
In 2011, the U.S. Census published a report saying that the number of Americans living below the federal poverty line was at an all-time high. We want to know if the percentage of residents in each...
-
If a particular distribution that you are studying is not normal, it may be difficult to determine the area under the curve of the distribution or to translate a raw score into a Z value. Is this...
-
GSS 2010 male and female respondents reported the age when their first child was born. Based on the SPSS output, determine whether there is a significant difference between the two groups. Assume a...
-
The following data were taken from the financial statements of The Amphlett Corporation, which is all equity financed. Required: 1. Calculate the following ratios for 2016 and 2017: a. Return on...
-
The Thunderbird Corporation has applied to the Biltmore National Bank for a \($100,000\) loan to purchase new equipment for its manufacturing operations. As part of the loan application, the chief...
-
Presented below is the year-end 2016 balance sheet for The Little Corporation. During 2017, the company entered into the following events: 1. Sales to customers totaled \($2\) million, of which...
Study smarter with the SolutionInn App