Transform the following EER diagram into relations and indicate the primary key and foreign keys for each relation.

Transcribed Image Text:

Vendor Vendor ID Vendor Name Vendor Address Project Project No Project Location Date Last Meeting Buys From Skill Skill_No Skill Description Employee Skill Assigned To Location Loc_ID Loc City Loc State Loc Population Department Dept_No Dept Name Dept Address Belongs To Employee Emp No Emp Name Title Date of Birth Is Married To Date Married Vendor Vendor ID Vendor Name Vendor Address Project Project No Project Location Date Last Meeting Buys From Skill Skill_No Skill Description Employee Skill Assigned To Location Loc_ID Loc City Loc State Loc Population Department Dept_No Dept Name Dept Address Belongs To Employee Emp No Emp Name Title Date of Birth Is Married To Date Married