Database Management System 10 Important Practical list

In this article, you will get a practical assignment for Database Management System 10. These assignment questions are based on create a table and insert values in the table.

Practical Database Management System 10

Create database and give the name as practical.

Create Table

Instructions:

  1. Create table 1,2,3 using design view.
  2. Insert records using datasheet view.
  3. Create table 4 and 5 using SQL command.
  4. Insert records using SQL command.

Dear Students,

Attach the screenshot of each and every command along with output screens. Attach the outputs and datasheet separately for each question. Write steps wherever applicable.

Create following tables in OO base for Database Management System 10.

[1] Students

Field NameData TypeSize
RollNoInteger3
NameText15
GenderText6
CityText20
DOBDate8
Blood_GroupText5
RemarkText10

Assign RollNo as primary key.

[2] Employee Table

Field NameData TypeSize
EmpNoInteger5
EmpNameText15
DesignationText10
AddressText50
CityText10
MobileNoText10
SalaryDecimal9,2
GenderText6

Assign EmpNo as primary key

[3] PhoneDiary

Field NameData TypeSize
Cust_IDint5
CNameText15
CustomerAddressText20
CityText10
PhoneNo_ResText10
PhoneNo_OffText10
MobileNoText10
Email_IdText20

Primary Key – Cust_ID

[4] Marksheet

Field NameData TypeSize
Stud_NoInteger2
NameText15
RollNoInteger3
Sub101Decimal3,2
Sub102Decimal3,2
Sub103Decimal3,2

Primary Key – Stud_No

[5] Player

Field NameData TypeSize
Player_IDinteger5
Player_NameText15
Ageinteger2
HeightText5
WeightInteger3
BloogGroupText5
No_of_MatchesInteger5
CenturiesInteger3
WicketsInteger3
Average_RunDecimal5,2

Primary Key – Player_ID

Insert at least 10 records in every table.

Click here to get the practical lists for Unit 1 and Unit 2.

All Practical

In the next section Database Management System 10 complete these queries as per given instructions.

Queries

  1. 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)
  2. Insert more 3 records in MARKSHEET using SQL mode.
  3. Update the values for newly added columns i.e. Total, Percentage, Grade table using UPDATE command. (Grades should be A1 to E2 as per CBSE exam pattern)
  4. Display all records of the marksheet table, write SQL command.
  5. Display name, rollno, marks of 3 subjects, total and percentage using design view.
  6. Write SQL command to display name, rollno, grades from the marksheet table.
  7. Display the maximum and minimum marks for Sub101 using design.
  8. Display the sum of marks for Sub102 using SQL command.
  9. Display the rollno, student name and percentage whose name starts with A using SQL command.
  10. Display the rollno, student name and percentage whose name second letter is i using SQL command.
  11. Display all the records from the marksheet table whose name ends with ‘N’ using SQL command.
  12. Display the rollno, name and percentage whose percentage are more than 70.
  13. Display the records who secured the grade A1 and A2.
  14. Display all the record in ascending order of names using SQL view.
  15. Display the rollno, name, and grades whose percentage are in between 70 to 100.
  16. Display the rollno, name, sub101, sub102,sub103 with increment of 5 marks in each subject.
  17. Display all the students record who failed in sub102. (Marks less than 33)
  18. Display all the students records who needs improvement in Sub103. (Marks less than 33 and Greater than 30)
  19. Display all the records in descending order of percentage.
  20. Delete the records from table who is failed in any of the subject. (You can use any mode)

Complete these queries and write SQL commands wherever applicable, write steps for design view queries wherever applicable.

Now in the next section of Database Management System 10 I will provide you practical questions for creating Forms.

Creating Forms

  1. Create forms by selecting all the fields for the tables – Students, Employee and Marksheet
  2. Add 3 new records into Students table using navigation toolbar.
  3. Change the label backgrounds and fonts formatting as per your choice.
  4. Search records by from form of students for the boys.

Write steps to complete these tasks. Attach the appropriate screenshots with that.

In the next section of Database Management System 10 you will get the practical question based on Reports.

Creating Reports

Create report for the all the tables. Use your own choice of layouts. Save your reports with your title.

Write steps to complete these tasks. Attach the appropriate screenshots with that. Submit the PDF or document.

That’s All from the Database Management System 10 practical. I hope you enjoyed this article.

Thanks for visit!

Comment Your Views

%d bloggers like this: