Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

ISTM 210 > chapter fifteen > Flashcards

chapter fifteen Flashcards

1
Q

tables

A

where a database holds data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

records

A

rows

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

fields

A

columns

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

queried

A

questioned

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

database management systems (DBMS)

A

software systems used to make databases

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

relational database

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

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

A

always distributed

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

how do the first database management systems resemble filing cabinets?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

reports

A

display database information on screen or on paper

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

saved query files

A

used to find specific populations (subsets) within databases

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

forms

A

overlay data tables and queries for more specific views of data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

entity relationship diagrams

A

how database designers construct databases

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

entity relationship modeling

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

database scema

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

database designers need to ___ _ _____.

A

know a business

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

attributes

A

first names, last names, addresses included as fields

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

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

A

expectations

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

how is database software different from word processors or spreadsheets?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

data validation rules

A

help to ensure the data’s integrity

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

data integrity techniques attempt to

A

avoid data input errors like typing mistakes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

what helps to avoid data redundancy?

A

a structured, well thought-out database management system

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

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

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

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

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

how can you reduce reconciliation errors?

A

avoiding data redundancy

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

how can different levels of security be implemented?

A

by determining who gets to see what in a business environment

26
Q

structured query language (sql)

A

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

27
Q

data is

A

fluid, it changes all the time

28
Q

how can you add and delete books?

A

append, delete, and update queries

29
Q

update query

A

update results to be accurate

30
Q

zach

A

considered good at his job

in charge of compiling facts and information on his bank’s foreclosed and real estate

31
Q

when zach first started he had about 50 properties in foreclosure

A

his job was manageable

32
Q

one of zach’s job was to produce an “REO Fact Sheet” for each and every property

A

“Real Estate Owned”

33
Q

the REO fact sheet has 75 individual facts about..

A

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

34
Q

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

A

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

35
Q

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

A

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

36
Q

how did zach organize the word documents?

A

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

37
Q

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

A

in an “REO Documents” folder on his personal computer’s hard drive

38
Q

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

A

infinitely easier than searching through a filing cabinet of typewritten documents

39
Q

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

A

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

40
Q

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

A

“Save As”

41
Q

the finance department used the fact sheets to compile numbers like

A

“Total Bank Owned Property Value”

42
Q

zach had two separate folders

A

100 in “incomplete” and 400 “complete”

43
Q

as an REO Fact Sheet became complete, Zach would simply

A

drag the document from the incomplete to the complete folder

44
Q

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

A

“mail merge”

45
Q

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

A

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

46
Q

information.docx disadvantages

A

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

47
Q

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

A

add a row in the excel spreadsheet

48
Q

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

A

a database like Microsoft access

49
Q

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

A

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

50
Q

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

A

“REO”
“Properties”
“Complete or Incomplete”

51
Q

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

A

some of the zip codes had four digits instead of five

52
Q

field mask

A

restrict data input

53
Q

schema

A

switch from view mode to design mode

54
Q

form

A

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

55
Q

zach’s new form would look exactly like

A

the REO fact sheet

56
Q

should zach print the forms of REO fact sheets?

A

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

57
Q

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

A

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

58
Q

filtering

A

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

59
Q

any REO without complete information was..

A

hidden from all users and all reports

60
Q

what was asked of zach by the bank executives?

A

to remove the filter from the “complete and incomplete” field

ISTM 210 (23 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions