WORKER (Worker_ID, First_Name, Middle_Name, Last_Name, Street_Address, Mailing_A

Question

WORKER (Worker_ID, First_Name, Middle_Name, Last_Name, Street_Address, Mailing_Address, Primary_Phone_Number, Secondary_Phone_Number, Email_Address, Date_Of_Employment, Date_Of_Birth, Gender)

WORKERTRAININGCERTIFICATION (Current_Training_ID, Worker_ID, Course_ID, Job_ID Training_Date, Course_Pass, Course_Fail)

HOURS (Certification_Hours, Certification_Type, Certification_Start_Time, Certification_End_Time)

TRAINORS (Trainor_ID, First_Name, Last_Name, Course_ID)

WORKERCERTIFICATION (Certification_ID, Worker_ID, Course_ID, Job_ID, Date_Certified)

WORKAREAS (Department_ID, Location_ID, Area_Name, Area_Description, Job_Description)

WAREHOUSE (Location_ID, Street_Address, Phone_Number)

JOB (Job_ID, Department_ID, Job_Description)

AVAILABLE SHIFT (Employee_ID, Available_Shift, Available_Day)

PREFERRED SHIFT (Employee_ID, Preferred_Shift, First_Shift, Second_Shift, Bridge_Shift, Preferred_Location)

AVAILABLE DAY (Employee_ID, Available_Days, Available_Hours)

ASSIGNMENT (Employee_ID, Role_ID, Shift_ID, Location_ID, Start_Date, Number_Of_Shifts, End_Date)

Which ones do I add Primary and Foreign Keys to out of these?

Explanation / Answer

workers( primary key- worker_id)

WORKERTRAININGCERTIFICATION( primary key- Course_ID, foreign key-Worker_ID )

HOURS (primary key-Certification_Type, foreign key -Course_ID) you need to add Course_ID in HOURS to determine houres for which course.

TRAINORS (primary key-Trainor_ID foreign key- Course_ID)

WORKERCERTIFICATION ( primary key-Certification_ID, foreign key-Worker_ID, Course_ID, Job_ID)

WORKAREAS (pimary key-Department_ID, foreign key-Location_ID)

WAREHOUSE (primary key-Location_ID)

JOB (primary key-Job_ID, foreign key-Department_ID)

AVAILABLE SHIFT (primary key-Available_Shift, foreign key-Available_Day, Employee_ID)

PREFERRED SHIFT ( primary key-Employee_ID)

AVAILABLE DAY ( primary key-Available_Days, foreign key-Employee_ID)

ASSIGNMENT (primary key-Role_ID, foreign key- Location_ID)

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.