Click here to order similar paper @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