Relational Algebra and Calculus Quiz

What is the meaning of the term relational completeness?

• Relational completeness is the ability of a query language to express all queries in relational algebra.
• Relational completeness refers to the efficiency of a database system.
• Relational completeness is the ability to perform transactions in a database.
• Relational completeness means a database can store multiple data types.

How to form queries in relational algebra?

• Combine data using only union and intersection operations.
• Use operations like selection, projection, and join on relations to form queries.
• Form queries by writing SQL commands directly.
• Use only arithmetic operations like addition and subtraction.

What are the categories of relational DML?

• Procedural DML and Non-Procedural DML
• Basic DML and Advanced DML
• Static DML and Dynamic DML
• Structured DML and Unstructured DML

List all staff with a salary greater than £10,000.

• All staff

• Staff with salary less than £10,000

• Staff with salary greater than £10,000

• Staff with salary equal to £10,000

Produce a list of salaries for all staff, showing only staffNo, fName, lName, and salary details.

• List of all staff

• List of staff with salaries

• List of staff with names

• List of staff with contact details

List all cities where there is either a branch office or a property for rent.

• Cities with branch offices

• Cities with properties for rent

• Cities with both branch offices and properties

• All cities

List all cities where there is a branch office but no properties for rent.

• Cities with branch offices

• Cities with properties for rent

• Cities with both branch offices and properties

• All cities

List all cities where there is both a branch office and at least one property for rent.

• Cities with branch offices

• Cities with properties for rent

• Cities with both branch offices and properties

• All cities

List the names and comments of all clients who have viewed a property for rent.

• Names of clients

• Comments of clients

• Names and comments of clients

• All client details

Produce a status report on property viewings.

• Report on all properties

• Report on property viewings

• Report on client viewings

• Report on property sales