-3
I have 4 tables:
CITY
(
city_id PRIMARY KEY,
city_name,
state,
total_staff,
travel_code,
is_capital_city
);
DEPOT
(
dep_id PRIMARY KEY,
capacity,
capacity_used,
mgr_name,
depot_type,
audit_year,
city_id,
Foreign Key (city_id) References CITY
);
MANUFACTURER
(
manu_id PRIMARY KEY,
manu_name,
...