Concepts of Database Design (7e), Ch. 1

An entity is also defined as an attribute.
Correct Answer: False

Employees using a database to enter data create the forms for the database.
Correct Answer: False

Sharing data is one advantage of database processing.
Correct Answer: True

Redundancy wastes space because you are storing different types of data in the same place.
Correct Answer: False

____ is the prevention of unauthorized access to the database.
Correct Answer: Security

A good ____ should provide an opportunity for users to incorporate integrity constraints when they design the database.
Correct Answer: DBMS

Each table in a database represents two or more entities.
Correct Answer: False

Popular ____ include Access, Oracle, DB2, MySQL, and SQL Server.
Correct Answer: DBMSs

A database can be password protected to prevent unauthorized users from accessing the data.
Correct Answer: True

____ are screen objects used to maintain, view, and print data from a database.
Correct Answer: Forms

The relationship between different entities (in different tables) is handled by their common columns.
Correct Answer: True

A(n) ____ is also called a field or column in many database systems.
Correct Answer: attribute

There is a greater impact of failure in a nondatabase, file-oriented system.
Correct Answer: False

A database has ____ if the data in it satisfies all established integrity constraints.
Correct Answer: integrity

An integrity constraint is a rule that ____.
Correct Answer: data must follow in the database

A database will not only hold information about multiple types of entities, but also information about the relationships among these multiple entities.
Correct Answer: True

A DBMS lets you assign users to ____.Answer
Correct Answer: groups

During the ____ process, a database expert determines the structure of the required database.
Correct Answer: database design

A visual way to represent a database is with a(n) ____.
Correct Answer: entity-relationship diagram

An attribute is a characteristic or property of an entity.
Correct Answer: True

The ____ of an entity become the columns in the database table.
Correct Answer: attributes

One disadvantage of a database system is ____.
Correct Answer: a larger file size

Redundancy makes changes more time-consuming since you must change the same information in a number of places.
Correct Answer: True

Storing the same data in more than one place is called ____.
Correct Answer: redundancy

An association between entities is known as a(n) ____.
Correct Answer: relationship

A(n) ____ is a person, place, object, event, or idea for which you want to store and process data.
Correct Answer: entity

____ is a property that lets you change the structure of the database without requiring you to change the programs that access the database.
Correct Answer: Data independence

An attribute is known as a row in most databases.
Correct Answer: False

Programs created with Visual Basic, Java, Perl, PHP, or C++ can access the database directly, rather than having to access it through the DBMS.
Correct Answer: False

Software packages, called database management systems, can do the job of manipulating databases for you.
Correct Answer: True

Which of the following statements is correct?
Correct Answer: In a nondatabase, file-oriented environment, data is often partitioned into several disjointed systems with each system having its own collection of files.

An advantage of using the database approach to processing is that it facilitates consistency.
Correct Answer: True

A(n) ____ is the computer counterpart to an ordinary paper file you might keep in a file cabinet or an accounting ledger.
Correct Answer: data file

A(n) ____ frees programmers who write database access programs from having to engage in mundane data manipulation activities, such as adding new data and deleting existing data.
Correct Answer: DBMS

A person who is in charge of a database within an organization is often called the database ____.
Correct Answer: administrator