I am using an Oracle database. The schema has four tables:
Table 1: worker (name , id , sex , salary , specialty )
Table 2: customer (name , id , bill , date of visit)
Table 3: service (servise id , type)
Table 4: order (orderNo , worker id , worker name , serviceID , date , custemorID)
I think orderNO
is the PK and workerNAME
and workerID
are the composite PKs. Both are FKs. :confused:
My question: In table 4, which one of the attributes is the composite PK?