MSIS 2103 FINAL EXAM ACTUAL QUESTIONS AND
SOLUTIONS RATED A+
✔✔Bar charts - ✔✔Use bar charts for comparing data across categories.
✔✔Column charts - ✔✔Use column charts for comparing categories over time.
✔✔Line Charts - ✔✔Use line charts to view trends over time.
✔✔Area charts - ✔✔Use area charts to show multiple trends over time and how the
different trends relate to each other.
✔✔Pie Charts - ✔✔Use pie charts to show percentages. This is really the only use for
pie charts.
✔✔Scatter plot - ✔✔Use scatter plots to see the relationship between different
variables.
✔✔Treemap - ✔✔Use a treemap to see all of the data and how the different pieces
relate to the whole.
✔✔Combination Charts - ✔✔It is possible to combine charts into one chart to better
visualize the data. Consider combining bar charts with line charts.
✔✔ entity relationship diagram - ✔✔shows the relationships between the tables in a
database
✔✔primary key - ✔✔a unique identifier of every row or record in the table
✔✔record primary key - ✔✔normally assigned sequentially by the database as a new
record is input into the table
✔✔relational database can have - ✔✔one to one relationship or a one to many
✔✔metadata - ✔✔defines what can go into a particular field and how it has to be
formatted
✔✔database management system (DBMS) - ✔✔a software that is used to create a
database, define fields formatting, define database business rules, and modify the
database structure
✔✔enterprise system - ✔✔have a single database and each application accesses the
same database
SOLUTIONS RATED A+
✔✔Bar charts - ✔✔Use bar charts for comparing data across categories.
✔✔Column charts - ✔✔Use column charts for comparing categories over time.
✔✔Line Charts - ✔✔Use line charts to view trends over time.
✔✔Area charts - ✔✔Use area charts to show multiple trends over time and how the
different trends relate to each other.
✔✔Pie Charts - ✔✔Use pie charts to show percentages. This is really the only use for
pie charts.
✔✔Scatter plot - ✔✔Use scatter plots to see the relationship between different
variables.
✔✔Treemap - ✔✔Use a treemap to see all of the data and how the different pieces
relate to the whole.
✔✔Combination Charts - ✔✔It is possible to combine charts into one chart to better
visualize the data. Consider combining bar charts with line charts.
✔✔ entity relationship diagram - ✔✔shows the relationships between the tables in a
database
✔✔primary key - ✔✔a unique identifier of every row or record in the table
✔✔record primary key - ✔✔normally assigned sequentially by the database as a new
record is input into the table
✔✔relational database can have - ✔✔one to one relationship or a one to many
✔✔metadata - ✔✔defines what can go into a particular field and how it has to be
formatted
✔✔database management system (DBMS) - ✔✔a software that is used to create a
database, define fields formatting, define database business rules, and modify the
database structure
✔✔enterprise system - ✔✔have a single database and each application accesses the
same database
