Exam 2: Data Models

A(n)____ is bidirectional.

What are the sources of business rules,and what is the database designer's role with regard to business rules?

Describe a conceptual model and its advantages.What is the most widely used conceptual model?

The ____________________ defines the portion of the database "seen" by the application programs that produce information from the data.

The hierarchical model is software-independent.

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

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

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

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

A(n)____________________ is a brief,precise,and unambiguous description of a policy,procedure,or principle within a specific organization.

Which data model has the highest level of abstraction?

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

A data model is usually graphical.

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

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

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

___________________________________ is a language based on OO concepts that describes a set of diagrams and symbols used to graphically model a system.

____ are important because they help to ensure data integrity.

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

In _________________________,a three-pronged symbol represents the "many" side of the relationship.