Question

Neede this table:

Project code: (project_code, project_name, project_manager, project budget)

Employee table ( employee_number, project code,employee_first name, employee_last name, department_number)

Department table: (Department_number, department_name)

Answer 1

Please find the CREATE TABLE queries below.

create table Department (

department_number int primary key,

department_name varchar2(50)

);

create table Project_Code (

project_code int primary key,

project_name varchar2(50),

project_manager int,

project budget decimal(5, 2),

foreign key project_manager references Employee(employee_number)

);

create table Employee (

employee_number int primary key,

project_code int,

employee_first_name varchar2(50),

employee_last_name varchar2(50),

department_number int,

foreign key project_code references Project_Code(project_code),

foreign key department_number references Department(department_number)

);