1. Which is NOT a factor that increases difficulty of design for a larger project?
a. Staff turnover and retraining
b. Need to divide work projects into pieces for team
c. Lack of ability for CASE tools to handle large projects
d. Communication with multiple users
e. Finding the data / components
2. Many-to-many associations:
a. Can be represented directly in class diagram details
b. Simplify relational database design
c. Are converted into set of one-to-may associations
d. Do not represent any recognizable business rules
e. Are not considered in creating a database design
3. A composition association is one that:
a. Is the same as a aggregation association
b. Can exist in a many-to-many relationship
c. Has individual items that are distinguishable from the resulting object.
d. Exists only when the individual items become the new class.
e. all of the above
4. Missing data in a database property is referred to as a:
a. indeterminant value
b. null
c. zero
d. blank
e. default value
5. Class inheritance is a property of class relationships that mean:
a. That other classes are derived from base classes
b. That derived classes share properties unique to each derived class (intersect)
c. That derived classes contain the properties and methods of the base class and add
new features.
d. A and b above
e. A and c above
6. A reflexive association is one in which:
a. Data in one class reflects that of another
b. One class forms a relationship back to itself
c. One class is a parent of another
d. One class is only in a 1:1 relationship with another
e. Should not be included in the database design
7. When interviewing a user to gather information for a database design which is the least
important information to gather?
a. The physical location of existing data
b. Identification of the data that needs to be collected
c. The data type (domain)
d. The amount of data involved
e. All of the above are important
8. A _________ is a function performed by a class:
a. Method
b. Operation
c. Application
d. Property
e. Business Rule
9. A __________ is a characteristic or descriptor of a class or entity.
a. Method
b. Operation
c. Application
d. Property
e. Business Rule
10. Basic type of events that can occur in a database environment include:
a. Business events that trigger some function
b. Data changes that signal some alert
c. User interface events that trigger some action
d. A and c above
e. All of the above
11. One instance of a class with specific data is referred to as:
a. An object
b. A property
c. A method
d. A value
e. A key
12. The description of the type of data, its composition, and size is referred to as the property's:
a. Data structure
b. Descriptor
c. Multiplicity
d. Domain
e. Class