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.

Computer Science & Information Technology

You might also like to view...

Define route summarization.

What will be an ideal response?

Computer Science & Information Technology

A database system includes ________.

a) the data in the database. b) the hardware on which the data resides. c) the software that controls access to the data. d) all of the above

Computer Science & Information Technology

After a document has finished going through the review process, the original author can disregard the suggestions by choosing to ________ the changes

Fill in the blank(s) with correct word

Computer Science & Information Technology

The ____ option of the SizeMode property of the PictureBox object will increase or decrease the size of the PictureBox object to accommodate the size of the image.

A. CenterImage B. Normal C. AutoSize D. Zoom

Computer Science & Information Technology