MIS 3140 (Management Information Systems) Final
Exam Review Solved 100%
4NF - ANSWER-3NF with no multivalued dependecies
BCNF Form - ANSWER-when every determinate in the table is a candidite key.
Candidite key - ANSWER-a minimal superkey, a superkey that does not contain a
subset of attributes that is itself a superkey
Completeness Constraint - ANSWER-specifies whether each entity supertype
occurence must also be a member of a subtype
Partial - no
Total - must be member of atleast one subtype
Composite and Surrogate Keys - ANSWER-use composite with composite relationship
use surrogate when no real world identifier, no meaning
composite entities - ANSWER-associative entity, they solve 1:m relationships. Enroll
table with course and class relationship.
concurrency control - ANSWER-coordinating the simultaneous execution of transactions
in a multiuser database system is known as concurrency control. ensures serialzibility of
transactions
concurrency control with methods - ANSWER-time stamping - approach to scheduling
concurrent transactions assigns a time stamp to each transaction . time stamps have
uniqueness and monotonicity
optimistic - based on assumption that the majority of database operations do not
conflict. requires neither locking nor time stamping techniques. transaction is executed
without restrictions until it is commited
Concurrency Controls with locking methods - ANSWER-a lock gaurentrees excluesive
use of a data item to a current transaction. T2 does not have access have to a data item
that is currently being used by T1
lock manager - responsible for assigning and policing the locks used by the transactions
Data Dictionairy - ANSWER-
Data redudancies - ANSWER-foriegn keys control data redudancy.
, Database design conflicting goals - ANSWER-processing speed, information
requirements, design standards
database recovery management - ANSWER-restores the database from a given state to
a previous consistent state, triggered when a critical event occurs.
Denormilization - ANSWER-Produces a lower normal form that is a 3nf will be
converted into a 2nf
Dependencies - ANSWER-Partial dependecy - exists when there is a functional
dependance in which the determinate is only part of the primary key. A,B > C,D. B > C
is a partial dependency only part of the primary key(B) is needed to determine C
transitive dependecy - X > Y, Y > Z. X>Z is the transitive dependecy
Design Cases - ANSWER-Time variant - salary history table
fan trap - occurs when you have one entity in two 1:m relationships
redudant relationships - relationships that are already known for example division team
and player
Disjoint/ Overlapping Contraints - ANSWER-Disjoint - Grad, undergrad
Overlapping - administator, prof
Divide - ANSWER-divides table by another table. Dividing LOC by A and B, 5 is only
value associated with A and B
Entities and Attributes - ANSWER-Entities are objects/nouns. Attributes are
characteristics of the entity
Entity Clustering - ANSWER-Virtual entity type to represent multiple entities and
relationships in the ERD
Entity supertypes and subtypes - ANSWER-supertypes is a generic entity type that is
related to one or more entity subtypes
Existance-dependant - ANSWER-entity that can exist in the database only when
another entity occurs. employee claims dependant
foreign - ANSWER-primary key of a foreign table in a relationship with another table
inconstistent retrievals - ANSWER-Occur when a transaction accesses data before or
after one or more other transactions finish working with such data.
Exam Review Solved 100%
4NF - ANSWER-3NF with no multivalued dependecies
BCNF Form - ANSWER-when every determinate in the table is a candidite key.
Candidite key - ANSWER-a minimal superkey, a superkey that does not contain a
subset of attributes that is itself a superkey
Completeness Constraint - ANSWER-specifies whether each entity supertype
occurence must also be a member of a subtype
Partial - no
Total - must be member of atleast one subtype
Composite and Surrogate Keys - ANSWER-use composite with composite relationship
use surrogate when no real world identifier, no meaning
composite entities - ANSWER-associative entity, they solve 1:m relationships. Enroll
table with course and class relationship.
concurrency control - ANSWER-coordinating the simultaneous execution of transactions
in a multiuser database system is known as concurrency control. ensures serialzibility of
transactions
concurrency control with methods - ANSWER-time stamping - approach to scheduling
concurrent transactions assigns a time stamp to each transaction . time stamps have
uniqueness and monotonicity
optimistic - based on assumption that the majority of database operations do not
conflict. requires neither locking nor time stamping techniques. transaction is executed
without restrictions until it is commited
Concurrency Controls with locking methods - ANSWER-a lock gaurentrees excluesive
use of a data item to a current transaction. T2 does not have access have to a data item
that is currently being used by T1
lock manager - responsible for assigning and policing the locks used by the transactions
Data Dictionairy - ANSWER-
Data redudancies - ANSWER-foriegn keys control data redudancy.
, Database design conflicting goals - ANSWER-processing speed, information
requirements, design standards
database recovery management - ANSWER-restores the database from a given state to
a previous consistent state, triggered when a critical event occurs.
Denormilization - ANSWER-Produces a lower normal form that is a 3nf will be
converted into a 2nf
Dependencies - ANSWER-Partial dependecy - exists when there is a functional
dependance in which the determinate is only part of the primary key. A,B > C,D. B > C
is a partial dependency only part of the primary key(B) is needed to determine C
transitive dependecy - X > Y, Y > Z. X>Z is the transitive dependecy
Design Cases - ANSWER-Time variant - salary history table
fan trap - occurs when you have one entity in two 1:m relationships
redudant relationships - relationships that are already known for example division team
and player
Disjoint/ Overlapping Contraints - ANSWER-Disjoint - Grad, undergrad
Overlapping - administator, prof
Divide - ANSWER-divides table by another table. Dividing LOC by A and B, 5 is only
value associated with A and B
Entities and Attributes - ANSWER-Entities are objects/nouns. Attributes are
characteristics of the entity
Entity Clustering - ANSWER-Virtual entity type to represent multiple entities and
relationships in the ERD
Entity supertypes and subtypes - ANSWER-supertypes is a generic entity type that is
related to one or more entity subtypes
Existance-dependant - ANSWER-entity that can exist in the database only when
another entity occurs. employee claims dependant
foreign - ANSWER-primary key of a foreign table in a relationship with another table
inconstistent retrievals - ANSWER-Occur when a transaction accesses data before or
after one or more other transactions finish working with such data.
