Relational Database Model Quiz

Who introduced the relational model?

• Bill Gates

• E. F. Codd

• Charles Babbage

• Alan Turing

What is the primary key in the STUDENT table?

• STU_FNAME

• STU_NUM

• STU_SECT

• STU_LNAME

Which of the following is NOT a component of the relational model?

• Logical data structure

• Integrity rules

• Data manipulation operations

• Data visualization

What does functional dependence mean?

• One attribute determines another

• Attributes can be null

• Attributes are independent

• All attributes are unique

Which of the following is a composite key?

• STU_NUM

• STU_NUM and STU_SECT

• STU_LNAME

• STU_FNAME

What is the purpose of referential integrity?

• To allow null entries in primary keys

• To maintain valid references between tables

• To enforce data types

• To ensure all entries are unique

Which operator retrieves a subset of rows from a table?

• JOIN

• SELECT

• PROJECT

• UNION

What does the term 'tuple' refer to in a database table?

• A key

• A row

• An attribute

• A column

Which of the following is a key attribute?

• An attribute that has no values

• An attribute that is part of a key

• An attribute that is not unique

• An attribute that can be null

What is the domain of the STU_MI values?

• [A, Z]

• [0, 100]

• [1, 10]

• [true, false]