logo

Database Operations and Design

   

Added on  2019-09-16

4 Pages744 Words354 Views
 | 
 | 
 | 
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 note that you can execute individual queries in a query file by highlighting the lines that you want to execute 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.
Database Operations and Design_1

Using a subquery, get the first and last names of the employees who work in the Orange Appeal store. Using a subquery, get full details of all the employees whose stores are located in Orlando. Detach the database and create a zip file called ITCO630_P1.ZIP including the associated log file and the query file. After creating the zip file, reattach the database.Assignment 2 Consider a typical sales invoice that would include the following information. Design a single table 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 the original single table design and how normalization improved the design.Orders:Order_id Order_date Customer_id Customer_name Customer_address Customer_city Customer_state Item_id Item_description Item_qty Item_price Item_total_price Order_total_price Assignment 3Download, unzip, and attach the sample database ITCO630_A from the link below. The sample database represents an educational institution with students and different schools. Each student goes to just one school. The students have various roles in different assignments and may work on more than one assignment at a time.Download thedatabasefor this assignment.The following are the tables and data in the ITCO630_A database:
Database Operations and Design_2

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents