Chapter 12 Review
Compare a database with a database management system.
A database is a structured set of data. A database management system is a software system made up of the database, a database engine (for manipulating the database), and a database schema that provides the logical view of the database.
What is a field (attribute) in a database?
A field is a single value in a database record. A field represents one aspect or attribute of the item in a database.
Describe the general organization of a relational database.
A relational database is organized around the concept of a table. Both data and relationships are represented in tables.
What is an ER diagram?
An ER diagram is a graphical representation of an Entity-relationship model, which is a technique for design relational databases.
A cell in a spreadsheet can contain only raw data.
False
A circular reference in a spreadsheet is a powerful and useful situation.
False
A range of cells can be specified that go horizontally or vertically, but not both.
False
A transposition cipher is an example of modern cryptography that is difficult for a computer to break.
False
Decryption is the process of converting plaintext into ciphertext.
False
E-commerce is the process of keeping financial records, such as accounts payable, online.
False
The hierarchical model is the most popular database management model today.
False
The physical database represents the logical structure of the data in the database.
False
What-if analysis can only affect one value at a time in a spreadsheet.
False
A spreadsheet function is a program that the user writes to compute a value.
False (they are built into the software)
What is a key in a relational database table?
In a relational database, every record in a table must be uniquely identified. The field or combination of fields that are used to uniquely identify records in a table is called the key field.
A database engine is software that supports access to the database contents.
True
A database engine often interacts with a particular language for accessing and modifying the database.
True
A database table is a collection of records, and a record is a collection of fields.
True
A digital signature allows the recipient to verify that the message truly originates from the stated sender.
True
A query is a request to a database for information.
True
A spreadsheet is useful for performing what-if analysis.
True
A spreadsheet should be set up so that changes to the data are automatically reflected in any cells affected by that data.
True
An entity-relationship (ER) diagram represents primary database elements in a graphical form.
True
Information integrity ensures that data can be modified only by the appropriate mechanisms.
True
Pairing threats with vulnerabilities is a part of risk analysis.
True
The cardinality of a relationship puts restrictions on the number of relationships that can exist at one time.
True
The dot-com collapse promoted electronic commerce.
True
The results of a query can be structured in many ways.
True
The values in a spreadsheet can be formatted in a variety of ways.
True
The values in the key fields of a table uniquely identify a record among all other records in the table.
True
What is a database schema?
A database schema is the specification of the logical structure of a database.
