DDM Chapter 2 Data Models Review Questions

From a database point of view, the collection of data becomes meaningful only when it reflects properly defined ____.

Business rules

When creating a student roster, a school cannot enroll more than 20 students per course. This is an example of what data modeling building block?

Constraint

When discovering new business rules, interviews with _____ are faster and more direct, but may be less reliable.

End users

Which of the following is true of business rules?

They can serve as a communication tool between the users and designers.

Business rules use simple language to establish definitions of entities, attributes, relationships, and constraints. For instance, a business rule establishing that entities can have multiple attributes, and that each available attribute may be associated with only one entity, might be stated as "An employee may be assigned multiple devices" and "Each device may be assigned to only one employee." Classify the relationship between EMPLOYEES and DEVICES in the example using shorthand notation.

1:M

In the context of data modeling, what term is used to describe a single instance of an abstract representation of a real-world person, place, or thing?

Class

Dale's boss has tasked him with creating a dimple representation of the entire employee database including items such assign a hire date, office contact number, and resume. What type of model should Dale construct?

Data model

Determine which of the following simple-language expressions represents a valid constraint.

Each CONTAINER contains between 0 and 100 UNITs.

An implementation-ready data model needn't necessarily contain enforceable rules to guarantee the integrity of the data.

False

Even when a good database blueprint is available, an applications programmer's view of the data should match that of the manager and the end user.

False

What component of a particular business rule can be analyzed in order to infer whether the type of relationship between two entities can be represented in notation by 1:1, 1:M, or M:N?

How many instances are on each side of the relationship?

The term ______ is used to refer to the task of creating a conceptual data model that could be implemented in any DBMS.

Logical Design

Ali needs to review the metadata of a file system. Where should they look?

Name node

A verb associating two nouns in a business rule translates to a(n) ____ in a data model.

Relationship

A(n) _______ is bidirectional.

Relationship

Jackie is working in a database entering information on employees using the following format: EMPLOYEE.LAST_NAME. This indicates the attribute LAST_NAME from the EMPLOYEE in what?

The table name

In the context for Lancy's 3 Vs of Big Data databases, which term refers to the fact data is collected in multiple data formats?

Variety

When identifying and documenting business rules, it is important to recognize that despite being crucial contributors to the development of business rules, it pays to _____ the end-user's perceptions of business operations.

Verify or Describe

A company you are consulting with tells you that after their recent social media campaign they need more space to store all the data being generated. Which characteristic of Big Data databases do they need to address?

Volume

Different views of the data are less likely to cause problems or conflicts when a database offers which of the following?

Blueprint

Tess is working for a railway company and needs to create a diagram to depict the different working aspects of their reservation system such as passenger, ticket booking method, payment method, and ticket type. What notation would be the best way to visually showcase these components?

Class Diagram Notation

Elizabeth is utilizing object-oriented modeling (OOM) when collecting data about animals. She needs to define entity templates and their associated instances and subclasses. What method should she incorporate?

Class Hierarchy is a formal conceptual method.

Your manager has requested a report that gives them a global view of the entire database being used as the basis for the identification and high-level description of main data objects without model-specific details. Which model or schema would you provide them?

Conceptual

In an SQL-based relational database, each table is dependent on every other table.

False

A new database designer is struggling with the process of identifying and documenting business rules. They are considering skipping this part of the process and moving forward. If you were their mentor, which statement would show the importance of this step to the new designer?

It improves the ability to understand the nature, role, and scope of data.

The term _____ is used to refer to the task of creating a conceptual data model that could be implemented in any DBMS.

Logical design

In an SQL-based relational database, rows in different tables are related based on common values in common attributes.

True