Anatomy of a table, PL-SQL Programming

Anatomy of a Table:

Figure shows the terminology used in SQL to refer to parts of the structure of a table.

209_Anatomy of a Table.png

As you can see, SQL has no official terms for its counterparts of the heading and body of a relation, but for convenience I do use those terms occasionally in the present book as applying to tables. SQL's counterpart of relational attribute is column. The figure shows the term field being used for SQL's counterpart of attribute value but please note that the international standard uses this term not only for a component of a row, as shown, but also for the corresponding component of the relevant row type.

Posted Date: 1/11/2013 5:00:26 AM | Location : United States

Related Discussions:- Anatomy of a table, Assignment Help, Ask Question on Anatomy of a table, Get Answer, Expert's Help, Anatomy of a table Discussions

Write discussion on Anatomy of a table
Your posts are moderated
Related Questions
Brewbean's is implementing a new discount for return shoppers - every fifth completed order receives a 10% discount. The count of orders for a shopper is placed in a packaged varia

Cursor Variables Similar to a cursor, cursor variable points to the current row in the result set of a multi-row query. But, dissimilar a cursor, a cursor variable can be opene

Row Counterparts of Table Operators SQL does not have counterparts tuple rename, tuple projection, tuple extension, tuple join and tuple compose. To obtain the same effects as

(a) What are decision support systems, and what role do they play in the business environment? (b) Data warehousing is defined as "a subject-oriented, integrated, non-volatile c

Inner Join We have learned how to retrieve data from one table by using SELECT statement. But, as we have learned, normalized relational databases mean the data is spread betw

Example of Null operator - NiNo Rule If we wanted to make HIGHER_OF adhere to "NULL in, NULL out"-let's call it the NiNo rule-we would have to write something like what is sho

Projection in SQL - correct version Student StudentId is enrolled on some course. SELECT DISTINCT StudentId FROM IS_ENROLLED_ON In more complicated examples it is someti

THEO R Y OF PANSPERMIA - Arrhenius (1908) postulated the cosmic panspermia theory that claims that organisms existed throughout the universe, and their spores, etc., could

What is Cursors how to use it in Real time application ?

Closest Approximation to Relational Union - SQL Actually, just as SQL has several varieties of JOIN, it also has several varieties of UNION, none of which is equivalent to th