MODERN DATABASE MANAGEMENT
13TH EDITION TEST BANK 2026
STUDY GUIDE COMPREHENSIVE
QUESTIONS ANSWERS VERIFIED A+
◉ Types of relationships:.
Answer: One-to-many: Each rep is associated with many customers.
Each customer is associated with a single rep
◉ Database.
Answer: structure that can store information about different categories of
information and relationships between those categories
◉ Database Management System (DBMS).
Answer: program, or collection of programs, through which users
interact with a database; can create forms and reports
◉ Advantages of database processing:.
Answer: Getting more information from the same amount of data
Sharing data
Balancing conflicting requirements
,Controlling redundancy
Facilitating consistency
Expanding security
Increasing productivity
Providing data independence
◉ Disadvantages of database processing:.
Answer: Larger file size
Increased complexity
Greater impact of failure
More difficult recovery
◉ Rules of a Relation.
Answer: Two-dimensional table in which:
, Entries are unnormalized
Each column has a distinct name (attribute name)
All values in a column are values of the same attribute
Order of columns is immaterial
Each row is distinct
Order of rows is immaterial
◉ Attribute.
Answer: characteristic or property of an entity (field/column)
◉ Primary Key.
Answer: column or collection of columns of a table (relation) that
uniquely identifies a given row in that table
◉ Foreign key.
Answer: field(s) whose value is required to match the value of the
primary key for a second table
◉ Relational database.
13TH EDITION TEST BANK 2026
STUDY GUIDE COMPREHENSIVE
QUESTIONS ANSWERS VERIFIED A+
◉ Types of relationships:.
Answer: One-to-many: Each rep is associated with many customers.
Each customer is associated with a single rep
◉ Database.
Answer: structure that can store information about different categories of
information and relationships between those categories
◉ Database Management System (DBMS).
Answer: program, or collection of programs, through which users
interact with a database; can create forms and reports
◉ Advantages of database processing:.
Answer: Getting more information from the same amount of data
Sharing data
Balancing conflicting requirements
,Controlling redundancy
Facilitating consistency
Expanding security
Increasing productivity
Providing data independence
◉ Disadvantages of database processing:.
Answer: Larger file size
Increased complexity
Greater impact of failure
More difficult recovery
◉ Rules of a Relation.
Answer: Two-dimensional table in which:
, Entries are unnormalized
Each column has a distinct name (attribute name)
All values in a column are values of the same attribute
Order of columns is immaterial
Each row is distinct
Order of rows is immaterial
◉ Attribute.
Answer: characteristic or property of an entity (field/column)
◉ Primary Key.
Answer: column or collection of columns of a table (relation) that
uniquely identifies a given row in that table
◉ Foreign key.
Answer: field(s) whose value is required to match the value of the
primary key for a second table
◉ Relational database.
