Describe the differences in meaning between the terms relation and relation schema?



In: Tech.Computers Asked by: sudhi3477 Mar 12, 2008 - 81 Months Ago.  Viewed 5293 times



 Sort Answers: DateScore  Helpfulness Votes   
Here's some translation from "Relational Algebra" to SQL terminology:
* "Relation" = Table.
* "Relation Schema" = Table definition.

So for example, the "schema" for the Person "relation" is:
 Person(FirstName, LastName, Age, Gender, Address)

Also in relational Algebra, a "tuple" is a table row, and an "attribute" is a table column.
Answered by: r56 - 81 Months Ago.
 Add Comments 

Describe the differences in meaning between the terms relation and relation schema? - HelpGlobe.Tech.Computers
 
About Legal Copyright 2007- Helpglobe.com Invite Contact