class 12 information technology 802 book solution

Unit 1 – Database Concepts NCERT Book Exercise Solution Que 1. Consider the following Employee table: The primary key of this table is Employee_ID and Manager_ID is a foreign key that referencesEmployee_ID. Write SQL commands for the following: (a) Create the above table Answer: CREATE TABLE Employee (Employee_ID integer PRIMARY KEY,Employee_Name VARCHAR(30),Job_Title VARCHAR(25),Salary DECIMAL(10),Bonus INTEGER,Age