Close
Register
Close Window

Database

Chapter 1 Main Phases of Relational Database Design

Show Source |    | About   «  1.1. How ERD and RDD are related?   ::   Contents   ::   1.3. Relational Integrity Constraints  »

1.2. Relational Data Model / Relational Database Diagram (RDD)

1.2.1. Definition:

Is a model that represents database in the form of two-dimensional tables with rows and columns of data These tables are called relations. Its a model based on the concept of sets.

A database usually contains more that one of these tables (relations).

Relational schema: means the way in which these relaions (tables) are descibed.

1.2.2. Terminology and Basic Concepts realated to RDD:

_images/RDDTerminology.png

Basic definitions illustrated in the following figures based on faculty database example.

_images/RelationSchema.png
_images/DatabaseSchema.png
_images/FDBSchemaLab.png
_images/Relation.png
_images/DatabaseInstance.png
_images/DatabaseState.png

   «  1.1. How ERD and RDD are related?   ::   Contents   ::   1.3. Relational Integrity Constraints  »

nsf
Close Window