Database is an integrated collection of logically related data or information or files stored in a computer system. Database information are organized and arranged in an order to manage and access the information as required by the users. Database could be occupying less than 1 MB storage or some terabytes of space or requires an individual server space. Your critical key data or information about your business could be stored in a database.

Use of a Database:
Store all your sales details or production details in a database and helps you later to understand many business related questions like your sales amount, production quantity etc.,

DBMS Database Management System:
DBMS is the software architecture with database software which helps you create, organize your data. DBMS includes a query computer language called as ‘SQL’ to query your database for the answers or information you are looking for. DBMS architecture manages the storage structure of all the data in the database and maintains integrity, security of your data.

Database Models:

Flat Database Model: Database with only one column but numerous rows. Imagine an array of data that are arranged in a file, they form the flat database model.
EX: Employee names arranged one after the other under a column header called ‘Emp_Name’.

Hierarchical Database Model: Database with nested or hierarchical structure. Data stored with information of the same level imagine your folder organization in a computer.
EX: Day-wise production information of your business arranged each in a file separately.

Network Model: The information is networked to each other.
EX: The next data or information is pointer to the node number of the next data.

Relational Model: The information is arranged in a form of table with columns and rows. Each row is a record and each record can have multiple columns as wells each column can have multiple rows. Imagine your excel file with ‘n’ number of column headers and data added for each column up-to n number of rows. Relational Model is the best Database model to store data as well as access the data. SQL is the query language used to access Relational Database Model or RDBMS systems. Each table could be linked to other table with the help of the key fields to access information from different tables which could be linked using key fields.

The relational database model or RDBMS is the popular and widely used model because of its capability to store as well as access huge data.

Related posts:

1. Relational Database Relational Database, the data or information are gathered and arranged...
2. Multimedia Database Multimedia database are the data that consists of images, graphics,...
3. Data Dictionary Data Dictionary is an organized file of details about the...
4. What is SQL SQL is the computer language to manage data in the...
5. Flat File Flat file is static document, textual document that contains data...