Solutions Manual for Concepts of Database Management, 10th Edition by Lisa Friedrichsen , Lisa Ruffolo, Ellen Monk, Joy Starks & Philip Pratt ||All Chapters Complete A+ Guide

Concepts of Database Management 10th
f f f f




Edition by Lisa Friedrichsen
f f f f




CompleteChapterModule f f




f Solutions are included (Ch f f f




1 to 9) f f f




** Immediate Download
f f




** Swift Response
f f




** All Modules included
f f f




** Extra Solutions Files
f f f

,Module 1 f




Introduction to Database Management Solutions f f f f




REVIEW QUESTIONS
f




1. is the duplication of data or the storing of the same data in more than one place.
f f f f f f f f f f f f f f f f




a. Data security f




b. Data inconsistency f




c. Data independence f




d. Data redundancy f




2. Which of the following is not a problem associated with redundancy?
f f f f f f f f f f




a. prevents orphan records f f




b. makes updating data more cumbersome and time-consuming
f f f f f f




c. can lead to inconsistencies
f f f




d. results in more frequent data errors
f f f f f




3. A(n) f is a person, place, object, event, or idea for which you want to store and process data.
f f f f f f f f f f f f f f f f




a. attribute

b. entity

c. relationship

d. flat file f




4. A(n) f is a characteristic or property of an entity.
f f f f f f f




a. metadata

b. database

, c. flat file f




d. attribute

5. A(n) f f f f f is an association between entities. A(n)
f f f f f f f f f f exists between two entities when each
f f f f f




row in the first entity matches many rows in the second entity, and each row in the second entity matches
f f f f f f f f f f f f f f f f f f f f




only one row in the first entity.
f f f f f f f




a. record

b. one-to-many relationship (for second blank) f f f f




c. relationship (for first blank) f f f




d. attribute

6. A(n) f is a structure that contains data about many categories of information as well as the
f f f f f f f f f f f f f f




f relationships between those categories. f f f




a. table

b. data file f




c. relational database f




d. software stack f




7. Which of the following describes how to create a one-to-many relationship in a database system?
f f f f f f f f f f f f f f




a. Insert a new table between two existing tables.
f f f f f f f




b. Use a common field in the two tables to tie the related records from each table together.
f f f f f f f f f f f f f f f f




c. Create an entity-relationship (E-R) diagram.
f f f f




d. Include multiple entries in a single field. f f f f f f




8. In a(n)
f f , rectangles represent entities and display their attributes; lines represent relationships
f f f f f f f f f f




f between connected entities. f f




a. entity-relationship (E-R) diagram f f




b. unstructured data file f f

, c. spreadsheet

d. software stack f




9. Which of the following defines a DBMS?
f f f f f f




a. a collection of data that corresponds to one record
f f f f f f f f f




b. a file used to store data about a single entity
f f f f f f f f f




c. the person or group in charge of a database
f f f f f f f f




d. a program through which users interact with the data stored in a database
f f f f f f f f f f f f




10. Which of the following describes database design?
f f f f f f




a. collecting the large volume of data produced by digital processes and devices
f f f f f f f f f f f




b. creating a file used to store data about a single entity
f f f f f f f f f f




c. creating the entities, attributes, and relationships between tables of data
f f f f f f f f f




d. Converting the data in a database to a format indecipherable to normal programs
f f f f f f f f f f f f