What is the difference between a procedural and non-procedural language? How would you classify the relational algebra and relational calculus?
What will be an ideal response?
Procedural language: a language that allows user to tell the system what data is needed and
exactly how to retrieve the data.
Non-procedural language: a language that allows user to state what data is needed rather
than how it is to be retrieved.
Informally, we may describe the relational algebra as a (high-level) procedural language: it
can be used to tell the DBMS how to build a new relation from one or more relations in the
database. Again, informally, we may describe the relational calculus as a non-procedural
language: it can be used to formulate the definition of a relation in terms of one or more database relations.
You might also like to view...
Which of the following is the MOST important factor when considering environmental factors?
A. Server room access should be limited to authorized personnel. B. Servers should be kept in a warm and dark environment. C. Remove the floppy drives from the system. D. The server administrator should ensure adequate levels of cooling.
____________________ is the space between each letter.
Fill in the blank(s) with the appropriate word(s).