PET SHOP SYSTEM E.A.R. MODEL

PET SHOP SYSTEME.A.R. MODEL

PET SHOP SYSTEMLOGICAL MODEL KAINUSHI PET DIARY

CREATE TABLE petshop_kainushi( kainushi_id INTEGER PRIMARY KEY, namae VARCHAR(100), denwa VARCHAR(50), email VARCHAR(100), password VARCHAR(20), jyuusho VARCHAR(255) ); CREATE TABLE petshop_pet ( pet_id INTEGER PRIMARY KEY, namae VARCHAR(50), shurui VARCHAR(70), seibetsu CHAR(3), seinengappi DATE, shibou DATE, kainushi_id INTEGER REFERENCES petshop_kainushi ); CREATE TABLE petshop_diary ( record_no INTEGER PRIMARY KEY, hiduke DATE, naiyou VARCHAR(255), pet_id INTEGER REFERENCES petshop_pet );

INSERT INTO petshop_kainushi VALUES(5001,'月田佑一','090-0000-0001','tuki@tnw.com','tuki','東京都墨田区'); INSERT INTO petshop_kainushi VALUES(5002,'加藤浩明','090-0000-0002','kato@tnw.com','kato','東京都港区'); INSERT INTO petshop_kainushi VALUES(5003,'村田大樹','090-0000-0003','mura@tnw.com','mura','東京都足立区'); INSERT INTO petshop_pet VALUES(7001,'アッシュ','犬','雄','2003-08-03',NULL,5001); INSERT INTO petshop_pet VALUES(7002,'タケシ','猫','雌','2005-11-11',NULL,5001); INSERT INTO petshop_pet VALUES(7003,'ケン','猫','雄','2000-01-15',NULL,5002); INSERT INTO petshop_pet VALUES(7004,'ハナ','犬','雄','1997-06-25','2005-07-24',5002); INSERT INTO petshop_pet VALUES(7005,'ノリ','熊','雌','2001-05-05',NULL,5003); INSERT INTO petshop_diary VALUES(1001,'2007-03-03','風邪をひいて注射をしました',7001); INSERT INTO petshop_diary VALUES(1002,'2007-04-29','足の骨を折ったので、治療しました',7001); INSERT INTO petshop_diary VALUES(1003,'2005-11-10','クロスケーブルを作りました',7003); INSERT INTO petshop_diary VALUES(1004,'2005-07-24','残念ながら亡くなりました',7004); INSERT INTO petshop_diary VALUES(1005,'2004-10-14','体重が１００キロになりましたので、ダイエットします',7005); INSERT INTO petshop_diary VALUES(1006,'2005-11-11','ストレートケーブルを作りました',7003);

PET SHOP SYSTEM E.A.R. MODEL