Project 1

Click here to order this assignment @Essaybay.net. 100% Original.Written from scratch by professional writers.

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

Need a Professional Writer to Work on this Paper and Give you an A+ 100 % Original Paper? CLICK HERE TO GET THIS PAPER WRITTEN

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

Need a Professional Writer to Work on this Paper and Give you an A+ 100 % Original Paper? CLICK HERE TO GET THIS PAPER WRITTEN

Click here to order this assignment @Essaybay.net. 100% Original.Written from scratch by professional writers.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>