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:
Download and install SQL Server 2008, Express Edition.
Refer to Appendix A of the textbook.
Open and run the attached script to create the Northwind database.
To download the script, click here.
Create the following tables in the Northwind database:
Regions table
Column Name
Datatype
Primary Key (Y/N)
Nullable (Y/N)
RegionID
Integer
Y
N
RegionDescription
Character (50)
N
N
Departments table
Column Name
Datatype
Primary Key (Y/N)
Nullable (Y/N)
DepartmentID
Integer
Y
N
DepartmentDescription
Character (50)
N
N
Insert the following data into the 2 tables:
Regions table
1
Eastern
2
Western
3
Northern
4
Southern
Departments table
10
CEO
20
Sales
30
Marketing
Alter the Employees table, and add a column:
Employees table
Column Name
Datatype
Primary Key (Y/N)
Nullable (Y/N)
DepartmentID
Integer
N
Y
Alter the Employee table to establish a foreign key between Employees and Departments.
Employees.DepartmentID references Departments.DepartmentID
Alter the Territories table to establish a foreign key between Territories and Regions.
Territories.RegionID references Regions.RegionID
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.
Please feel free to send me a message in case of any query
iqra javaid
Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.
[order_calculator]