About tables

About tables

Please describe the basic components of a table in the relational model.

A table has an intension and an extension. You can think of the intension of a table as the names of its columns, so the intension describes the thing the table is about.The extension of a table is the table’s rows, or instances, examples, or samples of the table’s intention? things that exist in the universe described by the domains of the table.

Domains are the conceptual pool of values from which attributes can be drawn, and are the glue that make comparisons possible in a database. Domains are what make operations make sense in attributes. We don’t ask for the temperature of Orange, or the product of Nuts times Bolts because the comparisons make no sense because the domains are different.

The main thing for you to carry from this is that domains describe the universe of discourse, and the organization of domains into tables allows us to collect instances of the entity described by the domains. Operations defined on the domains are what let us do compares, make products, divisions, unions, differences and additions of relational facts.

See also  Does It Make Sense to Splurge on a Laptop?

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist