Question 1

A(n) relationship is also known as an identifying relationship.

Accepted Answer

The answer of A(n) relationship is also known as an...

Question 2

A attribute can be further subdivided to yield additional attributes.

Accepted Answer

A)   composite
B)   simple
C)   single-valued
D)   multivaluedE) A) and B)
F) None of the above

Question 3

are underlined in an ER diagram.

Accepted Answer

The answer of are underlined in an ER diagram....

Question 4

The Crow's foot symbol with two vertical parallel lines indicates cardinality.

Accepted Answer

A)   (0,N) 
B)   (1,N) 
C)   (1,1) 
D)   (0,1) E) B) and C)
F) All of the above

Question 5

If Tiny College has some departments that are classified as "research only" and do not offer courses, the COURSE entity of the college database would be the DEPARTMENT entity.

Accepted Answer

A)   existence-dependent on
B)   independent of
C)   mandatory for
D)   optional toE) B) and C)
F) C) and D)

Question 6

Software vendors have adopted the Chen representation because of its compact representation.

Accepted Answer

A) True 
 B)False

Question 7

In a 1:M relationship, to avoid the possibility of referential integrity errors, the data of the "1" side must be loaded first.

Accepted Answer

A) True 
 B)False

Question 8

A entity has a primary key that is partially or totally derived from the parent entity in the relationship.

Accepted Answer

A)   strong
B)   weak
C)   business
D)   childE) A) and D)
F) A) and B)

Question 9

A weak entity must be -dependent.

Accepted Answer

The answer of A weak entity must be -dependent....

Question 10

The Crow's Foot notation easily identifies multivalued attributes.

Accepted Answer

A) True 
 B)False

Question 11

Complex requirements may dictate data transformations, and they may expand the number of entities and attributes within the design.

Accepted Answer

A)   information
B)   entity
C)   design
D)   processingE) C) and D)
F) A) and B)

Question 12

Failure to understand the distinction between mandatory and optional in relationships might yield designs in which awkward (and unnecessary) temporary rows (entity instances) must be created just to accommodate the creation of required entities.

Accepted Answer

The answer of Failure to understand the distinction between mandatory...

Question 13

A weak entity has a primary key that is partially or totally derived from the parent entity in the relationship.

Accepted Answer

A) True 
 B)False

Question 14

The first step in building an entity-relationship diagram (ERD)  is .

Accepted Answer

A)   developing the initial ERD
B)   creating a detailed narrative of the organization's description of operations
C)   identifying the attributes and primary keys that adequately describe the entities
D)   identifying the business rules based on the description of operationsE) B) and C)
F) None of the above

Question 15

In Crow's Foot notation, an optional relationship between entities is shown by drawing a(n) on the side of the optional entity.

Accepted Answer

The answer of In Crow's Foot notation, an optional relationship...

Question 16

To implement a small database, a database designer must know the "1" and the "M" sides of each relationship and whether the relationships are mandatory or optional.

Accepted Answer

A) True 
 B)False

Question 17

In the entity relationship model, a table row corresponds to an entity instance.

Accepted Answer

A) True 
 B)False

Question 18

A(n) process is based on repetition of processes and procedures.

Accepted Answer

The answer of A(n) process is based on repetition of...

Question 19

If an employee within an EMPLOYEE entity has a relationship with itself, that relationship is known as a ?relationship.

Accepted Answer

A)   self
B)   self-referring
C)   looping
D)   recursiveE) B) and D)
F) A) and D)

Question 20

A attribute is one that cannot be subdivided.

Accepted Answer

A)   composite
B)   simple
C)   single-valued
D)   multivaluedE) B) and D)
F) All of the above

Exam 4: Entity Relationship Er Modeling

In Crow's Foot notation, an optional relationship between entities is shown by drawing a(n) on the side of the optional entity.

Correct AnswerverifiedShow Answer

To implement a small database, a database designer must know the "1" and the "M" sides of each relationship and whether the relationships are mandatory or optional.

Correct AnswerverifiedShow Answer

In the entity relationship model, a table row corresponds to an entity instance.

Correct AnswerverifiedShow Answer

A weak entity has a primary key that is partially or totally derived from the parent entity in the relationship.

Correct AnswerverifiedShow Answer

A attribute is one that cannot be subdivided.

Correct AnswerverifiedShow Answer

Failure to understand the distinction between mandatory and optional in relationships might yield designs in which awkward (and unnecessary) temporary rows (entity instances) must be created just to accommodate the creation of required entities.

Correct AnswerverifiedShow Answer

A attribute can be further subdivided to yield additional attributes.

Correct AnswerverifiedShow Answer

The Crow's foot symbol with two vertical parallel lines indicates cardinality.

Correct AnswerverifiedShow Answer

In a 1:M relationship, to avoid the possibility of referential integrity errors, the data of the "1" side must be loaded first.

Correct AnswerverifiedShow Answer

The Crow's Foot notation easily identifies multivalued attributes.

Correct AnswerverifiedShow Answer

A weak entity must be -dependent.

Correct AnswerverifiedShow Answer

are underlined in an ER diagram.

Correct AnswerverifiedShow Answer

If an employee within an EMPLOYEE entity has a relationship with itself, that relationship is known as a ?relationship.

Correct AnswerverifiedShow Answer

A entity has a primary key that is partially or totally derived from the parent entity in the relationship.

Correct AnswerverifiedShow Answer

A(n) process is based on repetition of processes and procedures.

Correct AnswerverifiedShow Answer

A(n) relationship is also known as an identifying relationship.

Correct AnswerverifiedShow Answer

The first step in building an entity-relationship diagram (ERD) is .

Correct AnswerverifiedShow Answer

Software vendors have adopted the Chen representation because of its compact representation.

Correct AnswerverifiedShow Answer

If Tiny College has some departments that are classified as "research only" and do not offer courses, the COURSE entity of the college database would be the DEPARTMENT entity.

Correct AnswerverifiedShow Answer

Complex requirements may dictate data transformations, and they may expand the number of entities and attributes within the design.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified