Purchase Solution

Creating Tables Using SQL Server

Not what you're looking for?

Ask Custom Question

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
Column Name Datatype Primary Key (Y/N) Nullable (Y/N)
RegionID Integer Y N
RegionDescription Character (50) N N
o 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:
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
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.
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:
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.

Purchase this Solution

Solution Summary

The expert creates tables using SQL server.

Purchase this Solution

Free BrainMass Quizzes
Java loops

This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.

Basic Networking Questions

This quiz consists of some basic networking questions.

Javscript Basics

Quiz on basics of javascript programming language.

Word 2010: Table of Contents

Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.

Basic Computer Terms

We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.