Details of this Paper

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)

Description

solution


Question

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

 

Paper#66347 | Written in 18-Jul-2015

Price : $27
SiteLock