WorksheetsINFORMATION MANAGEMENT PREFINALS
Total questions: 45
Worksheet time: 30mins
IDENTIFY THE CORRECT MODELING CONCEPT BEING DESCRIBED OR DEMONSTRATED.
WRITE THE ABBREVIATION ONLY:
Aggregation: AGG Generalization: GEN Inheritance: IN Specialization: SPEC
Treating a relationship as a higher-level entity.
(a)
IDENTIFY THE CORRECT MODELING CONCEPT BEING DESCRIBED OR DEMONSTRATED.
WRITE THE ABBREVIATION ONLY:
Aggregation: AGG Generalization: GEN Inheritance: IN Specialization: SPEC
Subclasses automatically acquiring superclass attributes.
(a)
IDENTIFY THE CORRECT MODELING CONCEPT BEING DESCRIBED OR DEMONSTRATED.
WRITE THE ABBREVIATION ONLY:
Aggregation: AGG Generalization: GEN Inheritance: IN Specialization: SPEC
Creating specific classes from a general class.
(a)
IDENTIFY THE CORRECT MODELING CONCEPT BEING DESCRIBED OR DEMONSTRATED.
WRITE THE ABBREVIATION ONLY:
Aggregation: AGG Generalization: GEN Inheritance: IN Specialization: SPEC
Dividing entity into sub-entities based on characteristics.
(a)
IDENTIFY THE CORRECT MODELING CONCEPT BEING DESCRIBED OR DEMONSTRATED.
WRITE THE ABBREVIATION ONLY:
Aggregation: AGG Generalization: GEN Inheritance: IN Specialization: SPEC
"Has-a" relationship where parts can exist independently.
(a)
IDENTIFY THE CORRECT MODELING CONCEPT BEING DESCRIBED OR DEMONSTRATED.
WRITE THE ABBREVIATION ONLY:
Aggregation: AGG Generalization: GEN Inheritance: IN Specialization: SPEC
Subclass getting all methods and fields from superclass.
(a)
IDENTIFY THE CORRECT MODELING CONCEPT BEING DESCRIBED OR DEMONSTRATED.
WRITE THE ABBREVIATION ONLY:
Aggregation: AGG Generalization: GEN Inheritance: IN Specialization: SPEC
Grouping relationship into a unit to connect with another entity.
(a)
IDENTIFY THE CORRECT MODELING CONCEPT BEING DESCRIBED OR DEMONSTRATED.
WRITE THE ABBREVIATION ONLY:
Aggregation: AGG Generalization: GEN Inheritance: IN Specialization: SPEC
Extracting common properties to create generalized entity.
(a)
IDENTIFY THE CORRECT MODELING CONCEPT BEING DESCRIBED OR DEMONSTRATED.
WRITE THE ABBREVIATION ONLY:
Aggregation: AGG Generalization: GEN Inheritance: IN Specialization: SPEC
Creating specific shapes from general GeometricShape.
(a)
IDENTIFY THE CORRECT MODELING CONCEPT BEING DESCRIBED OR DEMONSTRATED.
WRITE THE ABBREVIATION ONLY:
Aggregation: AGG Generalization: GEN Inheritance: IN Specialization: SPEC
Components can belong to different systems.
(a)
IDENTIFY THE CORRECT MODELING CONCEPT BEING DESCRIBED OR DEMONSTRATED.
WRITE THE ABBREVIATION ONLY:
Aggregation: AGG Generalization: GEN Inheritance: IN Specialization: SPEC
Subclass using methods from superclass.
(a)
IDENTIFY THE CORRECT MODELING CONCEPT BEING DESCRIBED OR DEMONSTRATED.
WRITE THE ABBREVIATION ONLY:
Aggregation: AGG Generalization: GEN Inheritance: IN Specialization: SPEC
Sub-entities reusing parent properties.
(a)
IDENTIFY THE CORRECT MODELING CONCEPT BEING DESCRIBED OR DEMONSTRATED.
WRITE THE ABBREVIATION ONLY:
Aggregation: AGG Generalization: GEN Inheritance: IN Specialization: SPEC
Creating distinct employee categories from general Employee.
(a)
IDENTIFY THE CORRECT MODELING CONCEPT BEING DESCRIBED OR DEMONSTRATED.
WRITE THE ABBREVIATION ONLY:
Aggregation: AGG Generalization: GEN Inheritance: IN Specialization: SPEC
Departments as constituent parts of company.
(a)
IDENTIFY THE CORRECT MODELING CONCEPT BEING DESCRIBED OR DEMONSTRATED.
WRITE THE ABBREVIATION ONLY:
Aggregation: AGG Generalization: GEN Inheritance: IN Specialization: SPEC
Bottom-up process of extracting common features.
(a)
IDENTIFY THE CORRECT MODELING CONCEPT BEING DESCRIBED OR DEMONSTRATED.
WRITE THE ABBREVIATION ONLY:
Aggregation: AGG Generalization: GEN Inheritance: IN Specialization: SPEC
Relationship participating in another relationship.
(a)
IDENTIFY THE CORRECT MODELING CONCEPT BEING DESCRIBED OR DEMONSTRATED.
WRITE THE ABBREVIATION ONLY:
Aggregation: AGG Generalization: GEN Inheritance: IN Specialization: SPEC
Class inheriting properties and adding specific ones.
(a)
IDENTIFY THE CORRECT MODELING CONCEPT BEING DESCRIBED OR DEMONSTRATED.
WRITE THE ABBREVIATION ONLY:
Aggregation: AGG Generalization: GEN Inheritance: IN Specialization: SPEC
Treating relationship as an entity for other associations.
(a)
IDENTIFY THE CORRECT MODELING CONCEPT BEING DESCRIBED OR DEMONSTRATED.
WRITE THE ABBREVIATION ONLY:
Aggregation: AGG Generalization: GEN Inheritance: IN Specialization: SPEC
Creating category with additional attributes.
(a)
IDENTIFY THE CORRECT MODELING CONCEPT BEING DESCRIBED OR DEMONSTRATED.
WRITE THE ABBREVIATION ONLY:
Aggregation: AGG Generalization: GEN Inheritance: IN Specialization: SPEC
"Has-a" relationship with independent existence.
(a)
IDENTIFY THE CORRECT MODELING CONCEPT BEING DESCRIBED OR DEMONSTRATED.
WRITE THE ABBREVIATION ONLY:
Aggregation: AGG Generalization: GEN Inheritance: IN Specialization: SPEC
Specifying numerical relationship between entities.
(a)
IDENTIFY THE CORRECT MODELING CONCEPT BEING DESCRIBED OR DEMONSTRATED.
WRITE THE ABBREVIATION ONLY:
Aggregation: AGG Generalization: GEN Inheritance: IN Specialization: SPEC
Subclasses overriding parent class method.
(a)
IDENTIFY THE CORRECT MODELING CONCEPT BEING DESCRIBED OR DEMONSTRATED.
WRITE THE ABBREVIATION ONLY:
Aggregation: AGG Generalization: GEN Inheritance: IN Specialization: SPEC
Combining common attributes into single table.
(a)
IDENTIFY THE CORRECT MODELING CONCEPT BEING DESCRIBED OR DEMONSTRATED.
WRITE THE ABBREVIATION ONLY:
Aggregation: AGG Generalization: GEN Inheritance: IN Specialization: SPEC
Products can exist independently of carts.
(a)
IDENTIFY THE CORRECT MODELING CONCEPT BEING DESCRIBED OR DEMONSTRATED.
WRITE THE ABBREVIATION ONLY:
Aggregation: AGG Generalization: GEN Inheritance: IN Specialization: SPEC
Subclasses using parent method without modification.
(a)
IDENTIFY THE CORRECT MODELING CONCEPT BEING DESCRIBED OR DEMONSTRATED.
WRITE THE ABBREVIATION ONLY:
Aggregation: AGG Generalization: GEN Inheritance: IN Specialization: SPEC
Dividing staff based on specific roles.
(a)
IDENTIFY THE CORRECT MODELING CONCEPT BEING DESCRIBED OR DEMONSTRATED.
WRITE THE ABBREVIATION ONLY:
Aggregation: AGG Generalization: GEN Inheritance: IN Specialization: SPEC
Weak entity with strong "part-of" relationship.
(a)
IDENTIFY THE CORRECT MODELING CONCEPT BEING DESCRIBED OR DEMONSTRATED.
WRITE THE ABBREVIATION ONLY:
Aggregation: AGG Generalization: GEN Inheritance: IN Specialization: SPEC
Creating hierarchy with shared common attributes.
(a)
IDENTIFY THE CORRECT MODELING CONCEPT BEING DESCRIBED OR DEMONSTRATED.
WRITE THE ABBREVIATION ONLY:
Aggregation: AGG Generalization: GEN Inheritance: IN Specialization: SPEC
Subclass adding specific attributes to inherited ones.
(a)
IDENTIFY THE CORRECT MODELING CONCEPT BEING DESCRIBED OR DEMONSTRATED.
WRITE THE ABBREVIATION ONLY:
Aggregation: AGG Generalization: GEN Inheritance: IN Specialization: SPEC
Using parent class methods without redefinition.
(a)
Analyze the Identify the correct cardinality for the relationship in both directions.
1:1 1:N N:1 M:N
Country : Capital City
(a)
Analyze the Identify the correct cardinality for the relationship in both directions.
1:1 1:N N:1 M:N
Customer : Order
(a)
Analyze the Identify the correct cardinality for the relationship in both directions.
1:1 1:N N:1 M:N
Student : Course
(a)
Analyze the Identify the correct cardinality for the relationship in both directions.
1:1 1:N N:1 M:N
Employee : Department (as manager)
(a)
Analyze the Identify the correct cardinality for the relationship in both directions.
1:1 1:N N:1 M:N
Author : Book
(a)
Analyze the Identify the correct cardinality for the relationship in both directions.
1:1 1:N N:1 M:N
Hospital Room : Patient
(a)
Analyze the Identify the correct cardinality for the relationship in both directions.
1:1 1:N N:1 M:N
Supplier : Product
(a)
Analyze the Identify the correct cardinality for the relationship in both directions.
1:1 1:N N:1 M:N
Shopping Cart : Product
(a)
Analyze the Identify the correct cardinality for the relationship in both directions.
1:1 1:N N:1 M:N
Teacher : Class
(a)
Analyze the Identify the correct cardinality for the relationship in both directions.
1:1 1:N N:1 M:N
Customer : Bank Account
(a)
Analyze the Identify the correct cardinality for the relationship in both directions.
1:1 1:N N:1 M:N
Car : Engine
(a)
Analyze the Identify the correct cardinality for the relationship in both directions.
1:1 1:N N:1 M:N
Team : Player
(a)
Analyze the Identify the correct cardinality for the relationship in both directions.
1:1 1:N N:1 M:N
Employee : Project
(a)
Analyze the Identify the correct cardinality for the relationship in both directions.
1:1 1:N N:1 M:N
Movie:Actor
(a)
Analyze the Identify the correct cardinality for the relationship in both directions.
1:1 1:N N:1 M:N
Social Media User:Message
(a)
