In MS SQL Server Write CREATE TABLE statements to create the WORKER, ASSIGNMENT, and BUILDING tables. Add the primary key constraints and foreign key constraints (if any)

 

Transcribed Image Text:

FK WORKER WORKER_ID WORKER_NAME HRLY RATE SKILL_TYPE SUPV_ID ASSIGNMENT PK WORKER_ID PK BLDG_ID START DATE NUM_DAYS BUILDING PK BLDG_ID BLDG ADDRESS QLTY_LEVEL TYPE STATUS FK WORKER WORKER_ID WORKER_NAME HRLY RATE SKILL_TYPE SUPV_ID ASSIGNMENT PK WORKER_ID PK BLDG_ID START DATE NUM_DAYS BUILDING PK BLDG_ID BLDG ADDRESS QLTY_LEVEL TYPE STATUS