Phil Parkin (12/2/2016)
Just having a mind warp on how to insert into the address table and get that unique int value and put it into the correct master row for the employee.
This relationship sounds the wrong way round to me. Wouldn't this make more sense?
Employee(EmployeeId, etc etc)
Address(AddressId, EmployeeId, AddLine1, etc etc)
Actually, people and addresses form a many-to-many relationship, so a normalized solution would have a third table that contained at least the person_id, address_id, and probably start and end dates.
Having an address id on a person (employee) table indicates that this is something like the primary address. Having a person id on an address table indicates that that person is something like the head of household.
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA