DATABASE CONCEPTS

MAJOR COMPONENTS OF DATABASE ENVIRONMENT.

 Strong Database Environment consist of 9 (Nine) major components to maintain the database successful. The Major components of database environment are

CASE Tools : (Computer Aided Software Engineering Tools) .CASE Tools are predefined tools. These are automatically designed the database in database approach.

Repository: It is a centralized location of data definitions, data relationships, reports, formats and other system components and descriptions of the data is called Repository.

DBMS: DBMS (Database Management System) : It is a Mechanism , A system which is consist a set of well defined programs to  create, store, Delete, manipulate and retrieve  the data in an organization by using File Operations like create a file , update file, delete file and insert file efficiently  is known as DBMS.

Database A set  of the interrelated data of an organization is a database. Usually it design to meet the information of multiple users in an organization .The repository  contains the definitions and structure of the data where as the database contain the occurrence of the data.

Application Programs: A computer programs which is used to create and maintain the database to provide the information to users is an application programs.

User Interface: Languages, Menus, Commands and other facilities which are used to interact with the computers by user is a user interface. Generally this component is work as a interface with each and every component in an database environment.

Database Administrator:  (DBA):  DBA is a person who has a responsible for overall information resources  and central control  of  an organization .

System Developers:  These are persons  such as system programmers and analysts , who designed new application programs is called system developers.

End Users: End user is a person who insert , delete and modify the data in the database and who request information from database is known as end user.