create table branch(
id smallint(6),
branchname varchar(20)
);

INSERT INTO branch VALUES(1,'東京');
INSERT INTO branch VALUES(2,'横浜');
INSERT INTO branch VALUES(3,'名古屋');
INSERT INTO branch VALUES(4,'大阪');
INSERT INTO branch VALUES(5,'博多');

#-----------------------
CREATE TABLE staff (id SMALLINT NOT
NULL, name VARCHAR(20), age TINYINT, bid
SMALLINT);

INSERT INTO staff VALUES 
('1', '佐藤','23', '1');
INSERT INTO staff VALUES 
('2', '鈴木','24', '2'), 
('3', '高橋', '28', '1');