1 / 21

Chapter 6

Chapter 6. 1. A grouping of characters into a word, a group of words, or a complete number is called a record. Answer: FALSE. 2. Each characteristic or quality describing a particular entity is called an attribute. Answer: TRUE. 3.

kamuzu
Download Presentation

Chapter 6

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Chapter 6

  2. 1 • A grouping of characters into a word, a group of words, or a complete number is called a record. • Answer: FALSE

  3. 2 • Each characteristic or quality describing a particular entity is called an attribute. • Answer: TRUE

  4. 3 • Program-data dependencerefers to the coupling of data stored in files and software programs that use this data such that changes in programs require changes to the data. • Answer: TRUE

  5. 4 • A DBMS separates the logical and physical views of the data. • Answer: TRUE

  6. 5 • Every record in a file should contain at least one key field. • Answer: TRUE

  7. 6 • Many applications today require databases that can store and retrieve multimedia. • Answer: TRUE

  8. 7 • One of the drawbacks to OODBMS are that they cannot work with applets. • Answer: FALSE

  9. 8 • Which of the following is NOT one of the main problems with a traditional file environment? • A) data inconsistency • B) program-data independence • C) lack of flexibility in creating ad-hoc reports • D) poor security • Answer: B

  10. 9 • A DBMS reduces data redundancy and inconsistency by • A) enforcing referential integrity. • B) uncoupling program and data. • C) utilizing a data dictionary. • D) minimizing isolated files with repeated data. • Answer: D

  11. 10 • Which of the following best illustrates the relationship between entities and attributes? • A) the entity CUSTOMER with the attribute PRODUCT • B) the entity CUSTOMER with the attribute PURCHASE • C) the entity PRODUCT with the attribute PURCHASE • D) the entity PRODUCT with the attribute CUSTOMER • Answer: B

  12. 11 • A characteristic or quality describing an entity is called a(n) • A) field. • B) tuple. • C) key field. • D) attribute. • Answer: D

  13. 12 • Which of the following non-digital data storage items is most similar to a database? • A) library card catalog. • B) cash register receipt. • C) doctor's office invoice. • D) list of sales totals on a spreadsheet. • Answer: A

  14. 13 • The confusion created by ________ makes it difficult for companies to create customer relationship management, supply chain management, or enterprise systems that integrate data from different sources. • A) batch processing • B) data redundancy • C) data independence • D) online processing • Answer: B

  15. 14 • Duplicate data in multiple data files is called data ________. • A) redundancy • B) repetition • C) independence • D) partitions • Answer: A

  16. 15 • The logical view • A) shows how data are organized and structured on the storage media. • B) presents an entry screen to the user. • C) allows the creation of supplementary reports. • D) presents data as they would be perceived by end users. • Answer: D

  17. 16 • In a relational database, the three basic operations used to develop useful sets of data are • A) select, project, and where. • B) select, join, and where. • C) select, project, and join. • D) select, from, and join. • Answer: C

  18. 17 • Databases record information about general categories of information referred to as ________. • Answer: entities

  19. 18 • Data ________ describes a situation in which the same attribute of a data entity may have different values. • Answer: inconsistency

  20. 19 • A(n) ________ view shows data as it is actually organized and structured on the data storage media. • Answer: physical

  21. 20 • DBMS have a(n) ________ capability to specify the structure of the content of the database. • Answer: data definition

More Related