MIS 431 Exam 1 Questions and Answers Already Passed

MIS 431 Exam 1 Questions and Answers Already Passed metadata - Answers data about data; describes the data database management systems (DBMS) does what 3 things? - Answers manages database structure, controls access to data, contains query language importance of DBMS (5) - Answers makes data management more efficient and effective, query language allows quick answers, provides better access to more and better-managed data, promotes integrated view of organization's operations, reduces probability of inconsistent data data definition - Answers raw facts field/attribute definition - Answers group of characters with a specific meaning record/row/tuple - Answers logically connected fields that describe a person, place or thing table - Answers collection of related records database models - Answers collection of logical constructs used to represent data structures and relationships within a database conceptual models - Answers logical nature of data representation implementation models - Answers emphasis on how the data are represented in the database relational database - Answers a collection of tables for data storage; series of row/column intersections related by a common entity entity integrity is enforced automatically if a _________ _______ is specified in the _____________ _____________ command sequence - Answers primary key, create table referential integrity can be enforced in specification of a ____________ ____________ - Answers foreign key command to enter data into a table - Answers INSERT INTO <table name> VALUES (attribute 1 value, attribute 2 value) command that allows table contents to be listed - Answers SELECT<attribute name> FROM <table names>. command that makes data entry corrections - Answers UPDATE<table name> SET<attribute name>=value where <identifying attribute name>=value; ______ command restores database back to previous condition if ______ hasn't been used - Answers rollback, commit command that removes table rows - Answers DELETE FROM <table names> WHERE <attribute names> =value; command for table structure changes - Answers Alter Table <table name> Add <attribute name and attribute characteristics> Alter Table <table name> Drop <attribute name> command to create a partial list of table contents - Answers Select <columns> from <table name> where <conditions> symbols and terms: = - Answers is equal to, follows attribute and WHERE in command symbols and terms: In - Answers in the subset of (if the value/name appears on the list, it is pulled) symbols and terms: between - Answers in the range of, between these two values symbols and terms: <>, != - Answers not equal to for mathematical operations on dates or character attributes, use... - Answers WHERE attribute > 'whatever' alias - Answers alternate name given to table or column in SQL statement