For this assessment, you will be creating models, databases, tables, and query reports for a smartphone application. To complete this assessment, you will be using MySQL to test and run a database application that you will develop for parts C through G. After running the code, take a screenshot of your results and paste the screenshot into the document that you will submit to TaskStream for this assessment. The work you complete for each part of the assessment (i.e., the design models/diagrams, tables, written explanations, SQL script code, and screenshot results from running your SQL scripts in a SQL tool) should be saved as a single *.pdf (Portable Document Format) file that you will submit to TaskStream. Note: If you do not have access to a database tool, you may use SQL Fiddle (an online SQL tool) to complete this assessment. The tool can be accessed at the following link:http://sqlfiddle.com. Instructions for how to use SQL Fiddle for each part of the assessment are included in the attached document â€œSQL Fiddle Instructions.â€ Please note that for each part of the assessment, there are explicit instructions on what SQL code you will need to copy and paste into SQL Fiddle panels to run your test. Scenario: You are the database designer and developer for a donut shop that wants to create a smartphone application where customers can order donuts. First, you will design a normalized entity-relationship (E-R) logical database model to store data related to the customer, donuts, and donut order. Next, you will create four tables with primary and foreign keys that are derived from your E-R model. Once the tables have been built, then you will create views and indexes to protect and fine-tune query performance. You will populate each of the tables with sample data. Finally, you will create both a simple â€œselect-from-whereâ€ (sfw) query and a complex join query to produce meaningful reports on individual donut orders and summaries to determine which donuts sell the best. Requirements: A. Construct a normalized model to represent the donut shop smartphone application database that supports the scenario above by doing the following: 1. Using the attached â€œSales Order Formâ€ (unnormalized order form) for the donut ordering database as a reference, produce the final logical schema for this database by doing the following: Note: You can design the tables for the following prompts using any method of your choice (e.g., using a drawing tool using tables). a. Design one table that is in first normal form and fulfills the following requirements: â€¢ The table should have a primary key that uniquely identifies the records. â€¢ The values in each of the columns should be atomic. â€¢ There should be no repeating groups. i. Explain how you designed the table (suggested length of 1 paragraph). b. Design three tables that are in second normal form and fulfill the following requirements: â€¢ The tables should meet all of the requirements for the first normal form. â€¢ All functional dependencies should be removed from the tables. â€¢ Each of the tables should have all primary and/or foreign keys designated. i. Explain how you designed the tables (suggested length of 1 paragraph). c. Design four normalized tables that are in third normal form and fulfill the following requirements: â€¢ The tables should meet all of the requirements for the first and second normal forms. â€¢ All transitive dependencies should be removed from the tables. â€¢ Each of the tables should have all primary and/or foreign keys designated. â€¢ Do not include the calculated attributes/fields (Line Total, Subtotal, Sales Tax and Total) in your normalization diagrams. â€¢ There should be four resulting tables: one for customer information, one for donut information, one for order information and one for or
We employ a number of measures to ensure top quality essays. The papers go through a system of quality control prior to delivery. We run plagiarism checks on each paper to ensure that they will be 100% plagiarism-free. So, only clean copies hit customers’ emails. We also never resell the papers completed by our writers. So, once it is checked using a plagiarism checker, the paper will be unique.
FALL 2018 HOMEWORK HELP| ASSIGNMENT HELP,…