shreedhar hiremath

 -- 1. Create the 'department' table CREATE TABLE department (     Dname VARCHAR(20),     Dnum INT PRIMARY KEY,     Mgr_ssn INT,     MgrStdate DATE ); -- 2. Create the 'employee' table CREATE TABLE employee (     Fname VARCHAR(20),     Mname CHAR(1),     Lname VARCHAR(20),     Ssn INT PRIMARY KEY,     Bdate DATE,     address VARCHAR(100),     Gender CHAR(1),     salary INT,     Super_ssn INT,     Dno INT,     FOREIGN KEY (Dno) REFERENCES department(Dnum) ); -- 3. Insert data into 'department' table INSERT INTO department VALUES ('Research', 5, 333445555, '1988-05-22'); INSERT INTO department VALUES ('Administration', 4, 987654321, '1995-01-01'); INSERT INTO department VALUES ('Headquarters', 1, 888665555, '1981-06-19'); -- 4. Insert data into 'employee' table INSERT INTO employee VALUES ('John', 'B', 'Smith', 123456789, '1965-01-09', ...

-- 1. Create Tables CREATE TABLE department (     deptid INT PRIMARY KEY,     deptname VARCHAR(50) ); CREATE TABLE teacher (     tid INT PRIMARY KEY,     tname VARCHAR(50),     Dob DATE,     gender VARCHAR(10),     salary DECIMAL(10,2),     address VARCHAR(100),     dno INT ); CREATE TABLE semester (     Semid INT PRIMARY KEY,     Semname VARCHAR(20) ); CREATE TABLE student (     regno INT PRIMARY KEY,     sname VARCHAR(50),     phone VARCHAR(15),     dnumber INT,     sem INT ); CREATE TABLE subject (     subid INT PRIMARY KEY,     Subname VARCHAR(50),     dnum INT,     semnum INT,     teacherid INT ); -- 2. Insert Values INSERT INTO department VALUES (1, 'Computer Science'), (2, 'Electronics'), (3, 'Mechanical'), (4, 'Civil'), (5, 'Electrical'); INSERT INTO teacher VALUES (101, '...