Project 1

 

1. All project files 

2. Documented source code 

3. Sample Input of output (at least 3) 

4. Include in class brief presentation about the project (10% of the grade) 

5. Title Page 

6. Project description page

 

 

 

project 1 

 

 

 

1. Download and Northwind database 

2. 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 

 

4. 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 

 

5. Alter the Employees table, and add a column: 

◦ 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. 

◦ Employees.DepartmentID references Departments.DepartmentID 

  

7. Alter the Territories table to establish a foreign key between Territories and Regions. 

◦ 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.