m97FdWqq

1DROP TABLE IF EXISTS car;
2DROP TABLE IF EXISTS person;
3
4create table person
5(personid integer not null,
6persfname varchar(25),
7perslname varchar(25),
8constraint pk_person primary key (personid));
9
10create table car
11(carid integer not null,
12carcost decimal(7,2),
13carsell decimal(7,2),
14cartype varchar(10),
15personid integer,
16constraint pk_car primary key (carid),
17constraint fk_soldby foreign key (personid) references person(personid));
18
19insert into person values (21,'Sheila','O''Hara');
20insert into person values (2,'Gigi','Garfield');
21insert into person values (63,'Barbara','Capelli');
22insert into person values (74,'James','Haley');
23insert into person values (5,'Nolan','Haley');
24insert into person values (16,'Kwok-Kee','Tan');
25insert into person values (7,'Macedonio','Gomez');
26insert into person values (8,'Bruce','Bush');
27insert into person values (99,'Sue','Lim');
28insert into person values (10,'Kendra','Haley');
29
30insert into car values (1,500,795,'sedan',5);
31insert into car values (2,15500,14750,'coupe',8);
32insert into car values (3,1255,1355,'sports',8);
33insert into car values (4,950,2000,'sedan',8);
34insert into car values (5,7500,9000,'sports',2);
35insert into car values (6,5400,6000,'sedan',99);
36insert into car values (7,10300,12000,'sedan',99);
37insert into car values (8,5700,9000,'coupe',99);
38insert into car values (9,9000,12000,'sports',74);
39insert into car values (10,6000,6500,'sedan',63);