dcsimg
Login | Register   
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX

By submitting your information, you agree that devx.com may send you DevX offers via email, phone and text message, as well as email offers about other products and services that DevX believes may be of interest to you. DevX will process your information in accordance with the Quinstreet Privacy Policy.


Tip of the Day
Language: SQL Server
Expertise: Beginner
Jul 15, 1999

WEBINAR:

On-Demand

Application Security Testing: An Integral Part of DevOps


About tables

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

Answer:
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.

DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
×
We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.
Thanks for your registration, follow us on our social networks to keep up-to-date