Page 112 - CITS - CSA - TP (Volume 1) - Hindi

कंप्यूटर सॉफ्टवेयर एप्लीकेशन- 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 );

96

CITS : IT & ITES - कं ूटर सॉ वेयर ए ीके शन - अ ास 29