Do these specific tables need surrogate keys?
Background I have this tables +————————-+ +————————+ |Airport | |Country | |————————-| |————————| |airport_code string (PK) | |country_code string (PK)| |address string | |name string | |name string | +————————+ +————————-+ +————————-+ |Currency | |————————-| |currency_code string (PK)| |name string | +————————-+ airport_code is the IATA (International Air Transport Association ) airport code, you can […]
Do these specific tables need surrogate keys?
Background I have this tables +————————-+ +————————+ |Airport | |Country | |————————-| |————————| |airport_code string (PK) | |country_code string (PK)| |address string | |name string | |name string | +————————+ +————————-+ +————————-+ |Currency | |————————-| |currency_code string (PK)| |name string | +————————-+ airport_code is the IATA (International Air Transport Association ) airport code, you can […]
Do these specific tables need surrogate keys?
Background I have this tables +————————-+ +————————+ |Airport | |Country | |————————-| |————————| |airport_code string (PK) | |country_code string (PK)| |address string | |name string | |name string | +————————+ +————————-+ +————————-+ |Currency | |————————-| |currency_code string (PK)| |name string | +————————-+ airport_code is the IATA (International Air Transport Association ) airport code, you can […]
Do these specific tables need surrogate keys?
Background I have this tables +————————-+ +————————+ |Airport | |Country | |————————-| |————————| |airport_code string (PK) | |country_code string (PK)| |address string | |name string | |name string | +————————+ +————————-+ +————————-+ |Currency | |————————-| |currency_code string (PK)| |name string | +————————-+ airport_code is the IATA (International Air Transport Association ) airport code, you can […]