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

Multiple Choice

Review LaterAdd Note

Review Later

A(n) ____ is bidirectional.

A) attribute
B) entity
C) relationship
D) constraint

Correct Answer

verified

Show Answer

Question 32

True/False

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 33

Short Answer

Review LaterAdd Note

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

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

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

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

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

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

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

The hierarchical model is software-independent.

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

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

A data model is usually graphical.

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

Students and classes have a ____ relationship.

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

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

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

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

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