ITCO331 Lab 1 (Step 3 – 8) – Guaranteed 100% Score

Lab Price = $7
Please feel free to send us your queries at: support@iqrajavaid.com
Note: In case if your problem statement is updated, please donot hesitate us and send it to us at support@iqrajavaid.com. We would surely like to help you in this regard.
Problem Statement

ITCO331-1205B-01 Relational Database Management Systems

Your first task is to download and install SQL Server 2008, Express Edition. Once that is installed, set up the Northwind database, which will be used throughout the class.
Complete the following tasks:
1. Download and install SQL Server 2008, Express Edition.
o Refer to Appendix A of the textbook.
2. Open and run the attached script to create the Northwind database.
o To download the script, click here.
3. Create the following tables in the Northwind database:
o Regions table
Column Name Datatype Primary Key (Y/N) Nullable (Y/N)
RegionID Integer Y N
RegionDescription Character (50) N N
o Departments table
Column Name Datatype Primary Key (Y/N) Nullable (Y/N)
DepartmentID Integer Y N
DepartmentDescription Character (50) N N
4. Insert the following data into the 2 tables:
o Regions table
1 Eastern
2 Western
3 Northern
4 Southern
o Departments table
10 CEO
20 Sales
30 Marketing
5. Alter the Employees table, and add a column:
o Employees table
Column Name Datatype Primary Key (Y/N) Nullable (Y/N)
DepartmentID Integer N Y
6. Alter the Employee table to establish a foreign key between Employees and Departments.
o Employees.DepartmentID references Departments.DepartmentID
7. Alter the Territories table to establish a foreign key between Territories and Regions.
o Territories.RegionID references Regions.RegionID
8. Update the data in the Employees table so that employees with the following managers are listed as working in the following departments:
ReportsTo Department
Andrew Fuller Sales
Steven Buchanan Marketing
All Others CEO
Submit the SQL, DDL, and DML scripts needed to complete tasks 2–8 and a database diagram of the final database.

Relevant Material
Screenshots
Screenshot_DBDiagram

Instructions
* Please click on “Buy Now” button to complete the purchase.Please note that the payment is done through PayPal.
* If you have any issues with the payment method, please let us know at support@iqrajavaid.com and that can be discussed and considered.
* Your paypal has to be pre-loaded in order to complete the purchase or otherwise please discuss it with us at support@iqrajavaid.com.
* As soon as the payment is received through PayPal, download link of the solution will automatically be sent to the address used in Paypal.
* Please check your junk mails as the download link email might go there.
* All the contents are compressed in one zip folder.
* In case if you get stuck at any point during the payment process, please immediately contact us at support@iqrajavaid.com and we will fix it with you.
* We try our best to reach back to you on immediate basis. However, please expect to get a response within 8 hours from our side.
* Comments/Feedbacks are truely welcomed and there might be some incentives for you for the next lab/quiz/assignment.
* In case of any query, please donot hesitate to contact us at support@iqrajavaid.com.

******************************************** Good Luck ***************************************************

Privacy Policy
We take your privacy seriously and will take all measures to protect your personal information.
Any personal information received will only be used to fill your order. We will not sell or redistribute your information to anyone.
Refund Policy
Incase you face any issues with the tutorial, please free to contact us on support@iqrajavaid.com
We will try our best to resolve the issue and if still persists we can discuss for a refund in case its required.
Payment Details
Lab Price = $7
Please feel free to send us your queries at: support@iqrajavaid.com
Note: In case if your problem statement is updated, please donot hesitate us and send it to us at support@iqrajavaid.com. We would surely like to help you in this regard.

Leave a Reply