Seeking help with developing tables
TblEmployees, TblDependents, TblPassports
Employees may have many passports (Expirations)
Employees may have many dependents
Dependents may have many passports
Would the correct table structure be?
EmployeeID (Primary)
EmployeeName
EmployeeEtc
EmployeeEtc
DependentID (Primary)
EmployeeID (Foreign)
DependentName
DependentEtc
PassportID (Primary)
EmployeeID (Foreign)
DependentID (Foreign)
PassportNumber
PassportDOB
PassportPOB
PassportExpirations
PassportEtc
Thank you for your time.