Advertisement
Guest User

Untitled

a guest
May 26th, 2018
231
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. INSERT INTO student(studid, studname) VALUES(1999-1-20-004’,’Charles Babbage’);
  2. INSERT INTO student(studid, studname) VALUES(1999-1-20-005’,’Alan Turing’);
  3. INSERT INTO student(studid, studname, email) VALUES(1999-1-20-006’,’Todd Mars’,’todd@ewubd.edu);
  4.  
  5.  
  6. INSERT INTO department(deptid, deptname) VALUES(‘001’,’Computer Science’);
  7. INSERT INTO department(deptid, deptname) VALUES(‘002’,’Computer Science AND Engg’);
  8. INSERT INTO department(deptid, deptname) VALUES(‘003’,’Business Administration’);
  9. INSERT INTO department(deptid, deptname) VALUES(‘004’,’Communication AND Infor Tech’);
  10. INSERT INTO department(deptid, deptname) VALUES(‘005’,’English’);
  11.  
  12. INSERT INTO course VALUES(‘cse201’,’001’,DATABASE Systems’, 3.0);
  13.     INSERT INTO course VALUES(‘eng101’,’005’,’English Conversation’, 3.0);
  14. INSERT INTO course VALUES(‘cse202’,’001’,’Structured Programming’, 3.0);
  15. INSERT INTO course VALUES(‘cit201’,’004’,’Mobile Communication’, 3.0);
  16. INSERT INTO course VALUES(‘bus101’,’003’,’Business Communication’, 3.0);
  17. INSERT INTO course VALUES(‘cse211’,’002’,’Algorithm’, 4.0);
  18. INSERT INTO course VALUES(‘mgt311’,’003’,’Production Management’, 3.5);
  19. INSERT INTO course VALUES(‘cse411’,’002’,’Artificial Intelligence’, 3.0);
  20.  
  21.  
  22. INSERT INTO instructor VALUES(‘AAA’,’005’,’Mr Rozario’,’Professor’,’aaa@ewubd.edu’);
  23.     INSERT INTO instructor VALUES(‘ABB’,’004’,’Mr Jaya Vigayan’,’Asstt Professor’,’abb@ewubd.edu’);
  24.     INSERT INTO instructor VALUES(‘ABA’,’003’,’Mr Dinu Selvam’,’Professor’,’aba@ewubd.edu’);
  25.     INSERT INTO instructor VALUES(‘BBC’,’003’,’Mr Jaya Prakash’,’Asstt Professor’,’bbc@ewubd.edu’);
  26.     INSERT INTO instructor VALUES(‘BBD’,’002’,’Ms Sugumaran’,’Asstt Professor’,’bbd@ewubd.edu’);
  27.     INSERT INTO instructor VALUES(‘ADA’,’001’,’Ms Minnal’,’Professor’,’ada@ewubd.edu’);
  28.     INSERT INTO instructor VALUES(‘AAD’,’005’,’Mr Franko’,’Asstt Professor’,’aad@ewubd.edu’);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement