Midterm Quiz1 - Information Management

Who introduced the relational model in 1970?

• Tim Berners-Lee

• Alan Turing

• Grace Hopper

• E. F. Codd

What is used extensively in mathematics to verify assertions as true or false?

• Set theory

• Calculus

• Algebra

• Predicate logic

What is a table in the relational model composed of?

• Rows and columns

• Points and lines

• Circles and squares

• Letters and numbers

Which attribute is considered the primary key in the STUDENT table?

• STU_LNAME

• STU_NUM

• STU_SECT

• STU_FNAME

What is the purpose of referential integrity in a database?

• Ensure valid references between entities

• Ensure unique identities for each row

• Ensure data manipulation operations

• Ensure consistent data format

What is the standard notation for representing the relationship between attributes?

• ATT_A + ATT_B

• ATT_A → ATT_B

• ATT_A ↔ ATT_B

• ATT_A = ATT_B

What is the purpose of a superkey in a database table?

• Enforce integrity rules

• Determine the value of another attribute

• Retrieve a subset of columns

• Uniquely identify any row in the table

What is the condition for entity integrity in a table?

• Values in a column conform to the same data format

• Attributes have functional dependence

• Foreign key values match primary key values

• All primary key entries are unique

What is the purpose of relational algebra in database systems?

• Manipulate relational table contents

• Enforce integrity rules

• Create new tables

• Define attribute domains

Which operator is used to retrieve rows that are common to two tables?

• DIFFERENCE

• UNION

• JOIN

• INTERSECT