Show Mobile Navigation

Monday, March 21, 2016

, , ,

What is Relational Data Model in DBMS?

Leke Oyetoke - Monday, March 21, 2016

What is Relational Data Model?

Relational data model is described as the primary data model, which is used broadly around the world for data storage and processing. 


Structure of Relational Data Model

1. Tables: Tables houses, stores or saves relations 
among entities. A table has rows and columns, where rows represent records and columns represent the attributes.

2. Tuple: Tuple is a single row of a table which holds a single record for that relation.

3. Relation instance: This is represented by a finite collection of tuples in the relational database system. It does not have duplicate tuples.

4. Relation schema: A relation schema defines the relation name (table name), attributes, and their names.

5. Relation key: Each row has one or more attributes, known as relation key, which can identify the row in the relation (table) uniquely.

6. Attribute domain: Every attribute has some predefined value scope, known as attribute domain.


0 comments:

Post a Comment