O'Reilly logo

Database Systems: Concepts, Design and Applications by S. K. Singh

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

4.3. Structure of Relational Database

Relational database system has a simple logical structure with sound theoretical foundation. The relational model is based on the core concept of relation. In the relational model, all data is logically structured within relations (also called table). Informally a relation may be viewed as a named two-dimensional table representing an entity set. A relation has a fixed number of named columns (or attributes) and a variable number of rows (or tuples). Each tuple represents an instance of the entity set and each attribute contains a single value of some recorded property for the particular instance. All members of the entity set have the same attributes. The number of tuples is called cardinality, and the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required