True/False
Indicate whether the
statement is true or false.
|
|
|
1.
|
An entity in an accounting system can be classified as a resource, event or
agent about which data are collected.
|
|
|
2.
|
Attributes are often called fields.
|
|
|
3.
|
A model is a complex representation of a simple entity or phenomenon.
|
|
|
4.
|
A primary attribute is the attribute whose value is unique for every entity that
will appear in the database.
|
|
|
5.
|
The customer street address is often used as the key attribute in an REA
diagram.
|
|
|
6.
|
Relationships map and define the way in which data can be extracted from a
database.
|
|
|
7.
|
Representing supervisors and their employees as separate entities in the model
can lead to data redundancy.
|
|
|
8.
|
A recursive relationship is created when there is an employee being supervised,
and another employee is the supervisor.
|
|
|
9.
|
The cardinality constraint is used less frequently than the participation
constraint.
|
|
|
10.
|
The cardinality constraint is used to specify both the minimum and maximum
participation of one entity in the relationship with the other entity.
|
|
|
11.
|
The fundamental requirement for moving toward an event driven model is the
complete integration of data related to an organization’s business events.
|
|
|
12.
|
A legacy system is one that has existed in an organization for less than one
year.
|
|
|
13.
|
A collection of data representing multiple occurrences of a resource, event, or
agent is known as a relation.
|
|
|
14.
|
A set of data that describes an instance of the entity represented by a relation
is known as a tuple.
|
|
|
15.
|
A missing value is called a non-null.
|
|
|
16.
|
The secondary key is specified to uniquely identity each tuple in the
relation.
|
|
|
17.
|
Relational integrity specifies that for every attribute in one relation that has
been specified to allow reference to another relation, the tuple being referenced must remain
intact.
|
|
|
18.
|
Most DBMS available today that include SQL also include mechanisms within the
DBMS itself for establishing and enforcing referential integrity.
|
|
|
19.
|
The INSERT command is used to add a single tuple to an existing relation.
|
|
|
20.
|
The UPDATE command demonstrates one of the weaknesses in most forms of
SQL.
|
|
|
21.
|
The DELETE command is used when we want to change one or more attribute
values.
|
|
|
22.
|
Queries of a database are driven by SELECT commands.
|
Multiple Choice
Identify the
choice that best completes the statement or answers the question.
|
|
|
23.
|
An entity can be classified as all of the following except
a. | resource | c. | tuple | b. | event | d. | agent |
|
|
|
24.
|
A(n) ____ of an entity is on specific thing of the type defined by the
entity.
a. | agent | c. | attribute | b. | composite attribute | d. | instance |
|
|
|
25.
|
A(n) ____ is an item of data that characterizes an entity or relationship
a. | agent | c. | attribute | b. | composite attribute | d. | instance |
|
|
|
26.
|
Which of the following is the entity or agent?
a. | client | c. | client name | b. | client number | d. | client street
address |
|
|
|
27.
|
Which of the following is the key attribute?
a. | client | c. | client name | b. | client number | d. | client street
address |
|
|
|
28.
|
Which of the following is an attribute but least likely to be the key
attribute?
a. | client | c. | client name | b. | client number | d. | client street
address |
|
|
|
29.
|
Which of the following is a composite attribute?
a. | client | c. | client name | b. | client number | d. | client street
address |
|
|
|
30.
|
A data field in a traditional file is similar to a relational:
a. | table | c. | tuple | b. | attribute | d. | row |
|
|
|
31.
|
A key attribute is the attribute whose value is:
a. | undeterminable | c. | large | b. | unique | d. | the same for all
attributes |
|
|
|
32.
|
Which of the following is not a relationship type?
a. | one-to-many | c. | one-to-few | b. | one-to-one | d. | many-to-many |
|
|
|
33.
|
Which relationship type does (1, N) mean?
a. | one-to-many | c. | one-to-few | b. | one-to-one | d. | many-to-many |
|
|
|
34.
|
The cardinality constraint:
a. | specifies the degree of minimum participation of one entity in the relationship with
the other entity. | b. | provides more information than the
participation constraint. | c. | is the most common constraint specified in E-R
diagrams. | d. | all of the above. |
|
|
|
35.
|
A set of data that describes an instance of the entity represented by a relation
is known as a(n) ____.
a. | tuple | c. | agent | b. | resource | d. | event |
|
|
|
36.
|
Legacy systems do not usually have which of the following
characteristics?
a. | developed on previous hardware (and/or software) platforms | b. | are easily adaptable
to enterprise systems | c. | have been used by an organization for a long
period of time | d. | all of the above are typical characteristics of legacy
systems |
|
|
|
37.
|
____ specifies that for every attribute value in one relation that has been
specified in order to allow reference to another relation,the tuple being referenced must remain
intact.
a. | Cardinality constraint | c. | Referential integrity | b. | Participation
constraint | d. | Economic
constraint |
|
|
|
38.
|
Which of the following relational commands would a manager use to combine the
data from two related relations into a third relation?
a. | select | c. | join | b. | project | d. | display |
|
|
|
39.
|
Which of the following is a valid SQL command?
a. | MODIFY | c. | ADD | b. | INSERT | d. | APPEND |
|
|
|
40.
|
The SELECT statement has all but one of the following parts
a. | a list of attributes that we wish to SELECT from the database | b. | a WHEN
clause | c. | a list of tables where these attributes can be found | d. | a WHERE
clause |
|
|
|
41.
|
Which of the following SQL statements would extract the employee number and date
for every instance that had a billing rate of $150?
a. | SELECT Employee_No,
Date
FROM
BILLING_HOURS
WHERE Rate=150 | b. | QUERY Employee_No,
Date
FROM
BILLING_HOURS
WHERE Rate=150 | c. | SELECT Employee_No,
Date
WHERE Rate=150 | d. | QUERY
BILLING_HOURS
SELECT Employee_No,
Date
WHERE Hours>8 |
|
|
|
42.
|
Which of the following SQL statements would extract the client number and date
for every instance that had a billing rate of $150?
a. | QUERY
BILLING_HOURS
SELECT Client_No,
Date
WHERE Rate=150 | b. | QUERY client_No,
Date
FROM
BILLING_HOURS
WHERE Rate=150 | c. | SELECT Client_No,
Date
WHERE Rate=150 | d. | SELECT Client_No,
Date
FROM
BILLING_HOURS
WHERE
Rate=150 |
|
Completion
Complete each
statement.
|
|
|
43.
|
A(n) _________________________ is the attribute whose value is unique for every
entity that will ever appear in the database.
|
|
|
44.
|
____________________ map and define the way in which data can be extracted from
a database.
|
|
|
45.
|
A(n) ______________________________ relationship occurs between two different
instances of an entity.
|
|
|
46.
|
REA stands for ____________________, ____________________, and
____________________.
|
|
|
47.
|
The _________________________ is specified to uniquely identity each tuple in
the relation.
|
|
|
48.
|
___________________________________ specifies that for every attribute value in
one relation that has been specified to allow reference to another relation, the tuple being
referenced must be intact.
|
|
|
49.
|
____________________ is a powerful database language that can be used to define
database systems, query the database for information, generate reports from the database, and access
databases from within programs using embedded commands.
|
|
|
50.
|
The ____________________ command is used to add new tuples to a relation.
|