Quiz 9
A foreign key is a field or set of fields stored in one table that also exists as a primary key in another table.
true
A relational database management system stores data in tables.
true
A relational database table is in third normal form (3NF) if it is in second normal form (2NF) and if no non-key field is functionally dependent on any other non-key field.
true
Which of the following is not a synonym of the others?
tulp
In a relational database, a row can be referred to as a(n) ____.
tuple
Microsoft SQL Server is an example of what?
a database management system
A field in a relational table called "address" would be an example of what?
complex data type
____ are a critical element of relational database design because they are the bases for representing relationships among tables.
keys
A separate relation must be created to store the attributes of a ____ relationship among two other classes.
many-to-many
A(n) ____ is a field or set of fields used to uniquely identify each row.
primary key
Referential integrity is normally enforced by the ____.
database management system
Which is NOT one of the responsibilities of the database administrator?
determine data confidentiality
What can be said about the following relational database table (key is underlined): (Choose the most correct answer) StudentID, Name, Major, CreditsCompleted, GPA, AcademicStanding
in First and Second Normal Form
____ is a consistent relational database state in which every foreign key value also exists as a primary key value.
referential integrity
One column of a table in a relational database is called a(n) ____.
attribute
Every table in a relational database must have a foreign key.
false
The domain data in a database is sometimes referred to as metadata.
false
A relational database table is in ____ normal form if it has no repeating fields or groups of fields, and hence all rows have the same columns.
first
A(n) ____ describes the structure, content, and access controls of a physical data store or database.
schema
Data elements in a relational database are organized into ____.
tables
