Unit 3 : What are all the components of Database System?

What are all the components of Database System? 



Users: are the one who really uses the database. Users can be administrator, developer or the end users.
Tasks of users:
- Input new data
- Delete data
- Modify existing data
- Reads data.

Database Application: is the application program which helps the users to interact with the database by means of query languages. It serves as intermediary between the user and the DBMS. Its tasks includes: create/process forms, process user queries, executes application logic.

Database: is a collection of related data organized in a way that data can be easily accessed, managed and updated.
Two types of data:
1- User data: is data which is stored in the various tables of the database in the form of rows and columns.
2- Metadata: is data about data. it stores the information like how many tables and their names, how many columns and their names, primary keys, foreign keys etc.


DBMS: is the software helps the user to interact with the database. It allows the users to insert, delete, update or retrieve the data.  All these operations are handled by query languages like MySQL, Oracle etc.