Advertisement
Guest User

Untitled

a guest
Jun 26th, 2017
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.17 KB | None | 0 0
  1.  
  2. INSERT INTO Sales_Rep VALUES ('sales_name1', 'dept1', 'sphone1');
  3. INSERT INTO Sales_Rep VALUES ('sales_name2', 'dept2', 'sphone2');
  4. INSERT INTO Sales_Rep VALUES ('sales_name3', 'dept3', 'sphone3');
  5. INSERT INTO Sales_Rep VALUES ('sales_name4', 'dept4', 'sphone4');
  6.  
  7. INSERT INTO Car VALUES ('vin1', 'make1', 'model1', 'color1', 'sales_name1', 'license1');
  8. INSERT INTO Car VALUES ('vin2', 'make1', 'model1', 'color1', 'sales_name1', 'license1');
  9. INSERT INTO Car VALUES ('vin3', 'make2', 'model2', 'color1', 'sales_name2', 'license2');
  10. INSERT INTO Car VALUES ('vin4', 'make3', 'model1', 'color1', 'sales_name3', 'license3');
  11. INSERT INTO Car VALUES ('vin5', 'make4', 'model1', 'color2', 'sales_name1', 'license1');
  12.  
  13.  
  14. INSERT INTO Customer VALUES ('license1', 'cname1', 'address1', 'cphone1');
  15. INSERT INTO Customer VALUES ('license2', 'cname2', 'address2', 'cphone2');
  16. INSERT INTO Customer VALUES ('license3', 'cname3', 'address3', 'cphone3');
  17. INSERT INTO Customer VALUES ('license4', 'cname4', 'address4', 'cphone4');
  18.  
  19. INSERT INTO Test_Drives VALUES ('vin1', 'license2', 'date1');
  20. INSERT INTO Test_Drives VALUES ('vin2', 'license2', 'date1');
  21. INSERT INTO Test_Drives VALUES ('vin1', 'license1', 'date2');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement