"Please translate the ERD shown in Figure $1$ below into tables using the Optional$-$Max method and answer the following questions. Be sure to clearly indicate primary and foreign keys in the tables. Tables should be in the following format TABLE $1$ NAME, Primary Key, Foreign Key, attribute$\_1,$ attribute$\_2,$ attribute$\_3,...$ For example, STUDENT, student$\_$id$,$ locker$\_$id$,$ last$\_$name, first$\_$name, date$\_$of$\_$birth." These are my answers:

EMPLOYEE, Primary Key $($EmpNO$),$ Name, Title, DOB

LOCATION, Primary Key$($LocationID$),$ City, State, Population

PROJECT, Primary Key$($ProjNO$),$ Foreign Key$($EmployeeID$),$ EstCost

EMP$\_$LOCATION, Composite Primary Key$($EmployeeID$,$ LocationID$)$

SKILL, Primary key $($SkillNO$),$ Description

EMP$\_$SKILL, employee$\_$id $($Foreign Key$),$ skill$\_$id $($Foreign Key$)$

MARRIAGE, Primary Key$($EmpID$),$ Foreign Key$($EmpID$),$ Date$\_$Married

DEPARTMENT Primary key $($Department$\_$Name$),$ Phone

VENDOR Primary key $($Vendor$\_$ID$),$ Address

BUYS$\_$FROM, Composite Primary Key$($DepartmentID$,$ VendorID$),$ Foreign Key$($DepartmentID$),$ Foreign Key$($VendorID$),$ Date$\_$Last$\_$Meeting

Can you expert please cross check and make sure everything is correct please. edit my answer as needed