Chapter 3 Data Models

A(n) ____ is a restriction placed on the data

Constraint

A manager and a programmer usually have the same view of the same data.

False

Business rules apply to businesses and government groups, but not to other types of organizations such as religious groups or research laboratories.

False

Database designers determine the data and information that yield the required understanding of the entire business.

False

M:N relationships are not appropriate in a relational model.

True

Business rules are derived from ____.

a detailed description of an organization's operations

Students and classes have a ____ relationship.

many-to-many

A(n) ____ is the equivalent of a field in a file system

Attribute

A noun in a business rule translates to a(n) ____ in the data model

Entity

A(n) ____ represents a particular type of object in the real world

Entity

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

False

____'s main function is to help you understand the complexities of the real-world environment.

Model

A data model is usually graphical.

True

Business rules must be rendered in writing

True

The terms data model and database model are often used interchangeably

True

Within the database environment, a data model represents data structures with the purpose of supporting a specific problem domain

True

A(n) ____ enables a database administrator to define schema components.

data definition language (DDL)

A(n) ____ is anything about which data are to be collected and stored.

entity

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

Relationship

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

True