answersLogoWhite

0


Best Answer

Relational Schema refers to meta-data elements which are used to describe structures and constraints of data representing a particular domain. Whereas a relation is a property or predicate that ranges over more than one argument 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.
Mathematician define a relation to be subset of cartesian product list of domains.

In daabase relation is a set of entities with similar attributes.

In other way we can consider a relation as a table and it's rows as entities, and table's columns as attributes.Concept of relation corresponds to programming language notion of variable.

relational Schema corresponds to the programming language notion of type definition.

It is the logical design of database.

e.g. for a relation account having attributes account_number, branch_name and balance, relational schema is specified as -

Account_schema= (account_number, branch_name, balance)

User Avatar

Wiki User

12y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: Describe the differences in meaning between the terms relation and relation schema?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What is the similarties between moromon and christian?

Moromon follows the different meaning from relation between Mary madline &Jesus or relation between roman king and his daughter on whom king had lust on her. Same relation describe in every religion which has very different meaning than enlighten person understand. Need deep discution. Write to me again:


What is the meaning of relation in Tagalog?

The meaning of "relation" in Tagalog is "kaugnayan" or "relasyon." It refers to the connection or bond between two or more things or people.


What does the term shades of meaning mean?

Shades of meaning is a phrase used to describe the small, subtle differences in meaning between similar words or phrases; 'kid' and 'youth' both refer to young people, but carry differing views and ideas about young people.


What is the Telugu meaning of relation?

The Telugu meaning of relation is సంబంధం (sambandham).


What is the meaning of vulpine?

Vulpine is something that is in relation to a fox species. It can also be used to describe someone/something that is sly, cunning, or crafty.


What is the relationship between Coordinated Management of Meaning theory and the Symbolic Interactionism theory?

the differences between co-ordinated management of meaning and symbolic interactionism theories


What is public relation management?

THE MEANING OF PUBLIC RELATION MANAGEMENT


What differences are there between Cyprus and the UK?

The notes and coins are difference meaning meaning there money and a similarity is that they use noted and coins like the UK


What is the meaning of voltmeter?

An instrument for measuring in volts the differences of potential between different points of an electrical circuit.


What is the meaning of economies of product differences?

The meaning of economies of product differences... The greater the difference in products produced by two economies the greater the economic efficiency to be obtained from trade between the two as per the theory of comparative advantage.


What is the meaning of where as?

It shows a relation of something.


What is the meaning where as?

It shows a relation of something.