0
Oracle8i
Wiki User
∙ 16y ago
Add your answer:
Earn +20 pts
What is the utility of relational algebra relational calculas name some software's based on these concept?
What is the utility of relational algebra relational calculas name some software's based on these concept?"
Explain the select Operation in Relational Algebra with an example?
Relational Algebra - Example
Unary and binary operators in relational Algebra?
The nnary and Binary operators in relational Algebra.
Is relational algebra under abstract algebra?
yes
Which relational algebra operators can be applied to a pair of tables that are not union compatible?
Which relational algebra operators can be applied to a pair of tables that are not union compatible
What is the utility of relational algebra relational calculas name some software's based on these concept?
What is the utility of relational algebra relational calculas name some software's based on these concept?"
Explain the select Operation in Relational Algebra with an example?
Relational Algebra - Example
Unary and binary operators in relational Algebra?
The nnary and Binary operators in relational Algebra.
Is relational algebra under abstract algebra?
yes
Which relational algebra operators can be applied to pair of tables that are not union compatible?
Which relational algebra operators can be applied to a pair of tables that are not union compatible
Which relational algebra operators can be applied to a pair of tables that are not union compatible?
Which relational algebra operators can be applied to a pair of tables that are not union compatible
Describe basic operation of relational algebra?
CHUT
is relational algebra non procedural?
Yes, relational algebra is non-procedural. Relational algebra comprises a collection of objects and operators on these objects. The operators may be used to specify which rows in the relations, or combinations or relations, are of interest but the operators do not in themselves specify any procedures or algorithms for identifying the items of interest. Please see the link.
Software on relational calculus?
MySQL
What is the best relational database software for mac?
The best relational database is Valentina Studio.
What are the main differences between relational algebra and relational calculus?
Relation algebra is a procedural language where relation calculus is non-procedural languageRelational algebra, an offshoot of first-orderlogic (and of algebra of sets), deals with a set of finitaryrelations (see also relation (database)) which is closed under certain operators. These operators operate on one or more relations to yield a relation. Relational algebra is a part of computer science.Relational calculus consists of two calculi, the tuplerelational calculus and the domain relational calculus, that are part of the relational model for databases and provide a declarative way to specify database queries. This in contrast to the relational algebra which is also part of the relational model but provides a more procedural way for specifying queries.The relational algebra might suggest these steps to retrieve the phone numbers and names of book stores that supply Some Sample Book:1. Join books and titles over the BookstoreID.2. Restrict the result of that join to tuplesfor the book Some Sample Book.3. Project the result of that restriction over StoreNameand StorePhone.The relational calculus would formulate a descriptive, declarative way:Get StoreNameand StorePhonefor supplies such that there exists a title BK with the same BookstoreIDvalue and with a BookTitlevalue of Some Sample Book.The relational algebra and the relational calculus are essentially logically equivalent: for any algebraic expression, there is an equivalent expression in the calculus, and vice versa.This result is known as Codd'stheorem
What is difference between linear syntax and relational algebra?
They are not alternative solutions so that we can compare them. Relational database (which is based on relational algebra) demands (atleast the founder of relational database Codd suggests) that the query language follow linear syntax. The linear syntax languages don't rely up on newline characters as terminators of expressions or statements -- instead they rely on other tokens such as semicolon or comma and so on.
