what is the difference between relational calculus and
relational algebra ?
Answers were Sorted based on User's Feedback
Answer / divya
relational calculus is a declarative way to specify the queries,whereas relational algebra is a procedural way to specify the queries.
Is This Answer Correct ? | 40 Yes | 4 No |
Answer / ajeet kr.sharma(weir)bharatpur
r.alg. is procedural lenguage while r.c. is non-procedural
lenguage.
Is This Answer Correct ? | 26 Yes | 7 No |
Answer / megha aditya
relational algebra easy to manipulate then relational calculus..
modifications are easy in queries of relational algebra... then in relational calculus
Is This Answer Correct ? | 7 Yes | 5 No |
Answer / shalinithakur
RC are formed WFFs where as RA does not form any formula
Is This Answer Correct ? | 3 Yes | 1 No |
Answer / ravina
The query is in the form of different operators in relational algebra and in calculus queries is in the form of formula.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / parul
relational algebra is depend upon the order of operations
wheres
relational calculus does not depend upon the order of the operations
Is This Answer Correct ? | 0 Yes | 0 No |
Which is the best sorting method if i have to sort the students of Harvard University according to their first name?
where can i free download sqlserver2008..i can install sqlserver2008 without visual studio 2008 and work on it
query to Compare data of two tables between two different Databases(Oracle and SQL Server) Eg., Source Database: Oracle Table: Employee Target Database : SQL Server Table : emp
sparse lookup and where its options we find in OCI and db2?
How to do Data size testing? Who does this testing (Developer or tester)?
how to configure oracle 10g in java1.5 and tell me know how to set class path in system?
What are the disadvantages of views in a database?
What is difference between data and database?
what are different types of datasets? what are different characteristics or properties of those datasets? what are the advantages and disadvantages of each dataset on each other?
How to fetch/retrieve the data from hieranchical database and put it into the relational database? for e.g I want to extract the data from IMS DB2 database which is a hierarchical db and load that data into the relational database which is a SQL server.Are there any tools available for directing extracting data from hierarchical db and loading into the relational database (SQL server)?
Under which circumstance should you create an index on a table?
Define the following terms i. Inverted List ii. Candidate Key iii. B-Tree iv. Foreign Key