Exam 4: Data Modeling and the Entity-Relationship Model

arrow
  • Select Tags
search iconSearch Question
flashcardsStudy Flashcards
  • Select Tags

What are "business rules" and what is their role in database design?

(Essay)
4.8/5
(84)

Which of the following activities is not performed during the implementation phase of developing a database system?

(Multiple Choice)
4.8/5
(80)

System requirements as documented by use cases,business rules,forms,reports,and queries are sufficient to design the database without using a formal data model.

(True/False)
4.9/5
(83)

Distinguish between entity identifiers and keys.

(Essay)
4.9/5
(85)

One type of strong entity is the ID-dependent entity.

(True/False)
4.8/5
(66)

In crow's foot style E-R diagrams,a circle across the relationship line near an entity indicates:

(Multiple Choice)
4.8/5
(67)

A use case can be used to perform which of the following tasks?

(Multiple Choice)
5.0/5
(82)

Distinguish between a data model and a database design.

(Essay)
4.9/5
(78)

In crow's foot E-R notation,the hash mark indicates both a minimum cardinality of one and a maximum cardinality of one.

(True/False)
5.0/5
(86)

An entity that must logically depend on another entity is called a(n)________ entity.

(Short Answer)
4.9/5
(82)

Which of the following would not be contained in a use case?

(Multiple Choice)
4.9/5
(81)

Identifiers of an entity that are composed of two or more attributes are called ________ identifiers.

(Short Answer)
4.8/5
(80)

Describe the use of Microsoft Access as a prototyping tool.

(Essay)
4.8/5
(78)

Microsoft Access 2013 database files can be easily ________ to create multiple copies of a database.

(Short Answer)
4.8/5
(83)

Given only the following excerpt of an E-R model: Given only the following excerpt of an E-R model:   If one instance of ENTITY B must be related to one and only one instance of ENTITY A,and one instance of ENTITY A may be related to many instances of ENTITY B,which of the following should be written on the end of the relationship line next to ENTITY B in the figure above? If one instance of ENTITY B must be related to one and only one instance of ENTITY A,and one instance of ENTITY A may be related to many instances of ENTITY B,which of the following should be written on the end of the relationship line next to ENTITY B in the figure above?

(Multiple Choice)
4.8/5
(77)

An entity identifier can be either unique or nonunique.

(True/False)
4.8/5
(90)
Showing 61 - 76 of 76
close modal

Filters

  • Essay(0)
  • Multiple Choice(0)
  • Short Answer(0)
  • True False(0)
  • Matching(0)