CREATE DATABASE ASSIGNMENTTWO;
USE ASSIGNMENTTWO;
CREATE TABLE TEACHER
(
Teacher_ID varchar(250) not null primary key,
Name varchar(250) not null,
Rank varchar(250) not null,
Department varchar(250) not null,
Salary int not null
);
CREATE TABLE CLASS
(Class_ID varchar(250) not null,
CourseCode varchar(250) not null,
DayofWeek varchar(250) not null,
Venue varchar(250) not null,
Department varchar(250) not null,
);
insert into TEACHER values
('T001', 'Dr. Najma Waheed', 'Professor', 'CS', 170000),
('T002', 'Dr. Nouman Masood', 'Assistant Professor', 'MGT', 120000),
('T003', 'Dr. Farhana Khan','Professor' , 'CS', 150000),
('T004','Dr. Tayyaba Ali' ,' Professor', 'CS', 140000),
('T005', 'Mr. Nouman Ahmad', 'Lecturer', 'MGT', 80000),
('T006',' Mr. Waqass Raheem', 'Lecturer', 'ENG',75000)
select * from TEACHER
select * from CLASS
insert into CLASS values
('A001', 'CS403', 'Monday', 'A Block','CS' ),
('B002', 'MGT101', 'Tuesday',' B Block','MGT' ),
('C003', 'ENG201', 'Monday',' C Block',' ENG'),
('B005', 'CS403', 'Friday', 'B Block', 'CS')
--Task 1
SELECT * FROM TEACHER WHERE Department='CS';
--Task 2
SELECT Class_ID,DayofWeek,Venue FROM CLASS;
--Task 3
SELECT Name,Rank,Department FROM TEACHER WHERE Rank='Lecturer'
