Scribd
Upload
14 views1 page

Student Result Management SQL Assignment

The document outlines an assignment involving the creation and manipulation of a 'Result' table for student records. It includes tasks such as inserting records, displaying results based on various criteria, and implementing conditional logic to assign grades. The assignment emphasizes data integrity with constraints on student names and subject scores.

Uploaded by

semke812
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
14 views1 page

Student Result Management SQL Assignment

The document outlines an assignment involving the creation and manipulation of a 'Result' table for student records. It includes tasks such as inserting records, displaying results based on various criteria, and implementing conditional logic to assign grades. The assignment emphasizes data integrity with constraints on student names and subject scores.

Uploaded by

semke812
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Assignment -3

Result
s_id INTEGER auto increment primary key
s_name TEXT check (length()<25)
sub1 integer check >=0 and <=100
sub2 integer check >=0 and <=100
sub3 integer check >=0 and <=100
sub4 integer check >=0 and <=100
Sub5 integer check >=0 and <=100

1 INSERT 10 records in Result Table


2 Display all students result detail with total and percentage.
3 Display Students name who passed in all subjects.
4 Display students name who failed in at least one subject.
5 Display student details in descending order of total.
6 Display student name who scores highest total.
7 Display student name who scores second highest total.
8 Display student name who scores second lowest total.
9 Display student detail scores highest marks in sub1.
10 Display student detail scores lowest marks in sub5.
11 Display student detail scores 50 to 70 marks in sub4.
12 Display student detail where student names not start with p or r.
13 Display student detail where student names start with p or r and second
last character is s.
14 Write a case statement to display student name, total, percentage and
grade (print ‘Fail’ if any subject marks <35)
Per>=80 ‘A+’
Per>=70 and <80 ‘A’
Per>=60 and <70 ‘B’
Per>=50 and <60 ‘c’
else ‘pass’.

You might also like