ICT3621 DATABASE DESIGN ASSIGNMENT 1
Composite and Simple Attributes
1. is key attribute that can be further subdivided
to yield additional attributes.
The correct answer is:
[Composite and Simple Attributes] is key attribute that can be further
subdivided to yield additional attributes.
2. One or more attributes that determine other attributes.
a. Key
b. Superkey
c. Primary key
d. Composite key
The correct answer is:
Key
Unary relationship
3. is the association is maintained within a single entity.
The correct answer is:
[Unary relationship] is the association is maintained within a single entity.
Ternary relationship
4. exists when three entities are associated.
The correct answer is:
[Ternary relationship] exists when three entities are associated.
Optional participation
5. is one entity occurrence does not require a
corresponding entity occurrence in a particular relationship.
The correct answer is:
[Optional participation] is one entity occurrence does not require a corresponding
entity occurrence in a particular relationship.
6. It indicates the number of entities or participants associated with a relationship.
a. Urinary relationship
b. Relationship degree
c. Binary relationship
d. Ternary relationship
, The correct answer is:
Relationship degree
7. What is information?
a. Raw facts that have not been processed to reveal any meaning to the
primary user.
b. The result of processing raw data to reveal its meaning.
c. Information consists of transformed data and facilitates decision making.
d. The result of processing raw data to reveal its meaning. Information
consists of transformed data and facilitates decision making.
The correct answer is:
The result of processing raw data to reveal its meaning. Information consists of
transformed data and facilitates decision making.
optional attribute
8. An is an attribute that does not require a value. This
attribute can be left empty or have null value.
The correct answer is:
An [optional attribute] is an attribute that does not require a value. This attribute
can be left empty or have null value.
Identifiers
9. one or more attributes that uniquely identify each entity
instance.
The correct answer is:
[Identifiers] one or more attributes that uniquely identify each entity instance.
10. What is query result set?
a. A condition in which different versions of the same data yield different results.
b. The collection of data rows returned by a query.
c. A task asked by the end user of a database in the form of SQL code. A
specific request for data manipulation issued by the end user or the application of
the DBMS.
d. A "spur-of-moment" question
The correct answer is:
The collection of data rows returned by a query.
11. What is data management?
Composite and Simple Attributes
1. is key attribute that can be further subdivided
to yield additional attributes.
The correct answer is:
[Composite and Simple Attributes] is key attribute that can be further
subdivided to yield additional attributes.
2. One or more attributes that determine other attributes.
a. Key
b. Superkey
c. Primary key
d. Composite key
The correct answer is:
Key
Unary relationship
3. is the association is maintained within a single entity.
The correct answer is:
[Unary relationship] is the association is maintained within a single entity.
Ternary relationship
4. exists when three entities are associated.
The correct answer is:
[Ternary relationship] exists when three entities are associated.
Optional participation
5. is one entity occurrence does not require a
corresponding entity occurrence in a particular relationship.
The correct answer is:
[Optional participation] is one entity occurrence does not require a corresponding
entity occurrence in a particular relationship.
6. It indicates the number of entities or participants associated with a relationship.
a. Urinary relationship
b. Relationship degree
c. Binary relationship
d. Ternary relationship
, The correct answer is:
Relationship degree
7. What is information?
a. Raw facts that have not been processed to reveal any meaning to the
primary user.
b. The result of processing raw data to reveal its meaning.
c. Information consists of transformed data and facilitates decision making.
d. The result of processing raw data to reveal its meaning. Information
consists of transformed data and facilitates decision making.
The correct answer is:
The result of processing raw data to reveal its meaning. Information consists of
transformed data and facilitates decision making.
optional attribute
8. An is an attribute that does not require a value. This
attribute can be left empty or have null value.
The correct answer is:
An [optional attribute] is an attribute that does not require a value. This attribute
can be left empty or have null value.
Identifiers
9. one or more attributes that uniquely identify each entity
instance.
The correct answer is:
[Identifiers] one or more attributes that uniquely identify each entity instance.
10. What is query result set?
a. A condition in which different versions of the same data yield different results.
b. The collection of data rows returned by a query.
c. A task asked by the end user of a database in the form of SQL code. A
specific request for data manipulation issued by the end user or the application of
the DBMS.
d. A "spur-of-moment" question
The correct answer is:
The collection of data rows returned by a query.
11. What is data management?
