ISTM 210 EXAM 3 FINAL PAPER QUESTIONS
AND CORRECT ANSWERS FULL REVIEW
GUIDE
●● Structured Query Language (SQL)
Answer: Using data visualization instead of
_______________________, makes business programming much easier
to understand.
●● Can be described as computer applications that change data into
significant, meaningful information that helps organizations make better
decisions.
Answer: Business Intelligence
●● Database Management Systems (DBMS)
Answer: A well thought-out collection of computer files
●● Filing Cabinets
Answer: Database systems are extremely similar to _______ _______ in
that they organize information based on a set of rules.
●● Tables
Answer: Where a database holds data
,●● Relation
Answer: Technical term for a table
●● Records
Answer: The rows of a table
●● Fields
Answer: The columns of a table
●● Entity Relationship Modeling (ERM)
Answer: a database-modeling method used to construct a theoretical and
conceptual representation of data to produce a schema
●● Database Schema
Answer: a "map" of data tables and their relationships to one another
●● One-to-One Relationship
Answer: Where a record of one table can only be associated with one
record from another table
●● One-to-Many Relationship
,Answer: Where a single record from a table can be associated with more
than one record from another table, but a record from the second table
can only be associated with the one record from the first table
●● Many-to-Many Relationship
Answer: Where a record from one table may be associated with more
than one record from the other table and a record from the second table
may also be associated with more than one record from the first table
●● Data Validation Rules
Answer: Help avoid input errors to ensure the data's integrity
●● 1970; Edgar Codd
Answer: The relational database model was first proposed in _______
by _______ _______.
●● Structured Query Language (SQL)
Answer: The most widely used standard computer language for
relational databases as it allows a programmer to manipulate and query
data
●● SQL Functions
Answer: Delete, Append, Update
, ●● Fluid
Answer: Data is _______ because it changes all the time.
●● Oracle
Answer: _______ is the world's most widely used database.
●● Real Estate Owned
Answer: REO is an acronym for...
●● Alibaba Group
Answer: Chinese e-commerce company that provides sales services via
web portals
●● Cloud
Answer: Using computer resources like a hard drive or software that
exists on another computer connected by a network, typically the
Internet
●● Cloud Drive
Answer: A hard drive in the Cloud
●● Cloud Service Provider
Answer: CSP is an acronym for...
AND CORRECT ANSWERS FULL REVIEW
GUIDE
●● Structured Query Language (SQL)
Answer: Using data visualization instead of
_______________________, makes business programming much easier
to understand.
●● Can be described as computer applications that change data into
significant, meaningful information that helps organizations make better
decisions.
Answer: Business Intelligence
●● Database Management Systems (DBMS)
Answer: A well thought-out collection of computer files
●● Filing Cabinets
Answer: Database systems are extremely similar to _______ _______ in
that they organize information based on a set of rules.
●● Tables
Answer: Where a database holds data
,●● Relation
Answer: Technical term for a table
●● Records
Answer: The rows of a table
●● Fields
Answer: The columns of a table
●● Entity Relationship Modeling (ERM)
Answer: a database-modeling method used to construct a theoretical and
conceptual representation of data to produce a schema
●● Database Schema
Answer: a "map" of data tables and their relationships to one another
●● One-to-One Relationship
Answer: Where a record of one table can only be associated with one
record from another table
●● One-to-Many Relationship
,Answer: Where a single record from a table can be associated with more
than one record from another table, but a record from the second table
can only be associated with the one record from the first table
●● Many-to-Many Relationship
Answer: Where a record from one table may be associated with more
than one record from the other table and a record from the second table
may also be associated with more than one record from the first table
●● Data Validation Rules
Answer: Help avoid input errors to ensure the data's integrity
●● 1970; Edgar Codd
Answer: The relational database model was first proposed in _______
by _______ _______.
●● Structured Query Language (SQL)
Answer: The most widely used standard computer language for
relational databases as it allows a programmer to manipulate and query
data
●● SQL Functions
Answer: Delete, Append, Update
, ●● Fluid
Answer: Data is _______ because it changes all the time.
●● Oracle
Answer: _______ is the world's most widely used database.
●● Real Estate Owned
Answer: REO is an acronym for...
●● Alibaba Group
Answer: Chinese e-commerce company that provides sales services via
web portals
●● Cloud
Answer: Using computer resources like a hard drive or software that
exists on another computer connected by a network, typically the
Internet
●● Cloud Drive
Answer: A hard drive in the Cloud
●● Cloud Service Provider
Answer: CSP is an acronym for...
