COSC 3380 Exam 1 Review questions
with verified solutions
The primary key of a table created from a many-many relationships is the ___ of the foreign keys that
refer to related tables - correct answer ✔✔Composite
A ____ is a collection of values that are of the same type - correct answer ✔✔Column
What does a user that interacts with a database use to read and write data? - correct answer ✔✔Query
language
Which principle defines data independence? - correct answer ✔✔Physical design never affects query
results
In some ER modeling conventions, ____ entities are called strong and _____ entities are called weak -
correct answer ✔✔independent, dependent
Boyce-Codd normal form provides an improvement over ____ normal form - correct answer ✔✔third
A(n) ____ attribute instance describes at most one entity instance - correct answer ✔✔Unique
The entity Book includes Paperback, Hardcover, and Digital books. The attribute ChapterCount applies to
both paperback and hardcover but not digital. Digital has a Texttospeech attribute. Which entity type is
Digital? - correct answer ✔✔Subtype
A database administrator normalizes a table to Boyce-Codd normal form. This involves identifying
dependencies on non-unique ____ - correct answer ✔✔Columns
When creating an ER diagram, a dependency relationship is drawn with an arrow pointing to a ____
entity. - correct answer ✔✔Master
, How does a database system protect data when concurrent transactions occur? - correct answer
✔✔Preventing multiple transactions with the same data at the same time
Which goes in the table on the "many" side of a one-many relationship? - correct answer ✔✔Foreign key
What is the result when Bryan McNeal's TeacherID is changed to 45672? - correct answer ✔✔The
TeacherID for Web Development is set to NULL
Where is the list of attribute types - correct answer ✔✔Glossary
Which action has been specified for the TeacherID foreign key? - correct answer ✔✔SET DEFAULT
During databse design, an entity with many optional attributes often becomes a(n) ____ entity - correct
answer ✔✔Supertype
Redundancy is possible in a ____ normal form table when one non-key column depends on another non-
key column - correct answer ✔✔Second
Evaluate the SQL statement and data below. What is the correct result? - correct answer ✔✔485
In a relational database model, which concept refers to a finite sequence of values that are derived from
defined domains? - correct answer ✔✔Tuple
A database designer interviews a salesteam that will be using a new database. During the interview, the
designer documents entities as ____ and relationships as _____ - correct answer ✔✔nouns, verbs
When data is produced and stored as numeric, texutal, or visual information, it varies in ____ - correct
answer ✔✔format
The analysis phase of database design includes which process? - correct answer ✔✔Specifying
requirements that are not dependent on a specific database system
with verified solutions
The primary key of a table created from a many-many relationships is the ___ of the foreign keys that
refer to related tables - correct answer ✔✔Composite
A ____ is a collection of values that are of the same type - correct answer ✔✔Column
What does a user that interacts with a database use to read and write data? - correct answer ✔✔Query
language
Which principle defines data independence? - correct answer ✔✔Physical design never affects query
results
In some ER modeling conventions, ____ entities are called strong and _____ entities are called weak -
correct answer ✔✔independent, dependent
Boyce-Codd normal form provides an improvement over ____ normal form - correct answer ✔✔third
A(n) ____ attribute instance describes at most one entity instance - correct answer ✔✔Unique
The entity Book includes Paperback, Hardcover, and Digital books. The attribute ChapterCount applies to
both paperback and hardcover but not digital. Digital has a Texttospeech attribute. Which entity type is
Digital? - correct answer ✔✔Subtype
A database administrator normalizes a table to Boyce-Codd normal form. This involves identifying
dependencies on non-unique ____ - correct answer ✔✔Columns
When creating an ER diagram, a dependency relationship is drawn with an arrow pointing to a ____
entity. - correct answer ✔✔Master
, How does a database system protect data when concurrent transactions occur? - correct answer
✔✔Preventing multiple transactions with the same data at the same time
Which goes in the table on the "many" side of a one-many relationship? - correct answer ✔✔Foreign key
What is the result when Bryan McNeal's TeacherID is changed to 45672? - correct answer ✔✔The
TeacherID for Web Development is set to NULL
Where is the list of attribute types - correct answer ✔✔Glossary
Which action has been specified for the TeacherID foreign key? - correct answer ✔✔SET DEFAULT
During databse design, an entity with many optional attributes often becomes a(n) ____ entity - correct
answer ✔✔Supertype
Redundancy is possible in a ____ normal form table when one non-key column depends on another non-
key column - correct answer ✔✔Second
Evaluate the SQL statement and data below. What is the correct result? - correct answer ✔✔485
In a relational database model, which concept refers to a finite sequence of values that are derived from
defined domains? - correct answer ✔✔Tuple
A database designer interviews a salesteam that will be using a new database. During the interview, the
designer documents entities as ____ and relationships as _____ - correct answer ✔✔nouns, verbs
When data is produced and stored as numeric, texutal, or visual information, it varies in ____ - correct
answer ✔✔format
The analysis phase of database design includes which process? - correct answer ✔✔Specifying
requirements that are not dependent on a specific database system
