Script for DB

CREATE TABLE STUDENT

       ( 

PID INT Primary key generated always as identity (start with 1,increment by 1), 

        SNAME VARCHAR(30), 

        DEPT VARCHAR(30), 

        MARKS INT 

); 

INSERT INTO STUDENT (SNAME,DEPT, MARKS) VALUES('Fatima',  'IT', 86);

INSERT INTO STUDENT (SNAME,DEPT, MARKS) VALUES('Amjad',  'IT', 95); 

INSERT INTO STUDENT (SNAME,DEPT, MARKS) VALUES('Fahad',  'ENG', 90); 

INSERT INTO STUDENT (SNAME,DEPT, MARKS) VALUES('Zeshan',  'IT', 77); 

INSERT INTO STUDENT (SNAME,DEPT, MARKS) VALUES('Zahid',  'MATH', 73); 

INSERT INTO STUDENT (SNAME,DEPT, MARKS) VALUES('Samra',  'MATH', 61);