INFO 3233 TEST QUESTIONS AND VERIFIED
ANSWERS
A(n) ________'s main function is to help one understand the complexities of the real-
world environment
A.) Database
B.) Model
C.) Entity
D.) Node - Answers - B.) Model
Which of the following is true of business rules?
A.) They provide a framework for the company's self-actualization
B.) They allow the designer to develop business processes
C.) They can serve as a communication tool between the users and designers
D.) They allow the designer to set company policies with regard to data - Answers - C.)
They can serve as a communication tool between the users and designers
A noun in a business rules translates to a(n) ______ in the data model
A.) Entity
B.) Constraint
C.) Attribute
D.) Relationship - Answers - A.) Entity
A _______ is the primary key of one table that has been placed into another table to
create attribute
A.) Foreign Key
B.) Candidate Key
C.) Super Key
D.) Composite Primary Key - Answers - A.) Foreign Key
The _______ relationship is the "relational model ideal."
A.) 1:2
B.) 1:M
C.) 1:1
D.) M:N - Answers - B.) 1:M
_______ expresses the minimum and maximum number of entity occurrences
associated with one occurrence of the related entity.
, A.) Connectivity
B.) Dependance
C.) Cardinality
D.) Relationship - Answers - C.) Cardinality
An entity is said to be _____-dependent if it can exist in the database only when it is
associated with another related entity occurrence.
A.) Data
B.) Existence
C.) Business
D.) Relationship - Answers - B.) Existence
Database design is a(n) _______ process based on repetition
A.) Linear
B.) Iterative
C.) Intermittent
D.) Sequential - Answers - B.) Iterative
The first step in building an entity-relationship diagram (ERD) is ______
A.) Creating a detailed narrative of the organization's description of operations
B.) Developing the initial ERD
C.) Identifying the attributes and primary keys that adequately describe the entities
D.)Identifying the business rules based on the description of operations - Answers - A.)
Creating a detailed narrative of the organizations description of operations
A domain is the ______ set of possible values
A.) Entity instance's
B.) Entity's
C.)Attribute's
D.) Company's - Answers - C.) Attribute's
If the total cost of an order is determined by multiplying the quantity ordered by the unit
price attribute is said to be a _______ attribute
A.) Figured
B.) Multi-Valued
C.) Composite
D.) Derived - Answers - D.) Derived
A recursive relationship is a ________ relationship
ANSWERS
A(n) ________'s main function is to help one understand the complexities of the real-
world environment
A.) Database
B.) Model
C.) Entity
D.) Node - Answers - B.) Model
Which of the following is true of business rules?
A.) They provide a framework for the company's self-actualization
B.) They allow the designer to develop business processes
C.) They can serve as a communication tool between the users and designers
D.) They allow the designer to set company policies with regard to data - Answers - C.)
They can serve as a communication tool between the users and designers
A noun in a business rules translates to a(n) ______ in the data model
A.) Entity
B.) Constraint
C.) Attribute
D.) Relationship - Answers - A.) Entity
A _______ is the primary key of one table that has been placed into another table to
create attribute
A.) Foreign Key
B.) Candidate Key
C.) Super Key
D.) Composite Primary Key - Answers - A.) Foreign Key
The _______ relationship is the "relational model ideal."
A.) 1:2
B.) 1:M
C.) 1:1
D.) M:N - Answers - B.) 1:M
_______ expresses the minimum and maximum number of entity occurrences
associated with one occurrence of the related entity.
, A.) Connectivity
B.) Dependance
C.) Cardinality
D.) Relationship - Answers - C.) Cardinality
An entity is said to be _____-dependent if it can exist in the database only when it is
associated with another related entity occurrence.
A.) Data
B.) Existence
C.) Business
D.) Relationship - Answers - B.) Existence
Database design is a(n) _______ process based on repetition
A.) Linear
B.) Iterative
C.) Intermittent
D.) Sequential - Answers - B.) Iterative
The first step in building an entity-relationship diagram (ERD) is ______
A.) Creating a detailed narrative of the organization's description of operations
B.) Developing the initial ERD
C.) Identifying the attributes and primary keys that adequately describe the entities
D.)Identifying the business rules based on the description of operations - Answers - A.)
Creating a detailed narrative of the organizations description of operations
A domain is the ______ set of possible values
A.) Entity instance's
B.) Entity's
C.)Attribute's
D.) Company's - Answers - C.) Attribute's
If the total cost of an order is determined by multiplying the quantity ordered by the unit
price attribute is said to be a _______ attribute
A.) Figured
B.) Multi-Valued
C.) Composite
D.) Derived - Answers - D.) Derived
A recursive relationship is a ________ relationship
