Definitions
Something that describes a person, place, thing, object, or event is a(n):
Attribute
What is the conversion rule for a many to many binary relationship?
Create a new table.
A relationship in which three entities are relate is a(n):
Ternary Relationship
Data sharing is increased
Data dependence is decreased
Data redundancy is reduced
A subclass _____ the attributes of the superclass.
inherits
A unique identifier in a table is a(n):
Primary Key
When two or more attributes come together to make one key, what is that called?
Concatenated primary key.
A relationship in which an entity has a relation with itself is called a(n):
Unary Relationship
What is the goal of MIST professionals?
To meet the needs of the user
To problem solveName at least two naming conventions for entities.
All capitalized
Singular
No special characters
An attribute that is unique enough to be the primary key but is not the primary key is a(n):
Candidate Key
When converting a binary 1 to many relationship, how many tables will usually be created?
Two
A relationship in which two entities are related is called a(n):
Binary Relationship
What is the goal of any good database?
An attribute added to a superclass to differentiate between subclasses is a(n):
Subtype Discriminator
Cardinalities are determined by:
The business rules
When converting a multivalued attribute, you make a new table. What goes in the new table?
The attribute you are converting and the PK of the table that it came from.
A relationship between two entities that has attributes of its own can become a(n):
Associative entity
What comes after the conceptual design phase of the Database design model?
Logical Database Design
What is unstructured data?
Data that does not have a defined shape. Images, sounds, etc.
The rule that states that an instance of an entity may belong to one and only one subclass is a(n):
Disjoint Rule
Tables are linked together through:
Foreign key=Primary key links
The minimum cardinality refers to what?
The minimum number of instances entity A must be associated with entity B.
TPS: Transaction Processing System
Which rule states that every subclass is shown and accounted for is the:
Completeness Constraint