Exam 2: Data Models

Each row in a relation is called a(n)____________________.

The entity relationship model is limited to conceptual modeling,with no implementation component.

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

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

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

____ are normally expressed in the form of rules.

The hierarchical data model was developed in the ____.

The hierarchical model is software-independent.

The relational model is hardware-dependent and software-independent.

End-user interfaces require the end user to manually generate SQL code.

Business rules must be rendered in writing.

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

The ____ model uses the term connectivity to label the relationship types.

A(n)____________________ is a relatively simple representation of more complex real-world data structures.

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

Each column in a relation represents a(n)____________________.

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

An implementation-ready data model should contain a description of the data structure that will store the end-user data.

In the ____ model,the user perceives the database as a collection of records in 1:M relationships,where each record can have more than one parent.

When you can change the internal model without affecting the conceptual model,you have ____________________ independence.