Display the rollno, name, and grades whose percentage are in between 70 to 100.Display all the record in ascending order of names using SQL view.Display the records who secured the grade A1 and A2.Display the rollno, name and percentage whose percentage are more than 70.Display all the records from the marksheet table whose name ends with ‘N’ using SQL command.Display the rollno, student name and percentage whose name second letter is i using SQL command.Display the rollno, student name and percentage whose name starts with A using SQL command.Display the sum of marks for Sub102 using SQL command.Display the maximum and minimum marks for Sub101 using design.Write SQL command to display name, rollno, grades from the marksheet table.Display name, rollno, marks of 3 subjects, total and percentage using design view.Display all records of the marksheet table, write SQL command.(Grades should be A1 to E2 as per CBSE exam pattern) Total, Percentage, Grade table using UPDATE command. Update the values for newly added columns i.e.Insert more 3 records in MARKSHEET using SQL mode.In the Database file Add these Fields: (Total: Datatype- Number 3 digits, Percentage: Datatype – Number 3 digits with 2 decimal places, Grade: Datatype- Char with 2 letters).In the next section Database Management System 10 complete these queries as per given instructions. Insert at least 10 records in every table.Ĭlick here to get the practical lists for Unit 1 and Unit 2. Write steps wherever applicable.Ĭreate following tables in OO base for Database Management System 10. Attach the outputs and datasheet separately for each question. Create table 4 and 5 using SQL command.Īttach the screenshot of each and every command along with output screens.Practical Database Management System 10Ĭreate database and give the name as practical.

Student database management system pdf