What is Database Management System and Its Objectives?
A database is a repository for a collection of related data or faces.
The most obvious example of a non-computerized database is a telephone directory database programs can also sort a list of data by arranging them in alphabetical, numeric, or chronological order and can search or query data under different conditions.
Data and Information The word data is used to refer to a factor concept. The data and information are not the same things.
Data arranged in certain order and form which is useful to us is called information. Data is the raw material to generate information that is data is to be processed to produce information.
Database Management System (DBMS)
Database Management System (DBMS) is a software that defines a database, stores data, supports a query language, produces reports, and creates a data entry screen. Database systems are designed to manage large bodies of information.
The objective of DBMS (Database Management System)
DBMS applications must be capable of solving challenging problems of different organizations. some objectives of DBMS are given below
- Provide for mass storage of relevant data
- Making easy access to data for the authorized user.
- Providing prompt response to users’ requests for data.
- Eliminate redundantly (Duplicate) d data.
- Allow multiple users to be active at one time.
- Allow the growth of the database system
- Provide data integrity.
- Protect the data from physical harm and unauthorized access.
- Serving different types of users. the
- Provide security with a user access privilege.
- Combining interrelated data to generate a report
- Provide multiple views for the same data.
Key Terms to be Known in a Database System
Fields:Â Fields contain one piece of information of an entry in a database example: – is an address book each entry has fields for first name last name, address phone number email birthday, etc.
Record:Â One full set of fields i.e. All the related information about one person or object is called a record.
Table: A complete collection of the record is called a table. A table contains rows and columns. Each column of a table represents a field and each row represents a record.
Relational Database Management System (RDBMS)
The DBMS in which relations between different tables can be formed using a common field or attribute in those tables to draw relations in between is called Relational Database Management System.
A relational Database implements data in a series or two- dimensional table that is related to one another through the foreign key.
Concepts for Relational Database Management System (RDBMS)
Entity: An entity is a class of persons, places, events, objects, or concepts in the real world that is distinguishable from other objects. An entity is also called an entity type or entity class. Attributes: Attributes are descriptive properties possessed by each member of an entity. Attributes are also called elements, the property of the field.
Relationships: A relationship is a natural business association that exists between one or more entities. The relationship may represent an event that links the entities.