DBMS Chapter 1

An attribute is known as a row in most databases.

False

An entity is also defined as an attribute.

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.​

False

There is a greater impact of failure in a nondatabase, file-oriented system.​

False

To create forms to use with a database you must write a program.​

False

​Each table in a database represents two or more entities.

False

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

True

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

True

When you need to change data, redundancy makes your changes more cumbersome and time-consuming.

True

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

data file

​____ is a property that lets you change the structure of the database without requiring you to change the programs that access the database.

data independence

An integrity constraint is a rule that ____.

data must follow in the database

During the ____ process, a database expert determines the structure of the required database.​

data security

​A group of people in charge of a database within an organization is often called the ____________________.

database admintration

A program, or collection of programs, through which users interact with a database is known as a(n) _________________________.​

database management system

In an E-R diagram, the ____________________ at the end of a line indicates the "many" part of the one-to-many relationship between two entities.

dot

Unlike a typical data file, a database can store information about multiple ____.

entities

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

entity

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

forms

A DBMS lets you assign users to ____.​

groups

A database has ____ if the data in it satisfies all established integrity constraints.​

intregity

In an E-R diagram, ____________________ represent relationships between connected entities.​

lines

A database file requires a large amount of disk space and internal ____________________.​

memory

In a(n) ____________________ relationship between two entities, each occurrence of the first entity is related to many occurrences of the second entity and each occurrence of the second entity is related to only one occurrence of the first entity.​

one-to-many

In an E-R diagram, ____________________ represent entities.​

rectangles

Eliminating ____________________ not only saves space but also makes the process of updating data much simpler.​

redundancy

The problem of inconsistency in data is a direct result of ____________________.​

redundancy

​Storing the same data in more than one place is called ____.

redundancy

____ is the prevention of unauthorized access to the database.​

security

Which of the following statements is correct?​

​In a nondatabase, file-oriented environment, data is often partitioned into several disjointed systems with each system having its own collection of files.

A visual way to represent a database is with a(n) ____.

​entity-relationship diagram

​A(n) ____ is also called a field or column in many database systems.

attribute

Sharing data is one advantage of database processing.​

True

Popular ____ include Access, Oracle, DB2, MySQL, and SQL Server.​

DBMSs

A good ____ should provide an opportunity for users to incorporate integrity constraints when they design the database.​

DBMS

A good _________________________ has many features that allow users to gain access to data in a database without having to do any programming.​

DBMS

​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.

DBMS

A DBA can assign passwords to prevent unauthorized users from accessing the data.​

True

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

True

An advantage of using the database approach to processing is that it facilitates consistency.​

True

An attribute is a characteristic or property of an entity.

True

Redundancy wastes space because you are storing different types of data in the same place.​

True

The ____ of an entity become the columns in the database table.​

attribute

One disadvantage of a database system is ____.​

a larger file size

A person who is in charge of a database within an organization is often called the database ____.​

administrator