Wilmington University Database Management System SQL Server Paper in department database create table called employeedepartment with column: DEPTID,DEPTNA

Wilmington University Database Management System SQL Server Paper in department database create table called employeedepartment

with column: DEPTID,DEPTNAME,DEPTJOININGDATE,DEPLOCATION,DEPINCHARGE

While creating table

1) DEPTID should be UNIQUE

2) DEPTLOCATION should be ‘king of prussia’

3) DEPTJOINING DATE SHOULD NOT BE NULL

4) DEPTINCHARGE should allow values ‘thomas’ ‘andrea’

* INSERT 3 rows into Employee department table

after creating the table with above requirements

1) add new column DEPTSTATUS with check constraint to allow only values ‘y’ and ‘n’

2) modify the deptname datatype to varchar(200)

3) Drop the column DEPTINCHARGE

4) DROP TABLE “EMPLOYEEDEPT”

5) DROP DATABASE “DEPARTMENT”