
答案
CREATE TABLE offices
(
Office_code int(10) not null,
city varchar(50),
address varchar(50),
country varchar(50),
postal_code varchar(15)
PRIMARY KEY (office_code)
);
CREATE TABLE employees
(
Employee_number INT(10) NOT NULL PRIMARY KEY AUTO_INCREMENT,
name VARCHAR(50),
mobile VARCHAR(25),
office_code INT(10),
job_title VARCHAR(50),
note VARCHAR(255),
gender VARCHAR(5),
);