Data Prep
This is the process of joining two or more tables and storing the result as a single table
What is Denormalization
A classic example of unneeded normalization.
What is zip codes
The key of either table may be placed as a foreign key into the other for this type of relationship
1:1
o-o refers to
optional optional
Undefined value in a database
NULL
The elimination of modification anomalies is one advantage of this.
What is Normalization
In a supertype / subtype situation, discriminators can be
Attributes
Common name for a column that is populated with inconsistent and verbose verbal data.
What is The general-purpose remarks column problem
Whether or not an instance of one entity class is required to be related to an instance of another entity class
Minimum cardinality
When converting a Association relationships you will need to us this type of table
Intersection table
This creates more complex SQL for multi-table subqueries and joins
What is normalization.
A table with columns PhoneNumber01, PhoneNumber02, and PhoneNumber03 is likely to have this
the multivalue, multicolumn problem
"large red hat", "large hat, red", "red hat large" and "hat, large, red." are referred to as
inconsistent values problem
This states when a parent row is deleted, related child rows should be deleted as well.
Cascading deletion
An entity whose identifier includes the identifier of another entity is a(n)
Weak entity
Anomalies caused by multi-value dependencies can be eliminated by putting tables into this FORM
What is 4NF
This consists of a group of attributes.
composite attribute
In a relational database design, relationships are typically expressed by creating a
Foreign Key
m-m refers to
mandatory mandatory
Supertype/subtype entities are said to have a(n) ________ relationship
IS-A
If all determinants are candidate keys then the table is said to be in
What is BCNF
For a relationship to be considered a binary relationship it must have
exactly two entity classes
A unique, system applied identifier
Surrogate key
A relationship among entities or rows of the same type
Recursive Relationship
An entity whose existence depends on the presence of another entity but whose identifier does not include the identifier of the other entity is a(n)
Weak Entity