[PDF] Database Management System Class 10 Notes Download

These Database Management System Class 10 Notes are very helpful for your board exam. These Database Management System Class 10 Notes are necessary for you because these notes all the important topics covered are coming in this board exam. So practice these topics and learn all the important topics properly and read this article carefully.

Database Management System Class 10 Notes
Database Management System Class 10 Notes

Database Management System Class 10 Notes

  • A database is a collection of information or data in an organized manner.

  • Data is a section of unorganized facts symbols, alphabets, or numbers, are used for representing ideas and objects. 

  • The organized form of data is known as information.

  • The collection of information in such a way that it can easily be accessed, managed, or updated by users is known as a database.

  • The application that controls the creation, maintenance, and use of a database is known as Database Management System (DBMS).

  • Some of the commonly used database applications or software are Oracle, MySQL, OpenOffice Base, and Microsoft Access.

  • Sorting refers to the procedure of arranging the data in a proper sequence, thereby making it easy to handle.

  • Summarizing refers to the procedure of retrieving the summary of the data based on some defined criteria.

  • Classifying refers to the procedure of dividing data into categories based on some defined circumstances.

  • Retrieving is the process of fetching information from the database.

  • The flat-file database is a type of database in which a single table or file stores all the data.

  • A relational database is a database in which data is stored in multiple tables.

  • A relational database is based on the relational model proposed by E.F. Codd in 1970. In the relational model, data is arranged in the form of rows and columns of a table.

  • A distributed database is a central database that is distributed at multiple locations within a network.

  • Database languages are used to perform different types of operations on an existing database.

  • Data Manipulation Language (DML) is used for manipulating data present in existing databases. Some commands of DML are SELECT, INSERT, UPDATE and DELETE.

  • Data Control Language (DCL) is used to provide rights and permissions to users for making operations in the database.

  • Some DCL commands are GRANT and REVOKE.

  • The commands in Transaction Control Language (TCL) mainly deal with the transactions that take place in the database.

  • Some TCL commands are COMMIT, ROLLBACK, SAVEPOINT, and SET TRANSACTION.

  • A table stores data about a single entity, such as an employee or student. The data is organized in the format of vertical columns and horizontal rows.

  • In a table, a row is also known as a record, which represents a complete set of information.

  • A record consists of fields where each field contains one type of information.

  • The field is the smallest unit of information in a table.

  • The primary key is a key that helps us to uniquely identify a record in a table.

  • OpenOffice Base is a database application that allows you to store data in the form of various objects, such as tables, reports, and forms.

  • In a table, a field name serves as a label that specifies the type of information contained in a particular field.

  • In a database, field length is the number of characters allowed in a field. In a database, field properties play an important role in controlling the behavior of a field.

  • In OpenOffice Base, you can create a table in two different ways:
  1. Using Design View
  2. Using Table Wizard
  • In Base, you can delete a field by using the Delete command.

  • Editing records means changing or modifying records in a table such as changing the record in a cell with new data, updating records, or deleting records.

  • The query is the most important tool in any database such as a Base database or Structured Query Language (SQL) database.

  • In OpenOffice Base, a query allows you to extract data from single or multiple tables as well as summarize and filter it.

  • The table from which a query retrieves the data is called a record source.

  • The SELECT command is used to retrieve data from one or more tables in a database.

  • The CREATE command is used to create a table in a database.

  • The INSERT command is used to add a new record to an existing table.

  • The UPDATE command is used to update the existing record in a table.

  • The DELETE command is used to delete one or more records from the table in a database.

  • The DROP command is used to delete a table from the database.

  • A form is a database object that represents data in an effective manner. 

  • With the help of forms, users can easily view, enter and change the data directly in database objects such as tables.

  • In OpenOffice Base, you can create a form by using Design View and using Form Wizard.

  • A report is a predefined or user-defined format to display specific data stored in a database.

  • In OpenOffice Base, a report is used to format, Summarize and present data in an attractive and meaningful manner

  • In OpenOffice Base, you can create a report in two ways:
  1. Create Report in Design View
  2. Use Wizard to Create a Report

Conclusion

With that, we come to the end of our Database Management System Class 10 Notes.

I hope that this blog post will help you to decide on the Database Management System Class 10 Notes. If you have any confusion related to this chapter, then comment below or send me a message our team will assist you and help you to remove confusion.

Thanks For Reading this Article.

You May Also Like:-

Rate This Post

Rating of this Post 0 / 5. Vote count: 0

No votes so far! Be the first to rate this post.

Leave a Comment