WORKSHEET-5

STUDENT INFORMATION SYSTEM

Table Name:      Stud

Table Structure:

rno primary key,sname,course,dob,addr,city,phno

Queries: 

1.       Create the table with the given structure.

2.       Insert records

3.       Display all the records form the table.

4.       Display all the students who live in Tambaram

5.       Display name with phno.

6.       List the students who belong to BCA dept.

7.       Sort the student names in ascending order.

MARK SHEET PROCESSING SYSTEM

Table Name:      Mark

Table Structure:

rno primary key,sname,dbms,java,stat,dlf,tot,avge,result

Queries:

1.       Create the table and insert records.

2.       Calculate total and average for the students.

3.       Update the result for the students

4.       Display the students who have passed.

5.       Find out students who got average greater than 75

6.       Find the student s who got highest score.