Page 109 - Computer Software Application TP - Volume 1
P. 109

COMPUTER SOFTWARE APPLICATION - CITS


































           2  CREATE TABLE department (
               department id INT PRIMARY KEY,
               department name VARCHAR(50)
           );













           3  Insert the values in the tables:
           Insert values in Employees table -
           INSERT INTO employee VALUES (1, ‘John Doe’, 1);

           INSERT INTO employee VALUES (2, ‘Jane Smith’, 2);
           INSERT INTO employee VALUES (3, ‘Bob Johnson’, 1);
















           Insert values in Department table -

           INSERT INTO department VALUES (1, ‘HR’);
           INSERT INTO department VALUES (2, ‘IT’);




                                                           94
                               CITS : IT & ITES - Computer Software Application - Exercise 29                                                         CITS : IT & ITES - Computer Software Application - Exercise 29
   104   105   106   107   108   109   110   111   112   113   114