-- create a table 1
CREATE TABLE Semester_1(
  Semester_no varchar ,
  Course_Code varchar NOT NULL,
  Course_Title varchar NOT NULL,
  Credit int NOT NULL,
  Letter_Grade TEXT NOT NULL,
  Result TEXT NOT NULL
);

-- create a table 2
CREATE TABLE Semester_2(
  Semester_no varchar ,
  Course_Code varchar NOT NULL,
  Course_Title varchar NOT NULL,
  Credit int NOT NULL,
  Letter_Grade TEXT NOT NULL,
  Result TEXT NOT NULL
);

-- create a table 4
CREATE TABLE Semester_4(
  Semester_no varchar ,
  Course_Code varchar NOT NULL,
  Course_Title varchar NOT NULL,
  Credit int NOT NULL,
  Letter_Grade TEXT NOT NULL,
  Result TEXT NOT NULL
);

-- create a table 5
CREATE TABLE Semester_5(
  Semester_no varchar ,
  Course_Code varchar NOT NULL,
  Course_Title varchar NOT NULL,
  Credit int NOT NULL,
  Letter_Grade TEXT NOT NULL,
  Result TEXT NOT NULL
);

-- create a table 6
CREATE TABLE Semester_6(
  Semester_no varchar ,
  Course_Code varchar NOT NULL,
  Course_Title varchar NOT NULL,
  Credit int NOT NULL,
  Letter_Grade TEXT NOT NULL,
  Result TEXT NOT NULL
);

-- Semester I

INSERT INTO Semester_1 VALUES (1, '20BECC101', 'English',              3,'A+','Pass');
INSERT INTO Semester_1 VALUES (1, '20BECC102', 'Mathematics-I',        4,'A+','Pass');
INSERT INTO Semester_1 VALUES (1, '20BECC141', 'Engineering Physics',  5,'A','Pass');
INSERT INTO Semester_1 VALUES (1, '20BECC142', 'Engineering Chemistry',5,'B+','Pass');
INSERT INTO Semester_1 VALUES (1, '20BECC143', 'Python Programming',   3,'A','Pass');
INSERT INTO Semester_1 VALUES (1, '20BECS111', 'Engineering Graphics', 3,'O','Pass');

-- Semester II

INSERT INTO Semester_2 VALUES (2, '20BECC201', 'Communicative English',3,'A','Pass');
INSERT INTO Semester_2 VALUES (2, '20BECC202', 'Mathematics - II',4,'A+','Pass');
INSERT INTO Semester_2 VALUES (2, '20BECC203', '	
Semiconductor Physics',3,'A','Pass');
INSERT INTO Semester_2 VALUES (2, '20BECC204', 'Environmental Studies',3,'A+','Pass');
INSERT INTO Semester_2 VALUES (2, '20BECS241', 'Basic Electrical and Electronics Engineering',5,'A+','Pass');
INSERT INTO Semester_2 VALUES (2, '20BECS242', 'C Programming',5,'A','Pass');

-- Semester IV

INSERT INTO Semester_4 VALUES (4, '20BECS401', '	
Mathematics - IV (Probability and Statistics)',4,'C','Pass');
INSERT INTO Semester_4 VALUES (4, '20BECS402', 'Formal Language and Automata Theory',3,'A+','Pass');
INSERT INTO Semester_4 VALUES (4, '20BECS403', 'Microprocessor and Microcontroller',3,'A+','Pass');
INSERT INTO Semester_4 VALUES (4, '20BECS441', 'Database Management System',5,'A+','Pass');
INSERT INTO Semester_4 VALUES (4, '20BECS442', 'Computer Networks',5,'A+','Pass');
INSERT INTO Semester_4 VALUES (4, '20BECS451', 'Mobile Application Development',0,'A','Pass');

-- Semester V

INSERT INTO Semester_5 VALUES (5, '20BECS501', 'Servlets and JSP',3,'','A');
INSERT INTO Semester_5 VALUES (5, '20BECS502', 'Artificial Intelligence',3,'A+','Pass');
INSERT INTO Semester_5 VALUES (5, '20BECS503', 'Design and Analysis of Algorithms',3,'C','Pass');
INSERT INTO Semester_5 VALUES (5, '20BECS541', 'Computer Organization and Architecture',5,'B+','Pass');
INSERT INTO Semester_5 VALUES (5, '20BECS542', 'Operating Systems',5,'A','Pass');
INSERT INTO Semester_5 VALUES (5, '20BECS551', 'In Plant Training',0,'C','Pass');

-- Semester VI

INSERT INTO Semester_6 VALUES (6, '20BECS601', 'Cloud Computing',3,'A','Pass');
INSERT INTO Semester_6 VALUES (6, '20BECS602', 'Data Warehousing and Data Mining',3,'A','Pass');
INSERT INTO Semester_6 VALUES (6, '20BECS6E03', 'Software Testing',3,'A','Pass');
INSERT INTO Semester_6 VALUES (6, '20BECS641', 'Complier Design',5,'A+','Pass');
INSERT INTO Semester_6 VALUES (6, '20BECS642', 'Object Oriented Analysis and Design',5,'O','Pass');
INSERT INTO Semester_6 VALUES (6, '20BECS651', 'CCNA - Introduction to Networks',0,'A+','Pass');





-- fetch some values
SELECT * FROM Semester_1;