Mist 351 final stuvia - Study guides, Class notes & Summaries

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...

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...

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...

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 allows for - ANSWER decreased data dependence, increased d...

MIST 351 final Correct Questions & 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 ...

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...

Describe table; - ANSWER shows the details of a table show tables; - ANSWER shows all the tables in the database show databases; - ANSWER shows all the databases on the server CREATE DATABASE database_name; - ANSWER Creates a database use databasename; - ANSWER use a database create table TABLENAME; - ANSWER creates a table select - ANSWER selects data from table

MIST 351 Final Correct and Answers 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 th...

MIST 351 Final Exam QuesDescribe table; - ANSWER shows the details of a table show tables; - ANSWER shows all the tables in the database show databases; - ANSWER shows all the databases on the server CREATE DATABASE database_name; - ANSWER Creates a database use databasename; - ANSWER use a database create table TABLENAME; - ANSWER creates a table select - ANSWER selects data from table from - ANSWER tells the database which table you are pulling from join - ANSWER tells ...