Question

Answer the following two questions in paragraph form:
1. A database system is made up of five major parts. Identify these parts. Provide specifics of what make up these components.

2. A DBMS provides at least nine functions. Identify these functions and provide a brief explanation of each.

Answer 1

1.five major component of database system:-

Hardware

It refer to the computer ,input/output devices and other physical devices like hard disks which are involved for data storing successfully into the physical memory .like computer RAM ,ROM are part of dbms hardware

Software

It control the program ,provide interface to the user allow accessing and updating the data

Data

source of information for which dbms is designed

Procedures

Procedures provide the various type of instruction for dbms system like installation of dbms login and logout from dbms system

Database Access Language  

Language through which various command like insert ,modify,update,delete of data is performed from database

2.

Data Dictionary Management

It provide specification of data element and their relationship.the relationship between data and data is metadata

Storage Management

provide an efficient way of storing data so that it can access ,update and insert easily

Security Management

It provide a set of rules which have to user follow to use the database system

Multiuser Access Control

Accessing the data by multiple user at a time without breaking the integrity

  Backup and Recovery Management

It provide to backup the data when their is an failure occur

Data Integrity Management

Basically it enforce the reduce the data redundancy using normalization and providing  data consistency

Database Access Languages and Application Programming Interfaces

Provide an efficient way of storing accessing and modifying the data easily

Database Communication Interfaces

Allow to user to request for data from the different networking system

Transaction Management

Provide ACID property of transaction