100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
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

Exam (elaborations)

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

 2 views  0 purchase
  • Course
  • Databases
  • Institution
  • Databases

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

Preview 4 out of 147  pages

  • October 31, 2024
  • 147
  • 2024/2025
  • Exam (elaborations)
  • Questions & answers
  • ellen monk joy sta
book image

Book Title:

Author(s):

  • Edition:
  • ISBN:
  • Edition:
  • Databases
  • Databases
avatar-seller
Ascorers
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

The benefits of buying summaries with Stuvia:

Guaranteed quality through customer reviews

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

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

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.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

83637 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy study notes for 14 years now

Start selling
$17.99
  • (0)
  Add to cart