Scribd
Upload
12 views6 pages

Student Database Management Queries

The document outlines a series of SQL queries related to a Student Database Management System. It includes aims such as creating a database, managing student records, displaying specific data, and performing updates and deletions. The queries also focus on counting students and calculating average marks by department.

Uploaded by

lavishupadhyay12341
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
12 views6 pages

Student Database Management Queries

The document outlines a series of SQL queries related to a Student Database Management System. It includes aims such as creating a database, managing student records, displaying specific data, and performing updates and deletions. The queries also focus on counting students and calculating average marks by department.

Uploaded by

lavishupadhyay12341
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

STUDENT

DATABASE
MANAGEMENT
SYSTEM
Submitted in Partial Fulfilment of
the Requirements for the Course on
SQL

Shaurya
[COMPANY NAME]
Query No. 1
Aim: To create a database for the project.

Query No. 2
Aim: To select and use the created database.

Query No. 3
Aim: To create a Students table.
Query No. 4
Aim: To insert a record into the Students table.

Query No. 5
Aim: To insert multiple records into the Students table.

Query No. 6
Aim: To display all records from the Students table.
Query No. 7
Aim: To display selected columns from the table.

Query No. 8
Aim: To display students from a specific department.

Query No. 9
Aim: To display records using AND condition.
Query No. 10
Aim: To update marks of a student.

Query No. 11
Aim: To delete records with marks less than 40.

Query No. 12
Aim: To display records in descending order of marks.
Query No. 13
Aim: To count total number of students.

Query No. 14
Aim: To find average marks department-wise.

Query No. 15
Aim: To display names starting with letter 'A'.

You might also like