100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
Previously searched by you
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$17.99
Add to cart
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
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
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
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller Ascorers. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $17.99. You're not tied to anything after your purchase.