ITM 310 exam 2 review UPDATED ACTUAL Questions And Correct Answers
Terms in this set (196)
Database Collection of related data that is stored in a central location or in multiple
locations.
Data hierarchy Structure and organization of data, which involves fields, records, and files.
, Database Management System (DBMS) Software for creating, storing, maintaining, and accessing database files.
Internal data Stored in the organization's internal databases and can be used by functional
information systems. May be added to a data warehouse.
External data Stored in a data warehouse.
Physical view How data is stored on and retrieved from storage media (hard disks or magnetic
tapes).
Logical view How information appears and is organized and retrieved. Depending on the user,
there can be more than one logical view.
Data model Determines how data is created, represented, organized, and maintained. It
includes: Data structure, Operations, Integrity rules.
Hierarchical Model Relationships (branches) between records (nodes).
Network Model Similar to hierarchical model but organized differently. Each record can have
multiple parent and child records.
Database engine Responsible for data storage, manipulation, and retrieval.
Data definition Creates and maintains the data dictionary. Defines the structure of files in a
database.
Data manipulation Used to add, delete, modify, and retrieve records. Query languages like
Structured Query Languages (SQL).
Application generation Used to create design elements of an application.
Data administration Used for backup and recovery, security, and change management. Used to
determine permissions to create, read, update, and delete (CRUD).
Database Administrators (DBAs) People that handle database design and management, establish security
measures, develop recovery procedures, evaluate database performance, and
add and fine tune database functions.
Data-driven web sites Acts as an interface to a database. Retrieve data and allow users to enter data.
Improves access to information. Reduce support and overhead needed to
maintain static websites. Give users more current information from a variety of
data sources.
Distributed databases Stores data on multiple servers throughout an organization. Advantages include:
Design better reflects the firm's structure, Local data storage reduces response
time, Minimizes effects of computer failure, Not limited by data's physical location.
Terms in this set (196)
Database Collection of related data that is stored in a central location or in multiple
locations.
Data hierarchy Structure and organization of data, which involves fields, records, and files.
, Database Management System (DBMS) Software for creating, storing, maintaining, and accessing database files.
Internal data Stored in the organization's internal databases and can be used by functional
information systems. May be added to a data warehouse.
External data Stored in a data warehouse.
Physical view How data is stored on and retrieved from storage media (hard disks or magnetic
tapes).
Logical view How information appears and is organized and retrieved. Depending on the user,
there can be more than one logical view.
Data model Determines how data is created, represented, organized, and maintained. It
includes: Data structure, Operations, Integrity rules.
Hierarchical Model Relationships (branches) between records (nodes).
Network Model Similar to hierarchical model but organized differently. Each record can have
multiple parent and child records.
Database engine Responsible for data storage, manipulation, and retrieval.
Data definition Creates and maintains the data dictionary. Defines the structure of files in a
database.
Data manipulation Used to add, delete, modify, and retrieve records. Query languages like
Structured Query Languages (SQL).
Application generation Used to create design elements of an application.
Data administration Used for backup and recovery, security, and change management. Used to
determine permissions to create, read, update, and delete (CRUD).
Database Administrators (DBAs) People that handle database design and management, establish security
measures, develop recovery procedures, evaluate database performance, and
add and fine tune database functions.
Data-driven web sites Acts as an interface to a database. Retrieve data and allow users to enter data.
Improves access to information. Reduce support and overhead needed to
maintain static websites. Give users more current information from a variety of
data sources.
Distributed databases Stores data on multiple servers throughout an organization. Advantages include:
Design better reflects the firm's structure, Local data storage reduces response
time, Minimizes effects of computer failure, Not limited by data's physical location.
