TEST BANK MODERN DATABASE
MANAGEMENT, LATEST EDITION ||A+
Relationship - answers-association between entities
Types of relationships: - answers-One-to-many: Each rep is associated with many customers.
Each customer is associated with a single rep
Database - answers-structure that can store information about different categories of
information and relationships between those categories
Database Management System (DBMS) - answers-program, or collection of programs, through
which users interact with a database; can create forms and reports
Advantages of database processing: - answers-Getting more information from the same amount
of data
Sharing data
Balancing conflicting requirements
Controlling redundancy
Facilitating consistency
1
, Expanding security
Increasing productivity
Providing data independence
Disadvantages of database processing: - answers-Larger file size
Increased complexity
Greater impact of failure
More difficult recovery
Rules of a Relation - answers-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
2
MANAGEMENT, LATEST EDITION ||A+
Relationship - answers-association between entities
Types of relationships: - answers-One-to-many: Each rep is associated with many customers.
Each customer is associated with a single rep
Database - answers-structure that can store information about different categories of
information and relationships between those categories
Database Management System (DBMS) - answers-program, or collection of programs, through
which users interact with a database; can create forms and reports
Advantages of database processing: - answers-Getting more information from the same amount
of data
Sharing data
Balancing conflicting requirements
Controlling redundancy
Facilitating consistency
1
, Expanding security
Increasing productivity
Providing data independence
Disadvantages of database processing: - answers-Larger file size
Increased complexity
Greater impact of failure
More difficult recovery
Rules of a Relation - answers-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
2
