以下為 schema.sql Create Table CUSTOMER( SEQ varchar(1) not null, MEMBER_ID varchar(10) not null , FIRST_NAME varchar(100) not null, LAST_NAME varchar(100) not null, primary key(SEQ) ); Create Table PET( SEQ varchar(1) not null, PET_ID varchar(10) not null , PET_NAME varchar(100) not null, SPECIES varchar(100) not null, AGE int(2) not null, primary key(SEQ) ); Create Table ORDERFORM( SEQ varchar(1) not null, ORDER_ID varchar(10) not null , MEMBER_ID varchar(10) not null , PET_ID varchar(100) not null, primary key(SEQ) ); commit; ------- 以下為 data.sql insert into CUSTOMER values( '1', 'M0001', 'Kenneth', 'McCormick' ); insert into CUSTOMER values( '2', 'M0002', 'Stuart', 'McCormick' ); insert into CUSTOMER values( '3', 'M0003', 'Stanley', 'Marsh' ); insert into CUSTOMER values( '4', 'M0004', 'Randy', 'Marsh' ); insert into CUSTOMER values( '5', 'M0005', 'Sharon', 'Marsh' ); insert into CUSTOMER values( '6', 'M0006', 'Clyde', 'Donovan' ); insert into CUSTOMER values( '7', 'M0007', 'Jerome', 'McElroy' ); insert into PET values( '1', 'P0001', 'Flash', 'Turtle', '10' ); insert into PET values( '2', 'P0002', 'The Coon', 'Raccoon', '3' ); insert into PET values( '3', 'P0003', 'TomCat', 'Cat', '2' ); insert into PET values( '4', 'P0004', 'Scoob', 'Dog', '4' ); insert into PET values( '5', 'P0005', 'Godzilla', 'lizard', '1' ); insert into ORDERFORM values( '1', 'R0001', 'M0001', 'P0004' ); insert into ORDERFORM values( '2', 'R0002', 'M0002', 'P0003' ); insert into ORDERFORM values( '3', 'R0003', 'M0006', 'P0002' ); insert into ORDERFORM values( '4', 'R0004', 'M0004', 'P0001' ); commit;