ncamaa1

Untitled

Aug 7th, 2017
267
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. INSERT INTO item (iname,itype)
  2. VALUES ('cappuccino','hot drink'),
  3.        ('macchiato','hot drink'),
  4.        ('orange juice','cold drink');
  5.  
  6. INSERT INTO Cafe (license,cname,address)
  7. VALUES ('12345','abc','1 palm street'),
  8.        ('22346','cba','2 canal road'),
  9.        ('65432','aaa','3 hill drive');
  10.  
  11. INSERT INTO Client (cid,name,phone)
  12. VALUES ('1','hadas','111111'),
  13.        ('2','danny','222222'),
  14.        ('3','yossi','444444');
  15.  
  16. INSERT INTO Sells (license,iname,price)
  17. VALUES ('12345','cappuccino','5.5'),
  18.        ('12345','orange juice','7'),
  19.        ('22346','macchiato','8'),
  20.        ('22346','orange juice','4.5'),
  21.        ('65432','cappuccino','10');
  22.  
  23. INSERT INTO Receipt(cid,rno,license,rdate)
  24. VALUES ('1','1','12345','1/7/2017'),
  25.        ('2','1','22346','8/7/2017'),
  26.        ('3','1','65432','20/7/2017'),
  27.        ('1','2','12345','22/7/2017');
  28.  
  29. INSERT INTO Buys (cid,rno,iname,amount)
  30. VALUES ('1','1','cappuccino','2'),
  31.        ('2','1','macchiato','2'),
  32.        ('3','1','orange juice','3'),
  33.        ('1','2','cappuccino','2'),
  34.        ('1','2','orange juice','1');
RAW Paste Data