Relational Database Quiz

Identify the CORRECT component of relational database structural terminology.

• Domain

• Procedure

• End User

• Database administrator

Identify a key to represent the relationship between relations.

• Secondary key

• Primary key

• Foreign key

• Super key

Identify the CORRECT symbol of PROJECT in Relational Algebra.

• 𝜋

• ∩

• χ

• 𝜎

Select the INCORRECT relational algebra operator to retrieve information.

• Join

• Cross product

• Foreign key

• Project

Identify the CORRECT symbol of Restrict in Relational Algebra.

• ∩

• σ

• Π

• χ

Based on the information in Figure 1, choose the CORRECT relational algebra expression.

• 𝜋 First_name, address (LECTURER)

• 𝜎 First_name, address (LECTURER)

• First_name, address (𝜎 LECTURER)

• 𝜋 First_name, address (𝜋 LECTURER)

Select the entity which most likely contains INVALID attributes.

• Entity: Student Attributes: Name, StudentID, Course, Major

• Entity: Pet Attributes: Class, Subject, Owner, CGPA

• Entity: Home Attributes: Owner, Address, House Type, DateBuilt

• Entity: Product Attributes: Manufacturer, dateProduce, Brand, Flavor

Select the INCORRECT traditional set of operators for relational table.

• Union

• Intersection

• Project

• Difference

Choose CORRECT integrity rule based on below statement.

• Entity integrity

• Referential integrity

• Primary integrity

• Foreign integrity

Choose the CORRECT notation to yields all tuples in one table that are not found in the other table.

• relationName1 - relationName2

• relationName1 ∩ relationName2

• relationName1  relationName2

• relationName1 + relationName2