Reference no: EM13929889
Complete the following tasks:
1. Download and install SQL Server 2008, Express Edition.
o Refer to Appendix A of the textbook.
2. Open and run the attached script to create the Northwind database.
o To download the script, click here.
3. Create the following tables in the Northwind database:
o Regions table
4. Insert the following data into the 2 tables:
o Regions table
1 Eastern
2 Western
3 Northern
4 Southern
o Departments table
10 CEO
20 Sales
30 Marketing
5. Alter the Employees table, and add a column:
o Employees table
6. Alter the Employee table to establish a foreign key between Employees and Departments.
o Employees.DepartmentID references Departments.DepartmentID
7. Alter the Territories table to establish a foreign key between Territories and Regions.
o 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:
Attachment:- UNIT ONE ASSIGNMENT.docx
|
Calculate the range, variance and standard deviation
: Prepare a frequency distribution of ungrouped data including cumulative frequency (tally) for the table of approved,Calculate the mean, mode and median of the table of approved
|
|
Identify complementary relationships
: Identify complementary relationships, where companies are not necessarily selling the same product or service, but need each other to perform well in the Middle Eastern marketplace.
|
|
Facing the workforce of the future
: What are some of the major laws affecting organizations as thet attempt to recruit a more diverse workforce - what are some ways that recruiting would be done differently to attract more African Americans? Latinos? Women?
|
|
What does david foster wallace mean by default mode setting
: Watch: David Foster Wallace "This is Water" and write a 400 page essay on what the title means to you. Also, what does David Foster Wallace mean by default mode setting? What is your default mode setting?
|
|
Alter the employee table to establish a foreign key
: Alter the Employee table to establish a foreign key between Employees and Departments.
|
|
When bush declared a war on terrorism
: When Bush declared a "war on terrorism." Critics of the bombing campaign argued that terrorism was rooted in grievances such as. Zinn attributes the failure to change from a war to a peace policy to.
|
|
Regardless of income
: Politicians are often heard saying that tuition at state universities should be kept low to make education equally accessible to all residents of the state, regardless of income.
|
|
Evaluate the role financial intermediaries play
: Evaluate the role financial intermediaries' play in smoothing out the incompatibilities between savers and borrowers and promoting a well functioning financial system
|
|
Write the components of grant application
: Locate and review the mission statement for the non-profit organization you selected. (I have selected Children's Hospital of Orange County) Do you feel it is an effective mission? Explain why or why not.
|