Chapter 4

Question 1

DBMS

Answer 1

Database management system

Question 2

Relational database

Answer 2

Data from separate tables are linked together

Question 3

Attribute, record and field

Answer 3

1) Attribute=column
2) Record=row
3) Field=individual cell

Question 4

Primary Key

Answer 4

Attribute that can uniquely identify a specific row in a table

Question 5

Foreign Key

Answer 5

Attribute in one table that is the primary key in another table. Links the two tables.

Question 6

Rules of Relational Databases

Answer 6

1) Attributes must be single valued
2) Primary keys can’t be zero/empty and cannot have duplicates

Question 7

Update anomaly

Answer 7

Changes to existing data on one table don’t update to linked tables

Question 8

Insert anomaly

Answer 8

Unable to add a new record to the table if there is no primary key

Question 9

Delete anomaly

Answer 9

Removing a record also removes other unintended data from the database

Question 10

Data integration

Answer 10

Databases can be accessed by various programs, not just an AIS

Question 11

Cross-functional analysis

Answer 11

The act of combining data from various departments

Question 12

DBA

Answer 12

Database administrator: only one with direct access to the database

Question 13

Change management

Answer 13

Testing changes to the database/AIS in a test environment before going live

Question 14

DMBS and their associations:
1) Oracle
2) SQL
3) DB2

Answer 14

Oracle: Used with oracle and SAP
SQL: Used with Microsoft AIS products
DB2: Used with IBM products and custom AIS’s

Question 15

SQL

Answer 15

Structured query language, can be used across any database

Question 16

SQL: SELECT

Answer 16

Picks attributes

Question 17

SQL: FROM

Answer 17

From what table will it pull data

Question 18

SQL: WHERE or HAVING

Answer 18

Applies a filter to the data

Question 19

SQL: GROUP BY

Answer 19

Combines like rows together

Question 20

SQL: ORDER BY OR SORT BY

Answer 20

Organizes the output by date, alphabetically, or numerically

Question 21

SQL: Excel formulas formatting

Answer 21

Excel formulas such as count, sum, etc start the formula without an equals sign.

Question 22

SQL: JOIN

Answer 22

Used when 2 or more tables are used, and the same data is in both tables

Question 23

REA Diagrams

Answer 23

Shows how databases relate and link together. Used to communicate between accounting and IT departments.

Question 24

In what format do databases store information?

Answer 24

Table format

Question 25

Risk level of database risks

Answer 25

High risk