The Modeling Data in the Organization and the Enhanced ER Model
🇬🇧
In Inglés
In Inglés
Practique preguntas conocidas
Manténgase al día con sus preguntas pendientes
Completa 5 preguntas para habilitar la práctica
Exámenes
Examen: pon a prueba tus habilidades
Pon a prueba tus habilidades en el modo de examen
Aprenda nuevas preguntas
Modos dinámicos
InteligenteMezcla inteligente de todos los modos
PersonalizadoUtilice la configuración para ponderar los modos dinámicos
Modo manual [beta]
Seleccione sus propios tipos de preguntas y respuestas
Modos específicos
Aprende con fichas
Completa la oración
Escuchar y deletrearOrtografía: escribe lo que escuchas
elección múltipleModo de elección múltiple
Expresión oralResponde con voz
Expresión oral y comprensión auditivaPractica la pronunciación
EscrituraModo de solo escritura
The Modeling Data in the Organization and the Enhanced ER Model - Marcador
The Modeling Data in the Organization and the Enhanced ER Model - Detalles
Niveles:
Preguntas:
57 preguntas
| 🇬🇧 | 🇬🇧 |
| This is a detailed, logical representation of the data for an organization or for a business area. | Entity-relationship model |
| This is the graphical representation of an entity-relationship model or ER model. | Entity-relationship diagram |
| These are properties of an entity. | Attributes |
| This is an entity type that associates the instances of one or more entity types and contains attributes that are peculiar to the relationship between those entity instances. | Associative entities |
| This is a meaningful association between (or among) entity types. | Relationship type |
| This is an association between (or among) entity instances where each [BLANK] associates exactly one entity instance from each participating relationship type. | Relationship instance |
| These are crucial to data modeling and providing names and definitions for entity types, attributes, and relationships. | Business rules |
| These are intended to assert business structure or to control or influence the behavior of the business. | Business rules |
| This is a high level model that represents the requirements and complexities of a complex database. | Enhanced entity-relationship model |
| What are the two concepts of EER model? | Generalization Specialization |
| This is the process of defining a more general entity type from a set of more specialized entity types. | Generalization |
| This is the process of defining one or more subtypes of the supertype and forming supertype/subtype relationships. | Specialization |
| These constraints allow you to capture some of the important business rules that apply to these relationships. | Specifying constraints |
| These are the two most important type of constraints that are described. | Completeness constaints Disjointness constraints |
| This is a type of constraint that addresses whether an instance of a supertype must also be a member of at least one subtype. | Completeness constraints |
| These are the two possible rules of the completeness constraints. | Total specialization rule Partial specialization rule |
| This rule specifies that each entity instance of a supertype must be a member of some subtype in the relationship. | Total specialization rule |
| This rule specifies that an entity instance of a supertype is allowed not to belong to any subtype. | Partial specialization rule |
| These constraints addresses whether an instance of a supertype may simultaneously be a member of two (or more) subtypes. | Disjointness constraints |
| These are the two possible rules of the disjointness constraints. | Disjoint rule Overlap rule |
| What are the three types of data models? | Conceptual data model Logical data model Physical data model |
| What are the five data model building blocks? | Entities Attributes Relationship Constraint Business rules |
| What are the two different types of an entity? | Strong entity Weak entity |
| What are the five types of attributes? | Simple attributes Composite attributes Derived attributes Single-value attributes Multi-value attributes |
| What are the three degrees of a relationship? | Unary (degree 1) Binary (degree 2) Ternary (degree 3) |
| This is a high-level view of the entire data environment of an organization. | Conceptual data model |
| This describes the data in a more detailed and structured way than the conceptual model. | Logical data model |
| This describes an association among entities. | Relationship |
| This has a primary key. This is dependent on strong entities. Its existence is not dependent on any other entity. | Strong entity |
| These cannot be further subdivided into components. | Simple attributes |
| These can be split into components, and are made of more than one simple attribute. | Composite attributes |
| These are the attributes that do not exist in the physical database, but their values are derived from other attributes present in the database. | Derived attributes |
| These takes up only a single value for each entity instance. | Single-value attributes |
| These may contain more than one value. | Multi-value attributes |
| This is a relationship between instances of a single entity type. | Unary relationship |
| This is a relationship between the instances of two entity types and is the most common type of relationship encountered in data modeling. | Binary relationship |
| This is a simultaneous relationship among the instances of three entity types. | Ternary relationship |