DBMS 1 Lesson 2

By this lesson I'll talk more about DBMS.If you haven't read the Lesson 1 click here.

Lesson 2:

What is DBMS??

DBMS is system software that enables users to define,create,maintain & to provide controlled access to this database.

Subsystems of DBMS is shown below

Functions of DBMS

• Data Security - Limits the access by using passwords.Only authorized people will gain access to database.
• Data Integrity(validity) - Consistency is provided by backup & recovery capabilities.
• Concurrent Data Access - Multiple users can access database at the same time.
• Backup & Recovery - By using automatic software backups are taken.
• User Oriented Data Manipulation - Tools are provided to use query languages(eg: SQL)
• Application Development - Tools are provided for report generation, compilers etc..

Click Here To Download This Lesson in PDF Format

Next Lesson will be based on Database Architecture.So please keep in touch...