--~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

--DDL QUERIES

--Q1: MOVE TO THE RIGHT DATABASE ...
--AIM: RUN THE SQL CODE ON THE RIGTH DATABASE
use w0580681

GO

--Q2: DROP TABLE WORK_FOR
--AIM: CLEAR THE DATABASE FOR THE NEW TABLE
DROP TABLE    WORK_FOR
GO

--Q3: DROP TABLE WORK_ON
--AIM: CLEAR THE DATABASE FOR THE NEW TABLE
DROP TABLE    WORK_ON

GO

--Q4: DROP TABLE DEPENDENTS_OF
--AIM: CLEAR THE DATABASE FOR THE NEW TABLE
DROP TABLE    DEPENDENTS_OF
GO

--Q5: DROP TABLE MANAGES
--AIM: CLEAR THE DATABASE FOR THE NEW TABLE
DROP TABLE    MANAGES
GO

--Q6: DROP TABLE DEPARTMENT
--AIM: CLEAR THE DATABASE FOR THE NEW TABLE
DROP TABLE DEPARTMENT
GO

--Q7: DROP TABLE DEPENDENT
--AIM: CLEAR THE DATABASE FOR THE NEW TABLE
DROP TABLE    DEPENDENT
GO

--Q8: DROP TABLE EMPLOYEE
--AIM: CLEAR THE DATABASE FOR THE NEW TABLE
DROP TABLE    EMPLOYEE
GO

--Q9: DROP TABLE PROJECT
--AIM: CLEAR THE DATABASE FOR THE NEW TABLE
DROP TABLE    PROJECT
GO

--Q10: CREATE TABLE DEPARTMENT
CREATE TABLE DEPARTMENT(
dname nvarchar(max) NULL,
dnumber int NOT NULL,
location nvarchar(max) NULL,
number_of_employee int NULL,
CONSTRAINT PK_DEPARTMENT PRIMARY KEY
(
dnumber
)
)
GO

--Q11: CREATE TABLE DEPENDENT
CREATE TABLE DEPENDENT(
ssn nvarchar(11) NOT NULL,
dname nvarchar(max) NULL,
sex nvarchar(10) NULL,
bdate date NULL,
relationship nvarchar(max) NULL,
CONSTRAINT PK_DEPENDENT PRIMARY KEY
(
ssn
)
)
GO

--Q12: CREATE TABLE DEPENDENTS_OF
CREATE TABLE DEPENDENTS_OF(
dssn nvarchar(11) NOT NULL,
essn nvarchar(11) NOT NULL,
CONSTRAINT PK_DEPENDENTS_OF PRIMARY KEY
(
dssn ,
essn
)
)
GO

--Q13: CREATE TABLE EMPLOYEE
CREATE TABLE EMPLOYEE

Complete the following: 1. Show the SQL script required to create...