Project #79706 - Securing a Relational Database Management System

 15 SQL statements and 1 database diagram

Task #1: Write a script to create an EMPLOYEES table in the AdventureWorksLT database using the following specifications:

Column Name

Datatype

Primary Key (Y/N)

Nullable (Y/N)

EmployeeID

Integer

Y

N

Hire Date

datetime

N

Y

LastName

Character (20)

N

N

FirstName

Character (10)

N

N

PostalCode

Character (10)

N

Y

Region

Character (15)

N

Y

Title

Character (30)

N

Y

County

Character (20)

N

Y

 

Task #2: Write a script to create a REGIONS table in the AdventureWorksLT database using the following specifications:

Column Name

Datatype

Primary Key (Y/N)

Nullable (Y/N)

RegionID

Integer

Y

N

RegionDescription

Character (50)

N

N

 

Task #3: Write a script to create a DEPARTMENTS table in the AdventureWorks database using the following specifications:

Column Name

Datatype

Primary Key (Y/N)

Nullable (Y/N)

DepartmentID

Integer

Y

N

DepartmentDescription

Character (50)

N

N

 

Task #4: Write a script to add the following records to the EMPLOYEES table:

1 6/7/1998 Sellers Andrew 12345 IL Administrator Cook
2 3/15/1987 Jones Jim 40677 IL CEO Dupage
3 4/5/2000 Johnson Jennifer 89036 CA Manager Kings
4 11/19/2000 Lark Ron 23435 NY Manager Queens
5 4/6/2008 Buchanan Steven 74536 VA Administrator Richmond

 

Task #5: Write a script to add the following records to the REGIONS table:

1

Eastern

2

Western

3

Northern

4

Southern

 

Task #6: Write a script to add the following records to the DEPARTMENTS table:

10

CEO

20

Sales

30

Marketing

 

Task #7: Write a script to add the following column to the EMPLOYEES table:

Column Name

Datatype

Primary Key (Y/N)

Nullable (Y/N)

DepartmentID

Integer

N

N

 

Task #8: Write a script to establish a foreign key constraint between EMPLOYEES and DEPARTMENTS using the common field: DepartmentID;

Task #9: Create a database diagram of the final database clearly depicting all tables and relationships.

Submit the SQL, DDL, and DML scripts needed to complete tasks and the database diagram of the final database.

Subject Computer
Due By (Pacific Time) 08/20/2015 12:00 am
Report DMCA
TutorRating
pallavi

Chat Now!

out of 1971 reviews
More..
amosmm

Chat Now!

out of 766 reviews
More..
PhyzKyd

Chat Now!

out of 1164 reviews
More..
rajdeep77

Chat Now!

out of 721 reviews
More..
sctys

Chat Now!

out of 1600 reviews
More..
sharadgreen

Chat Now!

out of 770 reviews
More..
topnotcher

Chat Now!

out of 766 reviews
More..
XXXIAO

Chat Now!

out of 680 reviews
More..
All Rights Reserved. Copyright by AceMyHW.com - Copyright Policy