MIS 3140 EXAM 1 WITH 100% CORRECT ANSWERS
Data - ANSWER Raw facts
Information - ANSWER Data with meaning
Advantages of dbms - ANSWER Improved data sharing
•Improved data security
•Better data integration
•Minimized data inconsistency
•Improved data access
•Improved decision making
•Increased end-user productivity
Disadvantages of dbms - ANSWER Cost, management complexity, maintaining, vendor
dependance, frequent upgrade/ replacement cycles
Types of databases - ANSWER Single user: one user, runs on pc
multiuser: supports multiple users at once. work group and enterprise databases
centralized database: data located at a single site
decentralized database: data located across several different sites
cloud database: created and mantained using cloud data services that provide define
, performance measures for the database
operational: supports a companies day to day operations. transactional, production
analytic: stores historical data and business metrics used for decision making. data
warehouse, business intellegence
unstructured data - ANSWER data in original state
structured data - ANSWER formatted data
Filing system - ANSWER Filing folders and a filing cabinet, transformed into a
computerized filing system.
problems: lengthy development times, difficulty of getting quick answers, complex
system administration, lack of security and limited data sharing, extensive programming
Structural dependence - ANSWER access to a file is dependent on its structure
Structural independence - ANSWER exists when you can change the file structure
without affecting the applications ability to access the file
data reduncancy - ANSWER exists when same data are stored unnecessarily in
different places, allows for poor data security and more data inconsistency
data anomoly - ANSWER not all instances of data are changed
Database system enviroment - ANSWER hardware, software, people, procedures, data
Data - ANSWER Raw facts
Information - ANSWER Data with meaning
Advantages of dbms - ANSWER Improved data sharing
•Improved data security
•Better data integration
•Minimized data inconsistency
•Improved data access
•Improved decision making
•Increased end-user productivity
Disadvantages of dbms - ANSWER Cost, management complexity, maintaining, vendor
dependance, frequent upgrade/ replacement cycles
Types of databases - ANSWER Single user: one user, runs on pc
multiuser: supports multiple users at once. work group and enterprise databases
centralized database: data located at a single site
decentralized database: data located across several different sites
cloud database: created and mantained using cloud data services that provide define
, performance measures for the database
operational: supports a companies day to day operations. transactional, production
analytic: stores historical data and business metrics used for decision making. data
warehouse, business intellegence
unstructured data - ANSWER data in original state
structured data - ANSWER formatted data
Filing system - ANSWER Filing folders and a filing cabinet, transformed into a
computerized filing system.
problems: lengthy development times, difficulty of getting quick answers, complex
system administration, lack of security and limited data sharing, extensive programming
Structural dependence - ANSWER access to a file is dependent on its structure
Structural independence - ANSWER exists when you can change the file structure
without affecting the applications ability to access the file
data reduncancy - ANSWER exists when same data are stored unnecessarily in
different places, allows for poor data security and more data inconsistency
data anomoly - ANSWER not all instances of data are changed
Database system enviroment - ANSWER hardware, software, people, procedures, data
