Exam 4: Data Modeling and the Entity-Relationship Model

arrow

14,427 students have unlocked this exam

  • 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
(36)

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

(Multiple Choice)
4.8/5
(37)

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
(40)

Distinguish between entity identifiers and keys.

(Essay)
4.9/5
(38)

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

(True/False)
4.9/5
(28)

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

(Multiple Choice)
4.8/5
(35)

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

(Multiple Choice)
4.9/5
(41)

Distinguish between a data model and a database design.

(Essay)
4.9/5
(37)

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
(36)

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

(Short Answer)
4.9/5
(38)

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

(Multiple Choice)
4.9/5
(34)

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

(Short Answer)
4.8/5
(40)

Describe the use of Microsoft Access as a prototyping tool.

(Essay)
4.8/5
(35)

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

(Short Answer)
4.8/5
(34)

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.7/5
(40)

An entity identifier can be either unique or nonunique.

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

Filters

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