True/False
Indicate whether the sentence or statement is true
or false.
|
|
|
1.
|
Redundancy wastes space because you are storing different types of data in the same
place.
|
|
|
2.
|
Redundancy makes changes more time-consuming since you must change the same
information in a number of places.
|
|
|
3.
|
Spreadsheet software is the best way to store business information, for example
orders, customers, and sales people.
|
|
|
4.
|
An
entity is also defined as an attribute.
|
|
|
5.
|
A
person, place, or object is also known as an entity.
|
|
|
6.
|
An
attribute is a characteristic or property of an entity.
|
|
|
7.
|
An
attribute is also known as a row in most databases.
|
|
|
8.
|
An
association between entities is known as a relationship.
|
|
|
9.
|
A
database will not only hold multiple entities, but also information about the relationships between
these multiple entities.
|
|
|
10.
|
If
one entity is associated with many other entities, then the relationship is considered a one-to-many
relationship.
|
|
|
11.
|
Each
table in a database represents two or more entities.
|
|
|
12.
|
The
relationship between different entities (in different tables) is handled by their common
columns.
|
|
|
13.
|
A
DBMS is a complex spreadsheet program.
|
|
|
14.
|
A
collection of programs that allows users to interact with a database is called a DBMS.
|
|
|
15.
|
Users
can only interact with a database directly; no other programming languages are allowed.
|
|
|
16.
|
Popular DBMSs include Access, Oracle, DB2, and SQL Server.
|
|
|
17.
|
The
term database design refers to the inserting of information into the database for use.
|
|
|
18.
|
A
switchboard system refers to the process of ordering products from the database using a digital
telephone system.
|
|
|
19.
|
Sharing data is one advantage to database processing.
|
|
|
20.
|
An
advantage to database processing is facilitating redundancy.
|
|
|
21.
|
Sharing data means that data is combined data so that all users, both
authorized and unauthorized, can have access to a greater pool of data.
|
|
|
22.
|
The
database administrator, or DBA, can balance conflicting requirements by making sure that the database
benefits the whole organization rather than a single person or group.
|
|
|
23.
|
All
redundancy within a database can and should always be eliminated.
|
|
|
24.
|
An
advantage of using a relational database is to facilitate consistency.
|
|
|
25.
|
Integrity constraints limit the number of entities that can be placed in a table or
database.
|
|
|
26.
|
A
database can be password protected to prevent unauthorized users from accessing the
data.
|
|
|
27.
|
One
disadvantage of a database system would be larger file size.
|
|
|
28.
|
There
is a greater impact of failure in a nondatabase, file-oriented system.
|
Modified True/False
Indicate
whether the sentence or statement is true or false. If false, change the identified word or
phrase to make the sentence or statement true.
|
|
|
29.
|
The
duplication of data is a problem called consistency.
|
|
|
30.
|
Redundancy wastes space because the same data is stored in multiple places.
|
|
|
31.
|
Spreadsheets have limited security features that protect the data from
unauthorized users.
|
|
|
32.
|
A
database structure contains information about categories of information and the structure
between the categories.
|
|
|
33.
|
A
person, place, or event is also known as a(n) entity.
|
|
|
34.
|
A
characteristic or property of an entity is also known as a(n) relationship.
|
|
|
35.
|
Another name for a field or column is a(n) attribute.
|
|
|
36.
|
A
relationship is also known as the association between entities.
|
|
|
37.
|
A
relationship is handled by using common columns.
|
|
|
38.
|
In
some database systems, the word "Sort" has a special purpose.
|
|
|
39.
|
Some
popular DBMSs include Access, Oracle, SQL Server, and Java.
|
|
|
40.
|
Determining the structure of a database is called the database design.
|
|
|
41.
|
Screens are objects which are used to maintain, view, and print data from a
database.
|