Exam 2: Data Models

The ____________________ is the conceptual organization of the entire database as viewed by the database administrator.

A(n)____ is bidirectional.

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

Which of the following is true of business rules?

In ____________________,relationships are represented by a diamond connected to the related entities through a relationship line.

Today,most relational database products can be classified as object/relational.

The relational data model was developed in the ____.

In Chen notation,entities and relationships must be oriented horizontally.

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

A(n)____________________ is a collection of similar objects with a shared structure and behavior.

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

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

In object-oriented terms,a(n)____________________ defines an object's behavior.

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

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

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

Students and classes have a ____ relationship.

The ____ model was developed to allow designers to use a graphical tool to examine structures rather than describing them with text.

What components should an implementation-ready data model contain?

The terms data model and database model are often used interchangeably.