Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- INSERT INTO Sales_Rep VALUES ('sales_name1', 'dept1', 'sphone1');
- INSERT INTO Sales_Rep VALUES ('sales_name2', 'dept2', 'sphone2');
- INSERT INTO Sales_Rep VALUES ('sales_name3', 'dept3', 'sphone3');
- INSERT INTO Sales_Rep VALUES ('sales_name4', 'dept4', 'sphone4');
- INSERT INTO Car VALUES ('vin1', 'make1', 'model1', 'color1', 'sales_name1', 'license1');
- INSERT INTO Car VALUES ('vin2', 'make1', 'model1', 'color1', 'sales_name1', 'license1');
- INSERT INTO Car VALUES ('vin3', 'make2', 'model2', 'color1', 'sales_name2', 'license2');
- INSERT INTO Car VALUES ('vin4', 'make3', 'model1', 'color1', 'sales_name3', 'license3');
- INSERT INTO Car VALUES ('vin5', 'make4', 'model1', 'color2', 'sales_name1', 'license1');
- INSERT INTO Customer VALUES ('license1', 'cname1', 'address1', 'cphone1');
- INSERT INTO Customer VALUES ('license2', 'cname2', 'address2', 'cphone2');
- INSERT INTO Customer VALUES ('license3', 'cname3', 'address3', 'cphone3');
- INSERT INTO Customer VALUES ('license4', 'cname4', 'address4', 'cphone4');
- INSERT INTO Test_Drives VALUES ('vin1', 'license2', 'date1');
- INSERT INTO Test_Drives VALUES ('vin2', 'license2', 'date1');
- INSERT INTO Test_Drives VALUES ('vin1', 'license1', 'date2');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement