Data Modelling

What are relationship labels?

• The verb phrases describing the business rules in each direction between two entities.

• The nullability setting on a foreign key.

• A foreign key that has been role-named.

• A relationship without cardinality.

• A non-identifying relationship.

Which of these statements has the most meaningful relationship label?

• An order line contains orders

• An order is associated with order lines.

• An order is related to order lines.

• An order is connected with order lines.

• An order is composed of order lines.

All of the following are TRUE statements on relationship types except:

• A many-to-many relationship says that an instance of each entity may be associated with many instances of the other entity, and vice versa.

• A one-to-one relationship says that a parent entity may have one and only one child entity.

• A one-to-many relationship says that a parent entity may have one or more child entities.

• A one-to-many relationship says that a child entity may have one or more parent entities.

• A recursive relationship relates instances of an entity to other instances of the same entity.

In the BASE vs ACID model for Transaction Processing, E is best described which of these statements?

• End to End data consistency

• Eventual Availability of Data as described by the CAP theorem

• Eventual Data Consistency

• Extra Validation Business Availability of Secure data Elements

A bank applies the business rule that each Customer may own one or many Accounts and each Account must be owned by one or many Customers. Which relationship type would be most appropriate?

• many-to-many.

• one-to-many.

• many-to-one.

• one-to-one.

• recursive.

An employee may work for one other employee and may manage one or more employees. There is an indeterminate number of levels in this management hierarchy. What type of relationship would work best?

• recursive.

• one-to-one.

• subtyping.

• identifying.

• non-identifying.

Which of the following business rules should NOT appear on a logical data model?

• Each Person can work for zero to many Companies

• Customer Last Name requires a non-unique index to improve retrieval performance.

• Each Company must employ one or many Persons.

• Each Order can contain one or many Order Lines.

• Each Policy must belong to one Policy Owner.

All of the following are properties of a logical data model except:

• contains relationship cardinality

• technology-independent contains attributes.

• contains primary keys.

• technology-dependent

According to the DMBok, the deliverables for a data modelling process do not have to include:

• the steps in the business process that use the data.

• one or more diagrams.

• definitions for entities, attributes and relationships.

• issues and outstanding questions regarding data usage.

• lineage describing where the data came from.

The highest level of these data model types is the:

• Database model

• Physical model

• Conceptual model

• Dimensional model

• Logical model