Assignment 1. Use SQL Management Studio to create a dat
Added on - 16 Sep 2019
Showing pages 1 to 2 of 4 pages
Assignment 1Use SQL Management Studio to create a database called ITCO630_P1.MDF. Be sure to store thedatabase in a location that you will remember. Add the following tables and data to the database.Use the appropriate field types and lengths for the tables.Create the following queries and save them all in a file called ITCO630_P1.SQL. Please notethat you can execute individual queries in a query file by highlighting the lines that you want toexecute before running the script. Define what database to use with a USE statement.Get the full details of the employee table.Get the full details of the employees who work in store S2.Get the full details of the promotions with a budget greater than $100,000.Get the employee number and promotion number for employees with unknown (NULL)jobs who work on promotion P2.
Using a subquery, get the first and last names of the employees who work in the OrangeAppeal store.Using a subquery, get full details of all the employees whose stores are located inOrlando.Detach the database and create a zip file called ITCO630_P1.ZIP including the associated logfile and the query file. After creating the zip file, reattach the database.Assignment 2Consider a typical sales invoice that would include the following information. Design a singletable to hold all of the information required to store an invoice including this information. Next,apply normalization to reduce this table to third normal form. Prepare a Word document showingthe original and final tables. Include a short summary (2–3 paragraphs) of the problems with theoriginal single table design and how normalization improved the design.Orders:Order_idOrder_dateCustomer_idCustomer_nameCustomer_addressCustomer_cityCustomer_stateItem_idItem_descriptionItem_qtyItem_priceItem_total_priceOrder_total_priceAssignment 3Download, unzip, and attach the sample database ITCO630_A from the link below. The sampledatabase represents an educational institution with students and different schools. Each studentgoes to just one school. The students have various roles in different assignments and may workon more than one assignment at a time.Download thedatabasefor this assignment.The following are the tables and data in the ITCO630_A database: