Description

Add two columns as primary key

create table offerings
( course     VARCHAR2(6)  constraint O_COURSE_NN not null
                          constraint O_COURSE_FK references courses
, begindate  DATE         constraint O_BEGIN_NN  not null
, trainer    NUMBER(4)    constraint O_TRAIN_FK  references emp
, location   VARCHAR2(8)
,                         constraint O_PK        primary key
                                                 (course,begindate)
) ;

Related Topic