自己的整理(一)

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)

)