Mist 351 - Study guides, Class notes & Summaries

MIST 351 Final Exam Questions and Answers

What is a subtype discriminator? - ANSWER -basically you're estimating the trade off between having inconsistencies & redundancies for ease of searching the database by using a type -An attribute of the supertype whose values determine the target subtype(s) true or false: an associative entity belongs to a one-to-many relationship - ANSWER false—only many-to-many if you have a unary relationship with your database, what will the conversion look like? example: ingredients( INum, INa...

MIST 351 Final Correct Questions &What is a subtype discriminator? - ANSWER -basically you're estimating the trade off between having inconsistencies & redundancies for ease of searching the database by using a type -An attribute of the supertype whose values determine the target subtype(s) true or false: an associative entity belongs to a one-to-many relationship - ANSWER false—only many-to-many if you have a unary relationship with your database, what will the conversion look lik...

Something that describes a person, place, object, or event is a(n) - ANSWER Attribute Cardinality is determined by - ANSWER The business rules Tables are linked together through - ANSWER Primary key-foreign key links Data independence can lead to - ANSWER None of the above a. Increased redundancy b. Decreased sharing c. All of the above d. None of the above The rule that states that an entity instance can simultaneously be a member of more than one subclass is the - ANSWER Over...

MIST 351 Final Exam Questions and Answers

The major problem that we try to eliminate with good logical database design is - ANSWER redundancy and inconsistency something that represents a person, place, or event in an object model is an - ANSWER object a relationship between three entities that has attributes of its own can become an - ANSWER associative entity data dependency can lead to - ANSWER increased redundancy and decreased sharing cardinality is determined by - ANSWER the business rules the part of the MIS that c...

MIST 351 Final Exam Accurate Questions & Answers! Disjoint Rule - ANSWER the rule that states that an entity instance cannot simultaneously be a member of more than one subclass pine valley furniture - ANSWER the name of the case used in each chapter of the book redundancy - ANSWER the major problem that we try to eliminate with good database design what leads to inconsistency - ANSWER redundancy a subclass ______ the attributes of the superclass - ANSWER inherits A DBMS allo...

MIST 351 Final Exam Questions and Answers