SIZ EDUCATION || Function of database control device||siz-official.

Data dictionary is a record that shops all facts definitions for a database. It might also reveal the facts this is entered. It guarantees that facts is consistent with the facts definition policies.The policies encompass subject names, subject sizes and facts kinds etc.Data dictionary is likewise used for facts get right of entry to authorization for database customers. Data dictionary is likewise referred to as responsibility.

Source

2.Utilities.

DBMS are applications which might be used to keep database through processing facts, information and files.Some utilities are used for backup and restoration strategies of database.

Source

3.Query Language.

A question language is used to carry out exclusive operations at the database.The maximum famous question language is SQL.It stands for Structure Query Language.The statements of SQL are written in easy English -like sentences.Some critical compounds of SQL are SELECT, DELETE, CREATE, MODIFY, UPDATE and INSERT etc.SQL may be used for the subsequent purposes.

• Create Table Structures.
• Enter Data In Tables.
• Retrieve Data From Tables.
• Update Data In Tables.
• Delete Data From Tables Etc.

Source

4.Report Generator.

A file generator is a application this is used to supply reviews.It retrieves facts from database and shows it in exclusive formats.The person can use file generator to layout page ,number, dates,titles and column headings etc.The customers can produce beneficial and appealing reviews through the use of file generator. Report generator is likewise referred to as file writer.

Source

5.Access Security.

Access safety refers back to the safety of database from unauthorized get right of entry to. The database control device offers several strategies to keep facts safety. The safety is maintained through permitting get right of entry to to the database via the usage of passwords.Different customers of database device have exclusive degrees of get right of entry to rights to the database.

Source

6.Backup And Recovery.

Database control device offers the ability for backup and restoration. Backup facility is used to shop an extra reproduction of facts. The facts may be recovered from backup record if authentic record is misplaced.

Source

Special Mention To

@siz-official

Best Wishes By

@bakar