Chapter 5

Question 0

Database

Answer 0

Self describing collection of integrated records

Spreadsheet: lists that involve a single theme
Database: lists that involve multiple themes (e.g. grades, emails, office visits)

Question 1

Content management (CMS)

Answer 1

Info system that tracks organizational documents, webpages, graphics and related materials

Question 2

Another word for columns

Answer 2

Fields

Question 3

Another word for rows

Answer 3

Records

Question 4

A group of similar rows or records

Answer 4

Table/ file

Question 5

Key

Answer 5

Column/ groups of columns that identify a unique row in a table

Question 6

Foreign keys

Answer 6

Columns that fulfill a role

Question 7

Relational databases

Answer 7

Databases that carry their data in the form of tables and represent relationships using foreign keys

Question 8

Relation

Answer 8

Formal name for a table

Question 9

Components of a database application system

Answer 9

User-> database application-> database management system-> database

Question 10

Database application

Answer 10

Consists of forms, formatted reports, queries and application programs

Question 11

Database management system (DMS)

Answer 11

Programs used to create, process and administer a database

Question 12

Structured query language (SQL)

Answer 12

International standard language for processing a database

Question 13

Data entry forms

Answer 13

Used to read, insert, modify and delete data

Question 14

Reports

Answer 14

Show data in a structured context

Question 15

Query

Answer 15

Request for data from a database

Question 16

Multiuser processing

Answer 16

When multiple users process the database at the same time

Question 17

Lost- update problem

Answer 17

Issue in multiuser database processing in which 2 or more users try to make changes to the data but the database cannot make all the changes because it was not designed to process changes from multiple users

Question 18

Enterprise DBMS

Answer 18

One of the 2 broad categories that DBMS products fall into; processes large organizational and workgroup databases, supports many users and different database applications, operates 24/7 operations and manages data that spans dozens of different magnetic disks with hundreds of gigabytes or more of data

Question 19

Personal DBMS

Answer 19

One of the 2 broad categories DBMS products fall into; designed for smaller, simpler database applications, used for personal/ small workgroup applications that involve fewer than 100 users and normally fewer than 15 (most only have 1.) The only one remaining is Microsoft Access.

Question 20

Components of a personal database application system

Answer 20

User-> DBMS & application -> DB
(With forms
reports
queries
application code)

Question 21

Components of a database

Answer 21

Tables/ Files + Relationships among rows in tables + Metadata