maraming mali yung mga gnawa mo sa taas. before ka mag lagay ng Foreign Key dapat may default key sila.
Simplify mo lahat. pra madali.
Employee - All basic personal Information
Employee_ID
FullName. format style. Lastname, Firstname Middlename
Gender
BirthDate
Age
Complete Address. format style. Block, Streetname, City Address
Contact#
Status. ex. married, single
ex. implementation.
Unique ID - Phone_ID
Foreign Key - Employee_ID.
ksi yung I reiretrieve mo yung contact ni employee gagamitin mo yung id ni Employee. kung nsa kabilang table sya ganito.
query.
select * from Phone where Employee_ID = 1