Data Modeling and Diagram Notations Quiz

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?

• Chen Notation

• Crow's Foot Notation

• Class Diagram Notation

• Barker's Notation

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

• True

• False

Omar is constructing a data model. In his model he includes a description of the data structure that will store end-user data and has an enforceable set of rules to ensure data integrity. What component does he need to include to make his data model implementation ready?

• Relationship Methodology

• Data Integrity Rules

• Object-Oriented Programming

• Class Diagram Notation

Within the database environment, a data model represents data structures and their attributes, relations, constraints, and transformations with the purpose of supporting a specific problem domain. Define 'problem domain' in the context of data models.

• The process of creating a specific data model for a particular set of real-world data to be addressed

• A relatively simple and usually graphical representation of complex real-world objects or events

• A clearly defined area within a real-world environment that will be systematically addressed

• A blueprint containing all necessary instructions for building a database that will meet all end-user requirements

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

• True

• False

Sally's Dog Grooming Salon is creating a database of every dog she grooms. She wants to collect specific information about the breed, height, weight, and age of each dog. What building block does 'dog' represent in her data model?

• Relationship

• Class

• Entity

• Attribute

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

• Entity

• Object

• Constraint

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 this example using shorthand notation.

• One-to-One

• One-to-Many

• Many-to-Many

• Many-to-One

Business rules that are properly written will define entities, attributes, relationships, and _____.

• objects

• classes

• constraints

• fields

A disadvantage of the relational database management system (RDBMS) is its inability to hide the complexities of the relational model from the user.

• True

• False