answersLogoWhite

0

What is the Diff. Between Relational Algebra & Calculas?

{| ! width="33%" | Point of Comparison |- ! width="33%" | R.Algebra ! width="33%" | R.Calculus | Is it Query Language ? YES YES Relation Query Describe step-by-step proceduar for computing the desired answer ,depend on the order in which operator are applies in query Describe the set of answer without being excplicit about how they should be computed Type Proceduar Non-proceduar |}

User Avatar

Wiki User

16y ago

What else can I help you with?

Continue Learning about Math & Arithmetic

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


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.


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?"


Where did the word algebra and calculus came from?

algebra - arabic, calculus - latin

Related Questions

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 are the different types of database languages?

Two main types: Relational Calculus based Language Relational Algebra based Language. These languages provide similar set of operations but with different syntax. Calculus based is more kind of procedural and near to English, while Algebra based uses a set of symbols for queries.


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.


Are calculus and linear algebra courses hard for an individual who got an a plus in algebra?

you don't go from algebra to calculus and linear algebra. you go from algebra to geometry to advanced algebra with trig to pre calculus to calculus 1 to calculus 2 to calculus 3 to linear algebra. so since you got an A+ in algebra, I think you are good.


What relation and relation schema?

Relational Schema refers to meta-data elements which are used to describe structures and constraints of data representing a particular http://wiki.answers.com/Describe_the_differences_in_meaning_between_the_terms_relation_and_relation_schema#. Whereas a relation is a property or predicate that ranges over more than one argumentHere's some translation from "Relational Algebra" to http://wiki.answers.com/Describe_the_differences_in_meaning_between_the_terms_relation_and_relation_schema#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.


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?"


Where did the word algebra and calculus came from?

algebra - arabic, calculus - latin


Is relational algebra a branch of abstract algebra?

Yes, relational algebra can be considered a branch of abstract algebra, as it involves a set of operations on relations, which can be viewed through the lens of mathematical structures. Relational algebra provides a formal framework for querying and manipulating data in databases, utilizing concepts such as sets and operations like union, intersection, and difference. While it specifically focuses on data manipulation, its foundations are rooted in the principles of abstract algebra.


What is the difference between Algebra 2 and Pre calculus?

Im currently taking Pre Calculus and took Algebra 2 last year. To be honest, there really is no difference, there are only three new chapters of content we didnt go over last year in the whole book. If you passed Algebra 2 you'll pass Pre Calculus.


Is relational algebra under abstract algebra?

yes


Software on relational algebra?

Oracle8i