Question

Write a CREATE TABLE statement for the DEPARTMENT table. Save and Run this statement. 2. Write a CREATE TABLE statement for the EMPLOYEE table including constraints. Email is required and is an alternate key Cascade updates but not deletions from DEPARTMENT to EMPLOYEE. Save and Run this statement. 3. Write a CREATE TABLE statement for PROJECT table. - Cascade updates but not deletions from DEPARTMENT to PROJECT

Answer 1

Check the explanation

Step-by-step explanation:

Please find the sql statements (as numbered in the question) below:

1. DEPARTMENT TABLE

CREATE TABLE DEPARTMENT (

DepartmentName varchar (50),

BudgetCode varchar (50),

OfficeNumber varchar (50),

OfficeNumber varchar (50),

Phone varchar (50)

);

2. EMPLOYEE TABLE

CREATE TABLE EMPLOYEE (

EmployeeNumber varchar (50),

FirstName varchar (50),

LastName varchar (50),

Phone varchar (50),

Email varchar (50) NOT NULL UNIQUE,

DepartmentName varchar (50) FOREIGN KEY REFERENCES DEPARTMENT(DepartmentName) ON UPDATE CASCADE

);

3. PROJECT TABLE

CREATE TABLE PROJECT (

ProjectID varchar (50),

Name varchar (50),

MaxHours FLOAT,

Date() AS StartDate,

Date() AS EndDate,

DepartmentName varchar (50) FOREIGN KEY REFERENCES DEPARTMENT(DepartmentName) ON UPDATE CASCADE

);