Question 1

A occurs when there is one entity in two 1:M relationships to other entities,thus producing an association among the other entities that is not expressed in the model.

Accepted Answer

A) surrogate primary key 
B) time-variant data 
C) design trap 
D) fan trap 
A) surrogate primary key 
B) time-variant data 
C) design trap 
D) fan trap

Question 2

Composite primary keys are particularly useful as identifiers of composite entities,where each primary key combination is allowed only once in the relationship.

Accepted Answer

A) 0:1 
B) 1:1 
C) 1:M 
D) M:N 
A) 0:1 
B) 1:1 
C) 1:M 
D) M:N

Question 3

An entity cluster is formed by combining multiple interrelated entities into .

Accepted Answer

A) a single abstract entity object 
B) multiple abstract entity objects 
C) a single entity object 
D) multiple entity objects 
A) a single abstract entity object 
B) multiple abstract entity objects 
C) a single entity object 
D) multiple entity objects

A occurs when there is one entity in two 1:M relationships to other entities,thus producing an association among the other entities that is not expressed in the model.

Composite primary keys are particularly useful as identifiers of composite entities,where each primary key combination is allowed only once in the relationship.

An entity cluster is formed by combining multiple interrelated entities into .

Database Systems

Data Models

The Relational Database Model

Entity Relationship Ermodeling

Normalization of Database Tables

Introduction to Structured Query Language SQL

Advanced SQL

Database Design

Transaction Management and Concurrency Control

Database Performance Tuning and Query Optimization

Distributed Database Management Systems

Business Intelligence and Data Warehouses

Big Data Analytics and NoSQL

Database Connectivity and Web Technologies

Database Administration and Security

Filters

Exam 5: Advanced Data Modeling

A occurs when there is one entity in two 1:M relationships to other entities,thus producing an association among the other entities that is not expressed in the model.

Composite primary keys are particularly useful as identifiers of composite entities,where each primary key combination is allowed only once in the relationship.

An entity cluster is formed by combining multiple interrelated entities into .

Database Systems

Data Models

The Relational Database Model

Entity Relationship Ermodeling

Normalization of Database Tables

Introduction to Structured Query Language SQL

Advanced SQL

Database Design

Transaction Management and Concurrency Control

Database Performance Tuning and Query Optimization

Distributed Database Management Systems

Business Intelligence and Data Warehouses

Big Data Analytics and NoSQL

Database Connectivity and Web Technologies

Database Administration and Security

Filters