0
Describe the differences in meaning between the terms relation and relation schema?
Wiki User
∙ 12y ago
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)
Wiki User
∙ 12y ago
Add your answer:
Earn +20 pts
What is a description?
The meaning of something. A description is when you describe something.a description is when you describe something.
What is the meaning betwixt?
The word "betwixt" is an archaic term that means "between." It is often used in a poetic or old-fashioned context to describe something that is located or happening between two things or in the middle of something.
What does the term 'proportional' refer to?
The term "proportional" is used to denote a relationship between two things with respect to their size. In mathematics the meaning is that two quantities have the same or a constant ratio or relation.
What is the meaning item 68?
Is the term used to describe a new product from the market.
What is the meaning of yingyang?
Yin and yang is the term used to describe how opposites or contrary forces are interconnected and interdependent.
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 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 relation in Tagalog?
meaning of relation in Tagalog: relasyon
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 differences between humiliation and mortification?
They are two words meaning the same thing.
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.
