INFO FINAL part 2

At the implementation level, the supertype and its subtype(s) depicted in the specialization hierarchy maintain a________ relationship

1:1

A table that has all key attributes defined, has no repeating group, and all its attributes are dependent on the primary key, is said to be in at least________

1NF

From a structural point of view, 2NF is better than ____

1NF

The above ADVISER table meets the requirement for__________

2NF

The above DORM table meets the requirement for__________

2NF

________is a generic entity type that is related to one or more entity subtypes.

An entity supertype

User requirements, existing system evaluation, and logical system design are part of the _______phase

Analysis

The invernal model adapts the conceptual model to a specific

DBMS

A__________occurs when you have one entity in two 1:M relationships to other entities, thus producing an association among the other entities that is not expressed in the model.

Fan trap

The database is loaded during the______ phase of the SDLC

Implementation

The above STUDENT_ACTIVITY table meets the requirement for__________

NNF

A________key is a real-world, generally accepted identifier used to uniquely identify real-world objects.

Natural

The "______________" characteristic of a primary key states that: The PK should not have embedded semantic meaning. An attribute with embedded semantic meaning is probably better used as a descriptive characteristic of the entity rather than as an identifier.

Non intelligent

An attribute that is part of a key is known as a(n)

Non prime

Overlapping subtypes are subtypes that contain______subsets of the supertype entity set

Non unique

Within a specialization hierarchy, every subtype can have________supertype(s) to which it is directly related

Only one

"What are the requirements of the current system's end users?" is a question asked during the _______ phase of the SDLC.

Planning

The initial assessment and the feasibility study are part of the SDLC's _________ phase

Planning

One important inheritance characteristic is that all entity subtypes inherit their_______key attribute from their supertype.

Primary

A______exists when there are functional dependencies such that Y is functionally dependent on X and Z is functionally dependent on Y, and X is the primary key.

Transitive dependency

Partial completeness is symbolized by_________

a circle over a single line

BCNF can be violated only if the table contains more than one________key

candidate

An atomic attribute_________

cannot be further subdivided

Creating the conceptual design and selecting DBMS software are part of the________phase of the DBLC.

database design

Sometimes the highest level of normalization conflicts with the need for____________

fast performance

A table is in 4NF if it is in 3NF and______________

has no multivalued dependencies

Generally, the higher the normal form, the more_____ are required to produce a specified output.

joins

Dependencies based on only a part of a composite primary key are called________dependencies

partial

Granularity refers to_________

the level of detail represented by the values stored in a table's row