MIS 3140 EXAM 1 STUDY GUIDE
Data - Answers - Raw facts
Information - Answers - Data with meaning
Advantages of dbms - Answers - 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 - Answers - Cost, management complexity, maintaining, vendor
dependance, frequent upgrade/ replacement cycles
Types of databases - Answers - 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 - Answers - data in original state
structured data - Answers - formatted data
Filing system - Answers - 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 - Answers - access to a file is dependent on its structure
Structural independence - Answers - exists when you can change the file structure
without affecting the applications ability to access the file
data reduncancy - Answers - exists when same data are stored unnecessarily in
different places, allows for poor data security and more data inconsistency
data anomoly - Answers - not all instances of data are changed
Database system enviroment - Answers - hardware, software, people, procedures, data
DBMS Function - Answers - data dictionary management, data storage management,
data transformation and presentation, security management, multi-user access control,
backup and recovery management, data integrity management, database access
language and application programming interfaces, and database communication
interfaces
Managing database function - Answers - tackle more sophisticated uses of data
resources, use that power.
Data models - Answers - simple representation, usually graphical of real world data
structures. helps you understand complexities of real world environment. finished
product is blueprint of database.
communication tool, helps understand data
Model building blocks - Answers - entity: person, place or thing
attribute: characteristic of entity
relationship: association between entities
constraint: restriction placed on data
Different models - Answers - hierarchical: upside down tree, contains levels(record type)
network model: allows child to have more than parent, more effective than hierarchical
Relational: Codd of IBM, 1970. very simple, set off data revolution, links tables
relationships
entity: chen in 1976, shows relationships of entities
Logical view - Answers - Looking at relational diagram logically rather than physically,
allows for simplicity
Keys - Answers - superkey: attribute or combination of attributes that identifies every
row in the table
Data - Answers - Raw facts
Information - Answers - Data with meaning
Advantages of dbms - Answers - 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 - Answers - Cost, management complexity, maintaining, vendor
dependance, frequent upgrade/ replacement cycles
Types of databases - Answers - 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 - Answers - data in original state
structured data - Answers - formatted data
Filing system - Answers - 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 - Answers - access to a file is dependent on its structure
Structural independence - Answers - exists when you can change the file structure
without affecting the applications ability to access the file
data reduncancy - Answers - exists when same data are stored unnecessarily in
different places, allows for poor data security and more data inconsistency
data anomoly - Answers - not all instances of data are changed
Database system enviroment - Answers - hardware, software, people, procedures, data
DBMS Function - Answers - data dictionary management, data storage management,
data transformation and presentation, security management, multi-user access control,
backup and recovery management, data integrity management, database access
language and application programming interfaces, and database communication
interfaces
Managing database function - Answers - tackle more sophisticated uses of data
resources, use that power.
Data models - Answers - simple representation, usually graphical of real world data
structures. helps you understand complexities of real world environment. finished
product is blueprint of database.
communication tool, helps understand data
Model building blocks - Answers - entity: person, place or thing
attribute: characteristic of entity
relationship: association between entities
constraint: restriction placed on data
Different models - Answers - hierarchical: upside down tree, contains levels(record type)
network model: allows child to have more than parent, more effective than hierarchical
Relational: Codd of IBM, 1970. very simple, set off data revolution, links tables
relationships
entity: chen in 1976, shows relationships of entities
Logical view - Answers - Looking at relational diagram logically rather than physically,
allows for simplicity
Keys - Answers - superkey: attribute or combination of attributes that identifies every
row in the table
