ACCT 318 - EXAM 2 || All Solutions are Accurate.
Database correct answers structured data set that can be accessed by many potential authorized
users via a computer system; the most secure method of storing data
Excel correct answers Spreadsheet application that allows the creation and storing of data and is
a powerful tool for performing data analytics and exploring data
PivotTables, charts, graphs, statistical analysis correct answers What are some uses of excel? (4)
Tableau correct answers Tool for visualization of data and good for exploring data and
identifying trends and outliers
Relational Database correct answers stores data in separate tables, each containing a unique list
of the items stored
Tables, Fields, Records correct answers What are some components of relational databases? (3)
Tables correct answers data organized into sets of columns (fields) and rows (records)
Fields correct answers columns that contain descriptive characteristics about the items in a table
Records correct answers the instances of what is being described in the table
Primary and Foreign Key correct answers What are the two keys in relational databases?
Primary Key correct answers any field that functions as a unique identifier in a table (every table
must have one)
, Foreign key correct answers primary key of one table that is embedded as a field (characteristic)
in another table. Creates relationships by physically linking the two tables
Relational Database Data Dictionary correct answers contains details of the fields included in the
database tables
Relational Database Diagrams correct answers Communicates the same information as a data
dictionary but in a visual form
Entity-Relationship Diagrams correct answers Graphical representations of an information
system (database) that illustrates relationships among tables (resources, events, people) within
the system
Data Integrity correct answers Truthfulness of the data
Free from error correct answers no mistakes or inaccuracies
Complete correct answers includes all monetary tranactions
Neutrality correct answers data is not biased
one correct answers In a relational database, how many versions of the data can all authorized
users access?
1. Preventive controls are easier to enforce
2. security around data entry and table access can aid in creating and enforcing data entry
internal controls
3. reduced redundancy cuts down on errors
4. version control reduces the possibility of having more than one version of the data correct
answers What are the internal control benefits? (4)
Database correct answers structured data set that can be accessed by many potential authorized
users via a computer system; the most secure method of storing data
Excel correct answers Spreadsheet application that allows the creation and storing of data and is
a powerful tool for performing data analytics and exploring data
PivotTables, charts, graphs, statistical analysis correct answers What are some uses of excel? (4)
Tableau correct answers Tool for visualization of data and good for exploring data and
identifying trends and outliers
Relational Database correct answers stores data in separate tables, each containing a unique list
of the items stored
Tables, Fields, Records correct answers What are some components of relational databases? (3)
Tables correct answers data organized into sets of columns (fields) and rows (records)
Fields correct answers columns that contain descriptive characteristics about the items in a table
Records correct answers the instances of what is being described in the table
Primary and Foreign Key correct answers What are the two keys in relational databases?
Primary Key correct answers any field that functions as a unique identifier in a table (every table
must have one)
, Foreign key correct answers primary key of one table that is embedded as a field (characteristic)
in another table. Creates relationships by physically linking the two tables
Relational Database Data Dictionary correct answers contains details of the fields included in the
database tables
Relational Database Diagrams correct answers Communicates the same information as a data
dictionary but in a visual form
Entity-Relationship Diagrams correct answers Graphical representations of an information
system (database) that illustrates relationships among tables (resources, events, people) within
the system
Data Integrity correct answers Truthfulness of the data
Free from error correct answers no mistakes or inaccuracies
Complete correct answers includes all monetary tranactions
Neutrality correct answers data is not biased
one correct answers In a relational database, how many versions of the data can all authorized
users access?
1. Preventive controls are easier to enforce
2. security around data entry and table access can aid in creating and enforcing data entry
internal controls
3. reduced redundancy cuts down on errors
4. version control reduces the possibility of having more than one version of the data correct
answers What are the internal control benefits? (4)
