Category: Database Architecture

Normalization forms

Normalization In DBMS

Database normalization or data normalization is a technique for decomposing record sets to eliminate data redundancy based on the relationship between record attributes. Normalization concept became popular with the adoption of relational database management...

Network Model

The network model is a flexible way of representing entities and their relationships. This model forms a graph in which entities are nodes and relationship types are the connecting edges.     The network model...

Relational Data Model

This the most extensively used data model for the last ten years. Relational model provides a declarative method for specifying data and queries. The database unambiguously informs what it contains. Users just specify what information...

Data Models

A data model determines the logical structure of a database and fundamentally determines in which manner data can be stored, organized, and manipulated, representing a real world scenario. Data models are based on data,...

Entity-Relationship Model

An entity–relationship model (ER model) is a high level model that is used to help design databases. This model is based on the notion of real world entities and the relationships existing between them....

Hierarchical Data Model

In hierarchical data model, the data is organized into a tree-like structure. The data is stored as records  and the records are connected to one another through links. A record is a set of fields, where each...