FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 3: Data Models

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 31

Short Answer

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 32

Short Answer

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 33

Essay

Review LaterAdd Note

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

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

The hierarchical model is software-independent.

A(n) ____ is bidirectional.

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

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

A(n) ____________________ is a representation of the relational database's entities, the attributes within those entities and the relationships between those entities.

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

A data model is usually graphical.

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

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

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

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

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

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

Students and classes have a ____ relationship.

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

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