MSIS 2103 CORRECT TEST PAPER QUESTIONS AND ANSWERS SET A.pdf

MSIS 2103 CORRECT TEST PAPER QUESTIONS
AND ANSWERS SET A+
✔✔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

✔✔Enterprise Resource Planning (ERP) system - ✔✔often used by businesses that
manufacture products

✔✔customer relationship management (CRM) - ✔✔Service companies and sales
companies often use CRM systems