Database - EERD

These are specialized ER Diagrams that can be extremely useful for modelling database. It has supertype/subtype relationships.

• Enhanced entity-relationship diagrams

• Entity-relationship diagrams

The most important modeling construct incorporated in the EER model is ____________ relationships.

• supertype/subtype

• inheritance

• generalization/specialization

• one to many

The _____________ allow us to capture some of the important business rules that apply to these super class and sub class relationships.

• constraints

• supertype/subtype

• generalization/specialization

• inheritance

This is a process of defining a more general entity type from a set of more specialized entity types

• Generalization

• Specialization

• Super class

• Sub class

The EER diagram provides you with all the elements of an ER diagram while adding which of the following (choose more than one answer)

• Attribute or relationship inheritances

• Category or union types

• Specialization and Generalization

• Subclasses and Superclass

Generalization is a ________________ process.

• bottom-up

• top-down

Specialization is a ________________ process.

• bottom-up

• top-down

The process of defining one or more subtypes of the supertype and forming supertype/subtype relationships

• Generalization

• Specialization

• Super class

• Sub class

This is a generic entity type that has a relationship with one or more subtypes.

• Generalization

• Specialization

• Super class

• Sub class

This is a group of entities with unique attributes. It inherits all the attributes from its super class

• Generalization

• Specialization

• Super class

• Sub class