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. 

 
 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.