ITE 120 FINAL EXAM STUDY GUIDE
Table - Answers - groups of similar rows or records (aka files)
Field - Answers - groups of bytes in a database table. A database table has multiple
columns that represent the attributes of an entity. Examples are PartNumber,
EmployeeName, and SaleDate
Record - Answers - groups of columns in a database table (aka rows)
Primary Key - Answers - one or more columns in a relation whose values identify a
unique row of that relation (aka Key)
Foreign Key - Answers - a column of group of columns used to represent relationships.
Values of the foreign key match values of the primary key in a different (foreign) table
Database Management System (DBMS) - Answers - A program for creating, processing,
and administering a database. A DBMS is a large and complex program that is licensed
like an operating system
Microsoft Access and Oracle Databases - Answers - What are some popular DBMS's?
Metadata - Answers - data that describes data
final judges, through review of data model (entities must contain all the database users
need to do their jobs and must accurately reflect their views of the business), take it
seriously, and devote time - Answers - Users role in Database Development
NoSQL
NewSQL
In-Memory DBMS - Answers - What are the different types of DBMS?
NoSQL - Answers - supports very high transaction rates, processing relatively simple
data structure. It is also replicated on many servers in the cloud, without ACID
transaction support (MongoDB, Cassandra, Bigtable, and Dynamo)
NewSQL - Answers - process very high levels of transactions, like NoSQL DBMS, but
provide ACID support. May or may not support relational model. Current hotbed of
development
In-Memory DBMS using SQL extension - Answers - high volume SCID transaction
support with complex relational query processing
, Database Application - Answers - a collection of forms, reports, queries, and application
programs that facilitate users' processing of a database. A database can be processed
by many different database applicaions
Forms
Reports
Queries
Application Programs - Answers - What are the four elements of database applications?
Forms - Answers - view data, insert new data, update existing data, and delete existing
data
Reports - Answers - structures presentation of data using sorting, grouping, filtering, and
other operations
Queries - Answers - Search based on data values provided by the user
Application Programs - Answers - Provided security, data consistency, and special
purpose processing (ex. handle out-of-stock situations)
MySQL
Microsoft Access
Oracle - Answers - Database Application examples
ACID transactions - Answers - An acronym standing for atomic, consistent, isolated, and
durable. Used to describe the processing of transactions such that all of the transaction
is processed or none of it is (atomic), transactions are processed in the same manner
(consistent) whether processed alone or in the presence of millions of other transactions
(isolated), and that once a transaction is stored it never goes away- even on the
presence of failure (durable)
Computer Network Definition - Answers - two or more computers that are connected via
software and hardware so they can communicate
Virtual Private Network (VPN) - Answers - A WAN connection alternative that uses the
Internet or a private internet to create the appearance of private point-to-point
connections.
Local Area Network (LAN) - Answers - A network that connects computers that reside in
a single geographic location on the premises of the company that operates the LAN.
The number of connected computers can range from two to several hundred.
Wide Area Network (WAN) - Answers - A network that connects computers at different
geographic locations
Wired and Wireless connection/connectivity cables and devices - Answers -
Table - Answers - groups of similar rows or records (aka files)
Field - Answers - groups of bytes in a database table. A database table has multiple
columns that represent the attributes of an entity. Examples are PartNumber,
EmployeeName, and SaleDate
Record - Answers - groups of columns in a database table (aka rows)
Primary Key - Answers - one or more columns in a relation whose values identify a
unique row of that relation (aka Key)
Foreign Key - Answers - a column of group of columns used to represent relationships.
Values of the foreign key match values of the primary key in a different (foreign) table
Database Management System (DBMS) - Answers - A program for creating, processing,
and administering a database. A DBMS is a large and complex program that is licensed
like an operating system
Microsoft Access and Oracle Databases - Answers - What are some popular DBMS's?
Metadata - Answers - data that describes data
final judges, through review of data model (entities must contain all the database users
need to do their jobs and must accurately reflect their views of the business), take it
seriously, and devote time - Answers - Users role in Database Development
NoSQL
NewSQL
In-Memory DBMS - Answers - What are the different types of DBMS?
NoSQL - Answers - supports very high transaction rates, processing relatively simple
data structure. It is also replicated on many servers in the cloud, without ACID
transaction support (MongoDB, Cassandra, Bigtable, and Dynamo)
NewSQL - Answers - process very high levels of transactions, like NoSQL DBMS, but
provide ACID support. May or may not support relational model. Current hotbed of
development
In-Memory DBMS using SQL extension - Answers - high volume SCID transaction
support with complex relational query processing
, Database Application - Answers - a collection of forms, reports, queries, and application
programs that facilitate users' processing of a database. A database can be processed
by many different database applicaions
Forms
Reports
Queries
Application Programs - Answers - What are the four elements of database applications?
Forms - Answers - view data, insert new data, update existing data, and delete existing
data
Reports - Answers - structures presentation of data using sorting, grouping, filtering, and
other operations
Queries - Answers - Search based on data values provided by the user
Application Programs - Answers - Provided security, data consistency, and special
purpose processing (ex. handle out-of-stock situations)
MySQL
Microsoft Access
Oracle - Answers - Database Application examples
ACID transactions - Answers - An acronym standing for atomic, consistent, isolated, and
durable. Used to describe the processing of transactions such that all of the transaction
is processed or none of it is (atomic), transactions are processed in the same manner
(consistent) whether processed alone or in the presence of millions of other transactions
(isolated), and that once a transaction is stored it never goes away- even on the
presence of failure (durable)
Computer Network Definition - Answers - two or more computers that are connected via
software and hardware so they can communicate
Virtual Private Network (VPN) - Answers - A WAN connection alternative that uses the
Internet or a private internet to create the appearance of private point-to-point
connections.
Local Area Network (LAN) - Answers - A network that connects computers that reside in
a single geographic location on the premises of the company that operates the LAN.
The number of connected computers can range from two to several hundred.
Wide Area Network (WAN) - Answers - A network that connects computers at different
geographic locations
Wired and Wireless connection/connectivity cables and devices - Answers -
