Page 109 - Computer Software Application TP - Volume 1

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