Intro to Database Management Sixth Edition Chapter One

Kirk Forrest

Professor Osborn

1/13/13

Concepts of Database Management

Chapter One (Intro to Database Management)

Odd Questions

1) Redundancy is the duplication of data. The problems associated with redundancy are:

A) Duplication of data causes waste of space.

B) This, in turn, cause a waste of time as duplicates require more space in memory and on disk and this takes longer to save and open.

C) Redundancy also makes changing data more cumbersome and time-consuming.

D) Lastly, redundancy can lead to inconsistencies. Such as misspelling a customer’s name.

3) An Entity is a person, place, object, event, or idea for which you store and process data. An Attribute is a characteristic of an entity.

5) A Database, by definition, is a structure that can store information about multiple types of entities, the attributes of those entities and the relationship between the entities.

7) In an E-R Diagram rectangles represent entities, and lines represent relationships between connected entities.

9) Database design is the process that determines the structure of the required database, usually by a database expert.

11) It’s possible to get more information from the same amount of data by using the database approach because the data of various users can be pooled together a shared among authorized users.

13) A DBA is a database administrator, the person in charge of the database.

15) An Integrity Constraint is a rule the data must follow in the database. A database has integrity when the data in it satisfies all established integrity restraints.

17) Data Independence is a property that lets you change the structure of the database without requiring you to change the programs that access the database. It is quite desirable because the structure of a database often needs to be changed.

19) There are four ways the complexity of a DBMS can be a disadvantage:

A) Larger file size

B) Increased...