Class 10 IT Practical File on DBMS 2024-25 (Assignment 3)

In this article we providing information regarding latest Class 10 IT Practical File on DBMS 2024-25 (Assignment 3)

Class 10 IT Practical File on DBMS 2024-25 (Assignment 3)

In your Upcoming CBSE Board Exam – On Internal Marks is 50.

Based On CBSE Curriculum-

So we are discuss one by one Practical’s Be Connected.

Unit 3 – Database Management System

Assignment 3 – Query using criterion and sorting

Display the rollno, name and percentage whose percentage are more than 70 using design view

1. Click Queries → Create Query in Design View….
2. The query design window will open.
3. Select the marksheet table and click on Add button.
4. Select columns given in the question i.e. Rollno, Name and Percentage.
5. Type >70 in the front of criterion under the percentage field.
6. Save the query and check the result.

Query Design:

Output –

Display all the record in ascending order of names using design view.

1. Click Queries → Create Query in Design View….
2. The query design window will open.
3. Select the marksheet table and click on Add button.
4. Select markesheet.* and name in the column list.
5. Select sort → ascending under name field.
6. Now click on Visible checkbox to hide the name column in result.
7. Save the query and check the result.

Query Design View

Output:

Thanks to Beloved Readers.