chapter fifteen

Question 1

tables

Answer 1

where a database holds data

Question 2

records

Answer 2

rows

Question 3

fields

Answer 3

columns

Question 4

queried

Answer 4

questioned

Question 5

database management systems (DBMS)

Answer 5

software systems used to make databases

Question 6

relational database

Answer 6

data is stored in computer files called tables, and tables are connected to other tables with related information

Question 7

business databases are ____ _____ on a computer network for multiple users

Answer 7

always distributed

Question 8

how do the first database management systems resemble filing cabinets?

Answer 8

three drawers marked with alphabetical characters
alphabetical tabs separate folders
folders contain information

Question 9

reports

Answer 9

display database information on screen or on paper

Question 10

saved query files

Answer 10

used to find specific populations (subsets) within databases

Question 11

forms

Answer 11

overlay data tables and queries for more specific views of data

Question 12

entity relationship diagrams

Answer 12

how database designers construct databases

Question 13

entity relationship modeling

Answer 13

a database-modeling method used to construct a theoretical and conceptual representation of data to produce a schema

Question 14

database scema

Answer 14

a “map” of data tables and their relationships to one another

Question 15

database designers need to ___ _ _____.

Answer 15

know a business

Question 16

attributes

Answer 16

first names, last names, addresses included as fields

Question 17

database designers also need to know what a business’ ______ are of its DBMS.

Answer 17

expectations

Question 18

how is database software different from word processors or spreadsheets?

Answer 18

they require end users to create their own files starting with tables and then relating them to each other

Question 19

data validation rules

Answer 19

help to ensure the data’s integrity

Question 20

data integrity techniques attempt to

Answer 20

avoid data input errors like typing mistakes

Question 21

what helps to avoid data redundancy?

Answer 21

a structured, well thought-out database management system

Question 22

what can be both an advantage and a disadvantage of a database?

Answer 22

a person’s unique information like name and address information resides in just one place in the entire DBMS

Question 23

how can a name in just one place in the database be a bad thing?

Answer 23

if the name is wrong once, it is wrong in every form and report

Question 24

how can you reduce reconciliation errors?

Answer 24

avoiding data redundancy

Question 25

how can different levels of security be implemented?

Answer 25

by determining who gets to see what in a business environment

Question 26

structured query language (sql)

Answer 26

the most widely used standard computer language for relational databases as it allows a programmer to manipulate and query data

Question 27

data is

Answer 27

fluid, it changes all the time

Question 28

how can you add and delete books?

Answer 28

append, delete, and update queries

Question 29

update query

Answer 29

update results to be accurate

Question 30

zach

Answer 30

considered good at his job | in charge of compiling facts and information on his bank's foreclosed and real estate

Question 31

when zach first started he had about 50 properties in foreclosure

Answer 31

his job was manageable

Question 32

one of zach's job was to produce an "REO Fact Sheet" for each and every property

Answer 32

"Real Estate Owned"

Question 33

the REO fact sheet has 75 individual facts about..

Answer 33

each property like REO number, property name, address, property type, property value and is distributed bank wide

Question 34

when zach first started, he took over for a person who was actually producing the fact sheets on a typewriter; so, he transferred the information to microsoft word documents

Answer 34

it was a chore to hand-type the information into Word and make sure it was accurate, he knew it would make his business process more efficient in the long run

Question 35

zach considered scanning the old documents with OCR technology but decided hand typing would be best

Answer 35

now that he had the fact sheets in word processing documents, he could be more organized

Question 36

how did zach organize the word documents?

Answer 36

he named his Word documents after the property's REO number, like 121714.docx

Question 37

where did zach save all the REO Fact Sheet Word documents?

Answer 37

in an "REO Documents" folder on his personal computer's hard drive

Question 38

zach's Windows Explorer allowed him easy searching and sorting capabilities so accessing a fact sheet became

Answer 38

infinitely easier than searching through a filing cabinet of typewritten documents

Question 39

when zach had to start a new fact sheet, which was unfortunately becoming more and more frequent

Answer 39

he was able to access a blank REO Fact Sheet template on his local hard drive he'd named "template.docx"

Question 40

zach simply inserted a new property's information in the template and used the _______ function in Word to name the new document file after its associated REO number

Answer 40

"Save As"

Question 41

the finance department used the fact sheets to compile numbers like

Answer 41

"Total Bank Owned Property Value"

Question 42

zach had two separate folders

Answer 42

100 in "incomplete" and 400 "complete"

Question 43

as an REO Fact Sheet became complete, Zach would simply

Answer 43

drag the document from the incomplete to the complete folder

Question 44

Abby at the bank's Information Technology department suggested zach try the ________ function

Answer 44

"mail merge"

Question 45

Abby gave Zach something else to consider: instead of having one Microsoft Word file merging with another Microsoft Word file, why not have

Answer 45

the Microsoft Word template.docx merge with a Microsoft Excel spreadsheet?

Question 46

information.docx disadvantages

Answer 46

the file size would be extremely big, the data is in no particular order and typically its data is arranged somewhat awkwardly

Question 47

how would zach enter a new REO foreclosed property into a spreadsheet?

Answer 47

add a row in the excel spreadsheet

Question 48

the real answer to zach's dilemma was to transfer all 500 REO document's data to

Answer 48

a database like Microsoft access

Question 49

Abby mentioned that information this sensitive was probably better suited on..

Answer 49

one of the network's drives where network administrators could make sure it was backed up on a regular basis

Question 50

Abby had named the database ___ and the data table _______, there was also an included extra column in the data table called ________ __ _______.

Answer 50

"REO" "Properties" "Complete or Incomplete"

Question 51

abby mentioned that there were what kind of errors in the database?

Answer 51

some of the zip codes had four digits instead of five

Question 52

field mask

Answer 52

restrict data input

Question 53

schema

Answer 53

switch from view mode to design mode

Question 54

form

Answer 54

overlaid the data table to show information in a more organized manner

Question 55

zach's new form would look exactly like

Answer 55

the REO fact sheet

Question 56

should zach print the forms of REO fact sheets?

Answer 56

no, they could be distributed completely electronically through the bank's network

Question 57

zach's REO database was quickly becoming a colossal money-saver for the bank

Answer 57

he had eliminated enormous amounts of distribution, reconciliation, and duplication of efforts

Question 58

filtering

Answer 58

the ability to add a filter to a data table that would only display specific information

Question 59

any REO without complete information was..

Answer 59

hidden from all users and all reports

Question 60

what was asked of zach by the bank executives?

Answer 60

to remove the filter from the "complete and incomplete" field