What is Relational Database Model ?

Leave a comment (4) Go to comments

Introduction to RDBMS : Day 1 : Chapter 1

In this chapter, you will learn to:

What is Relational Database Model ?

In Relational Database model, data is organized/stored in tables. this model was introduced by E.F. Codd in 1970.

  • Relational model is an attempt to simplify the database structure.
  • It represents all data in the database as simple tables in the row-column format.
  • RDBMS can be defined as a DBMS where all data visible to the user is organized strictly as tables of data values and where all database operations work on these tables.

What is Relational Database Model ? Relational Database Model

The above picture clearly defines

  • The organizing principle in a relational database is the table, a tabular arrangement of data values:
    • A table is called a relation.
    • The row (or record) in the table is called a tuple.
    • The column (or field) is called an attribute.
    • The number of tuples is called the cardinality
    • The number of attributes is called the degree of the table.

Want to know more about this topic.


PREVIOUS NEXT

Page 1 2 3 4 5 6 7

EOF - What is Relational Database Model ?, SQL Server 2012 , 2008 R2 , 2008 , 2005 , 2000
Leave a comment

4 Comments.

Leave a Reply

Your email address will not be published. Required fields are marked *


*


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Notify me of followup comments via e-mail. You can also subscribe without commenting.