Database Management Ch 1

Which of the following defines a DBMS?

A program through which users interact with the data stored in a database

Which of the following allows you to get more information from the same amount of data?

Creating a healthy relational database

Which of the following describes database design?

Creating the entities, attributes, and relationships between tables of data

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

Data redundancy

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

Prevents orphan records

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

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

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

attribute

A(n) _____ is the person in charge of an organization's database.

database administrator (DBA)

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

entity

In a(n) _____, rectangles represent entities and display their attributes; lines represent relationships between connected entities.

entity-relationship (E-R) diagram

A(n) _____ exists between two entities when each row in the first entity matches many rows in the second entity, and each row in the second entity matches only one row in the first entity.

one-to-many relationship

A(n) _____ is a structure that contains data about many categories of information as well as the relationships between those categories.

relational database