question archive For this individual project you will design and build a database for a company, Oopsy Cell repair

For this individual project you will design and build a database for a company, Oopsy Cell repair

Subject:Computer SciencePrice: Bought3

For this individual project you will design and build a database for a company, Oopsy Cell repair. The write up for the company is provided in the paragraph below. To complete this project, you will bring to bear all that you have learnt in this class. First, you will need to design a database by constructing an ERD. Next, you need to identify all relevant attributes and normalize to complete your database design. Next, you will construct a SQL database with relevant tables, based on your design, and populate it with data (4-5 rows data for each table will be enough). You will then come up with 5 complex query questions (defined as ones involving joins or subqueries) and the sql query code solutions. Your project submission must contain your ERD, a copy of your database diagram, and the five query questions and a snapshot of the output of the five queries. Limit your project document to no more than 4-5 pages, single spaced 12-point font. You are welcome to make reasonable assumptions, but make sure you note them in your project report. Limit your project to no more than 10-12 entities.

 Oopsy Cell Repair (OCR) is a Chicago based company with 9 locations in and around Chicago and its suburbs. Founded in 2012, OCR offers repair services to customers who are facing problems with their cell phones. Reflecting the slogan, “All will be well, with us working on your Cell”, OCR offers various services at a fixed price including screen replacement, battery replacement, data retrieval, data removal, etc. OCR can repair multiple brands of cell phones including Apple, Samsung, Nokia, Google, etc. OCR prides itself in providing upfront and transparent pricing for its services. Each of the nine locations is headed by a location manager along with 4-6 service employees. All service employees are trained to do all repairs, so there is no employee specialization or departmentalization. Further, to create a single contact point for the customer, one employee is in charge of all the repairs to a customer’s phone. OCR is seeking your help to create a database that can capture all relevant information for their business.

pur-new-sol

Purchase A New Answer

Custom new solution created by our subject matter experts

GET A QUOTE

Related Questions