4.2 Relational Data Structures
The data structures used in the relational model are tables with relationships among them.
4.2.1 Tables
The relational model is based on the concept of a relation, which is physically represented as a table or two-dimensional array. In this model, tables are used to hold information about the objects to be represented in the database. Using the terms of the entity-relationship model, both entity sets and relationship sets can be shown using tables. A relation is represented as a two-dimensional table in which the rows of the table correspond to individual records and the columns correspond to attributes. For example, the Student relation is represented by the Student table, having columns for attributes stuId ...
Get Databases Illuminated, 4th Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
