Alter this design so that employee has a 11 relationship to


Suppose that the table EMPLOYEE has a 1:N relationship to the table PHONE_NUMBER. Further suppose that the primary key of EMPLOYEE is Employee ID and the columns of PHONE_NUMBER are Phone Number ID (a surrogate key), Area Code, Local Number, and Employee ID (a foreign key to EMPLOYEE). Alter this design so that EMPLOYEE has a 1:1 relationship to PHONE_NUMBER. For employees having more than one phone number, keep only the first one

Request for Solution File

Ask an Expert for Answer!!
Basic Computer Science: Alter this design so that employee has a 11 relationship to
Reference No:- TGS01604990

Expected delivery within 24 Hours