Filters
Question type

Study Flashcards

The process of database design is a sequential process.

A) True
B) False

Correct Answer

verifed

verified

The Crow's Foot notation easily identifies multivalued attributes.

A) True
B) False

Correct Answer

verifed

verified

In implementation terms,an entity is existence-dependent if it has a mandatory primary key.

A) True
B) False

Correct Answer

verifed

verified

Ideally,an entity identifier is composed of attribute(s) .


A) three
B) one
C) two
D) six

E) B) and C)
F) A) and D)

Correct Answer

verifed

verified

The decision to store attributes in database tables depends on the processing requirements and the constraints placed on a particular application.


A) multivalued
B) derived
C) single-valued
D) composite

E) All of the above
F) B) and C)

Correct Answer

verifed

verified

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

Correct Answer

verifed

verified

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


A) self
B) self-referring
C) looping
D) recursive

E) A) and D)
F) A) and B)

Correct Answer

verifed

verified

A attribute can be further subdivided to yield additional attributes.


A) composite
B) simple
C) single-valued
D) multivalued

E) B) and C)
F) All of the above

Correct Answer

verifed

verified

When using the Crow's Foot notation,the associative entity is indicated by relationship lines between the parents and the associative entity.


A) dotted
B) double
C) triple
D) solid

E) All of the above
F) A) and B)

Correct Answer

verifed

verified

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


A) (0,N)
B) (1,N)
C) (1,1)
D) (0,1)

E) B) and C)
F) None of the above

Correct Answer

verifed

verified

An entity is said to be -dependent if it can exist in the database only when it is associated with another related entity occurrence.


A) existence
B) relationship
C) business
D) data

E) All of the above
F) B) and C)

Correct Answer

verifed

verified

The conceptual model can handle relationships and multivalued attributes.


A) 1:1
B) M:N
C) 1:M
D) 1:N

E) A) and B)
F) A) and D)

Correct Answer

verifed

verified

The existence of a mandatory relationship indicates that the minimum cardinality is 0 or 1 for the mandatory entity.

A) True
B) False

Correct Answer

verifed

verified

A(n) is the set of possible values for a given attribute.


A) domain
B) range
C) identifier
D) key

E) B) and C)
F) None of the above

Correct Answer

verifed

verified

If an entity can exist apart from all of its related entities,then it is existence-independent,and it is referred to as a(n) entity.


A) weak
B) alone
C) unary
D) strong

E) None of the above
F) A) and C)

Correct Answer

verifed

verified

What is a ternary relationship? Provide some business rules examples that specify the need for a ternary or higher- order relationship.

Correct Answer

verifed

verified

A ternary relationship implies an associ...

View Answer

A derived attribute is indicated in the Chen notation by a that connects the attribute and an entity.


A) single line
B) dashed line
C) double dashed line
D) double line

E) A) and B)
F) A) and C)

Correct Answer

verifed

verified

A weak entity must be -dependent.

Correct Answer

verifed

verified

A(n)attribute is an attribute that must have a value.

Correct Answer

verifed

verified

When the specific cardinalities are not included on the diagram in Crow's Foot notation,cardinality is implied by the use of _____.


A) symbols
B) attributes
C) images
D) tables

E) A) and C)
F) B) and D)

Correct Answer

verifed

verified

Showing 21 - 40 of 75

Related Exams

Show Answer