Ask a question from expert

Ask now

Desklib - Online Library for Study Material with Solved Assignments, Essays, Dissertations

4 Pages744 Words354 Views
   

Added on  2019-09-16

About This Document

Desklib is an online library for study material with solved assignments, essays, dissertations, and more. It offers high-quality study material for various subjects and courses. The website provides access to a database of solved assignments, essays, dissertations, and other study material. Users can search for study material by subject, course code, course name, and college/university. Desklib is a one-stop solution for students looking for high-quality study material.

Desklib - Online Library for Study Material with Solved Assignments, Essays, Dissertations

   Added on 2019-09-16

BookmarkShareRelated Documents
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.
Desklib - Online Library for Study Material with Solved Assignments, Essays, Dissertations_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:
Desklib - Online Library for Study Material with Solved Assignments, Essays, Dissertations_2

End of preview

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

Related Documents
Group Project. For the group project, you will be creat
|2
|353
|238

Assignment 3. Download, unzip, and attach the sample da
|2
|208
|284

Create the following queries on the ITCO630_A database used in
|1
|213
|373

Database Design for Australia Zoo Wildlife Hospital
|15
|2483
|417

Introduction To MySQL | Assignment
|3
|742
|304

INSY 3432 Database Systems Assignment
|3
|1000
|365