Mist 351 exam stuvia Study guides, Class notes & Summaries

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

whats the name of the case that is used in each chapter of the book? - ANSWER Pine Valley Furniture a subclass ________ the attributes of the superclass - ANSWER inherits A CEO using software to calculate national sales figures is an example of which part of the MIS at work? - ANSWER ESS a single occurrence of an entity type is an - ANSWER entity instance the process of defining a more general entity type from a set of more specialized entity types is - ANSWER generalization a sto...

Long Term - ANSWER - Unstructured - no right answer - difficult to solve Short Term - ANSWER - Structured - there is an answer - easy to solve (put into algorithm) Constraint - ANSWER a rule that cannot be violated by database users Entity-relationship Model (E-R Model) - ANSWER a logical representation of the data for an organization or for a business area, using entities for categories of data and relationships for associations between entities Entity-relationship diagram (E-R ...

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 exam 1 Questions and Answers(RATED A) whats the name of the case that is used in each chapter of the book? - ANSWER Pine Valley Furniture a subclass ________ the attributes of the superclass - ANSWER inherits A CEO using software to calculate national sales figures is an example of which part of the MIS at work? - ANSWER ESS a single occurrence of an entity type is an - ANSWER entity instance the process of defining a more general entity type from a set of more specialize...

MIST 351 Exam #1 100% accurate Long Term - ANSWER - Unstructured - no right answer - difficult to solve Short Term - ANSWER - Structured - there is an answer - easy to solve (put into algorithm) Constraint - ANSWER a rule that cannot be violated by database users Entity-relationship Model (E-R Model) - ANSWER a logical representation of the data for an organization or for a business area, using entities for categories of data and relationships for associations between entities ...

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