Database Fundamentals Quiz

Who introduced the relational model in 1970?

• Mark Reyes

• E. F. Codd

• Matthew Santiago

• Marco Velasco

What is the primary key in the STUDENTS table?

• STU_LNAME

• STU_FNAME

• STU_NUM

• STU_MI

What is the purpose of referential integrity?

• To validate foreign key references

• To retrieve data for analysis

• To enforce consistency of data over time

• To ensure each row has a unique identity

What is the purpose of a composite key?

• To enforce entity integrity

• To combine multiple attributes into a single key

• To identify a unique row in a table

• To retrieve data efficiently

What does the SELECT operator in relational algebra do?

• Retrieves rows that are not found in another table

• Retrieves rows common to two tables

• Merges two tables into a new table

• Retrieves a subset of rows based on a condition

What is the purpose of entity integrity?

• To ensure each row has a unique identity

• To retrieve data for analysis

• To enforce consistency of data over time

• To validate foreign key references

What is the primary key in the SECTIONS table?

• STU_SECT

• STU_NUM

• PROG_TITLE

• CURRICULUM_VER

What is the purpose of a superkey?

• To identify a unique row in a table

• To enforce entity integrity

• To uniquely identify any row in the table

• To combine multiple attributes into a single key

What is the purpose of a secondary key?

• To identify a unique row in a table

• To combine multiple attributes into a single key

• To retrieve data efficiently

• To enforce entity integrity

What is the purpose of functional dependence?

• To ensure each row has a unique identity

• To retrieve data for analysis

• To determine the value of one attribute based on another

• To validate foreign key references