Skip to main content

Posts

Showing posts from September, 2018

Database Management System (DBMS)

Record sets are the basic foundation of database programming. Normally all business application need to store large volume of data, organised in a format that simplify retrieval of data, this is accomplished with a Database Management System (DBMS). It is a mechanism for manipulating tabular database with high level commands. The database management system hides low level details such as how data are stored in a database and free's the programmer to concentrate on managing information, rather than on the specific of manipulating files or maintaining link among them.

Types of DBMS

Types of DBMS According to the structure the DBMS is divided into four categories: 1. Hierarchical Database 2. Network Database 3. Relational Database 4. Object-oriented Database 1. Hierarchical Database – In hierarchical database, records contain information about their groups of parent or child relationship just like as a tree. The structure implies that a record can have repeating information. 2. Network Database – A network databases are mainly used on large digital computers. A network database model is a database model that allows multiple records to be linked to the same owner file. The network database follows many to many relationship model, and because of many to many relationship model network database model can easily access any table record in the database. It is easier to navigate and search for information because of flexibility. It is suitable in complex data because of the multiple relationship founded among its data. 3. Relational Databas

Database Management System (DBMS)

DBMS A DBMS (Database Management System) is a collection of programs that enables you to store, modify and extract information from a database. In simple words we can say that the DBMS is a type of system which manages the data in database like to add new data, modify the data and delete the existing data. DBMS can be used in many places like Banking to manage the records of the account and transaction, Schools to manage the record of the student and their fees, Payroll Management System to manage the details related to the employees like, attendance, salary, etc, and there are many more field we can use the facility DBMS.  Advantages of DBMS 1. Stop data redundancy and inconsistency – Data redundancy is a situation created within a database in which the same piece of data is present at two separate places. Here are two tables in a database in which a common field is present in the table i.e. “ Student_Name ”, so if you use this type of database structure then this

Database

What is Data? Data is a collection of facts or information which we input into the computer. Like name, age, gender, images, videos, etc. All these data's are stored in unorganized way in computer, but in database we can store all these data in an organised manner. What is Database? Database is a collection of information that is organised so that it can be easily accessed, managed and updated. Formally the database refers to the set of related data organized in a manner. Access to these data is usually provided by a system called Database Management System(DBMS).