create table ASSIGNMENT(
EmpID VARCHAR2(32) NOT NULL,
ProjectID VARCHAR2(32) NOT NULL,
TotalHoursWorked Number(8,2)
)
EMPLOYEE (EmpID, Name, Email)
PROJECT(ProjectID, ProjectName, Description, StartDate, EndDate)
ASSIGNMENT(EmpID, ProjectID, TotalHoursWorked)
1。创建EMPLOYEE
create table EMPLOYEE (
EmpID VARCHAR2(32) NOT NULL PRIMARY KEY,
Name VARCHAR2(32),
Email VARCHAR2(32)
)