I have attached the question, Please find the attachments for the question.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.
I have attached the question, Please find the attachments for the question. For this individual project you will design and build a database for a company, Oopsy Cell repair. The write up for the co
OMIS 652 Project Details 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.
Why Choose Us
- 100% non-plagiarized Papers
- 24/7 /365 Service Available
- Affordable Prices
- Any Paper, Urgency, and Subject
- Will complete your papers in 6 hours
- On-time Delivery
- Money-back and Privacy guarantees
- Unlimited Amendments upon request
- Satisfaction guarantee
How it Works
- Click on the “Place Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
- Fill in your paper’s requirements in the "PAPER DETAILS" section.
- Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
- Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
- From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.