2
(salesrepid varchar(3) constraint pk_salesrep primary key,
6
values ('876', 'Clyde Webster');
8
values ('543', 'Janice Martin');
10
values ('777', 'John Johnston');
13
(customerid varchar(3) constraint pk_customer primary key,
14
salesrepid varchar(3),
16
constraint fk_salesrepid
17
foreign key (salesrepid)
18
references salesrep(salesrepid));
21
values ('123', '876', 'Sal Jones');
23
values ('987', '777', 'Mary Jackson');
25
values ('221', '543', 'Alice Smith');
27
values ('388', '543', 'Bill Williamson');
29
values ('456', '543', 'Joe Smith');