INFO 3233 EXAM 1 QUESTIONS AND VERIFIED
ANSWERS
What is one or more attributes that determines other attributes? - Answers - key
What is a key that is composed of more than one attribute? - Answers - composite key
every primary key must be a _____________ - Answers - candidate key
What is any key that uniquely identifies each row, that functionally determines all of the
entity's attributes? - Answers - superkey
What is a superkey without unnecessary attributes? - Answers - candidate key
one candidate key for table - Answers - primary key
each table must have an attribute or combination of attributes that
___________________________ - Answers - uniquely identifies each row
key's role is based on _____________ - Answers - determination
What is an attribute used strictly for data retrieval purposes (does not need to be
unique)? - Answers - secondary key
________________ is an attribute whose values must match the primary key in another
table - Answers - foreign key
__________________ views data logically rather than physically - Answers - relational
model
What is it called if B is functionally dependent on A if each value in A determines one
and only one value in B - Answers - functional dependence
What is it called if B is functionally dependent on composite key A but not on any subset
of A? - Answers - full functional dependence
What is a textual representation of database tables? - Answers - relational schema
an entity with a unique identifier that has no nulls has ________________ - Answers -
entity integrity
FK column contains values that match PK values in table to which it is related is
_______________ - Answers - referential integrity
, What only returns rows? - Answers - SELECT
What returns columns? - Answers - PROJECT
What combines all rows from two tables, excluding duplicate rows? - Answers - UNION
What yields only the rows that appear in both tables? - Answers - INTERSECT
What subtracts duplicates from a second table? - Answers - DIFFERENCE
What yields all rows from two tables? - Answers - PRODUCT
What divides one column by another column and returns the similar values? - Answers -
DIVIDE
What allows information to be combined from two or more tables? - Answers - JOIN
What is the real power behind the relational database, allowing the use of independent
tables linked by common attributes? - Answers - JOIN
_________________ provides detailed accounting of all tables found in the database.
contains all the attribute names and characteristics for each table. - Answers - data
dictionary
What is a detailed system data dictionary that describes all objects in database
(including user authorizations and access privileges)? - Answers - system catalog
What relationship is the ideal relational model? - Answers - 1:M
a table can have ________ index(es) - Answers - many
DBMS automatically creates index based on ___________ - Answers - primary key
What relationship should be rare in relational database? - Answers - 1:1
What relationship can't be implemented in relational model? - Answers - M:N
______________ is used to access rows in a table. - Answers - index
___________ is iterative and progressive - Answers - data modeling
________________ is anything about which data are to be collected and stored -
Answers - entity
_________________ is a characteristic of an entity - Answers - attribute
ANSWERS
What is one or more attributes that determines other attributes? - Answers - key
What is a key that is composed of more than one attribute? - Answers - composite key
every primary key must be a _____________ - Answers - candidate key
What is any key that uniquely identifies each row, that functionally determines all of the
entity's attributes? - Answers - superkey
What is a superkey without unnecessary attributes? - Answers - candidate key
one candidate key for table - Answers - primary key
each table must have an attribute or combination of attributes that
___________________________ - Answers - uniquely identifies each row
key's role is based on _____________ - Answers - determination
What is an attribute used strictly for data retrieval purposes (does not need to be
unique)? - Answers - secondary key
________________ is an attribute whose values must match the primary key in another
table - Answers - foreign key
__________________ views data logically rather than physically - Answers - relational
model
What is it called if B is functionally dependent on A if each value in A determines one
and only one value in B - Answers - functional dependence
What is it called if B is functionally dependent on composite key A but not on any subset
of A? - Answers - full functional dependence
What is a textual representation of database tables? - Answers - relational schema
an entity with a unique identifier that has no nulls has ________________ - Answers -
entity integrity
FK column contains values that match PK values in table to which it is related is
_______________ - Answers - referential integrity
, What only returns rows? - Answers - SELECT
What returns columns? - Answers - PROJECT
What combines all rows from two tables, excluding duplicate rows? - Answers - UNION
What yields only the rows that appear in both tables? - Answers - INTERSECT
What subtracts duplicates from a second table? - Answers - DIFFERENCE
What yields all rows from two tables? - Answers - PRODUCT
What divides one column by another column and returns the similar values? - Answers -
DIVIDE
What allows information to be combined from two or more tables? - Answers - JOIN
What is the real power behind the relational database, allowing the use of independent
tables linked by common attributes? - Answers - JOIN
_________________ provides detailed accounting of all tables found in the database.
contains all the attribute names and characteristics for each table. - Answers - data
dictionary
What is a detailed system data dictionary that describes all objects in database
(including user authorizations and access privileges)? - Answers - system catalog
What relationship is the ideal relational model? - Answers - 1:M
a table can have ________ index(es) - Answers - many
DBMS automatically creates index based on ___________ - Answers - primary key
What relationship should be rare in relational database? - Answers - 1:1
What relationship can't be implemented in relational model? - Answers - M:N
______________ is used to access rows in a table. - Answers - index
___________ is iterative and progressive - Answers - data modeling
________________ is anything about which data are to be collected and stored -
Answers - entity
_________________ is a characteristic of an entity - Answers - attribute
