Brainscape's Knowledge GenomeTM

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


See full index

ISTM 210 > Chapter 15 - Exam 3 > Flashcards

Chapter 15 - Exam 3 Flashcards

1
Q

A well thought out collection of computer files is known as a ___

A

Database

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

What is another name for fields in a database? (answer is not “columns”)

A

Attributes

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

DBMS stands for what? What is it used for?

A

Database Management System

-creates databases

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

Relational Database

A

Within a database:

-tables linked together by Primary and Foreign Keys

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

World’s first databases?

A

Filing Cabinets

-organized on “set of rules” just like databases today

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

Form - database term

A

Combines both database tables and queries for more specific view on data

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

Report - database term

A

Is the database information displayed on your screen

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

Another name for Tables (of databases) is what?

A

Files

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

What is a map of database tables that shows their relationship to one another detailing one-to-one, one-to-many, and many-to-many relationships?

A

ER

-Entity Relationship Diagram

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

The process of constructing an ER by incorporating conceptual and theoretical representations of the data is know as what?

A

ERM

-Entity Relationship Modeling

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

What is a map of database tables that shows their relationship to one another detailing primary and foreign keys in each of the tables?

A

Map Schema

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

Data Validation

A

When rules are set requiring data be entered in specific format

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

What do all DBMS need to work?

A

Data Validation

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

Who is responsible for the security of the Database?

A 
Human Resources (HR)
 -set limit to what people can/cannot see
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Data Redundancy

A

is when attributes (fields) appear in more than one table in the database

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

Who first proposed the Relational Database Model and what year was it?

A

Edgar F. Codd in 1970s

17
Q

SQL stands for what? Used for what?

A

Structured Query Language used for Relational Databases

18
Q

2 things that SQL can be used for are

A
  • to locate items, customers who.., location (querying) (SEARCH)
  • to update items (UPDATE)
19
Q

What is significant about Oracle?

A

Most used database in the world

20
Q

___ is a business social networking site

A

LinkedIn

21
Q

___ are used to find specific populations in a database

A

Queries

22
Q

Describe an Entity - Database term

A

-anything that company wishes to store data on (customer, classroom, shipping info)

23
Q

What is the thing that links tables together in a database?

A

Foreign Key

24
Q

A normalized database is one that does not contain any of the 3 anomalies. What are they and describe each?

A

UPDATE Anomaly
-problem that occurs when you try to update redundant data
DELETE Anomaly
-problem that occurs when you try to delete info about an entity and end up deleting entire record or entity
INSERT Anomaly
-putting partially complete data into a database

25
Q

CRN

A

Course Registration Number

-A&M didn’t have this in database couple years ago

26
Q

Why did Phinney make her kid learn Spanish instead of French?

A

Wanted him to learn Latin Roots

27
Q

The database shown in class by Phinney displayed information on ___

A

Vet Clinic in River Oaks Houston

28
Q

In the Business Scenario:

How was Zach’s initial system of creating/storing REO fact sheets made up?

A
  • Document for each REO fact sheet “3455.docx”
  • Document containing all REO sheets reference numbers called “template.docx”

All documents stored in REO Documents folder

29
Q

In the Business Scenario:

Why did Zach want to change up his original filing system of the REO fact sheets?

A

Boss informs Zach that Executive President want every REO sheet updated

30
Q

In the Business Scenario:

After Zach’s boss tells him to update all REO sheets, he goes to Abby for advice. What does she suggest first?

A

Mail-Merge

Tells Zach to put all REO fact sheets in one sheet called “Information.docx”
Tells Zach he can update all REO sheets at once indirectly through a different Document called “Template.docx”

31
Q

In the Business Scenario:
After Abby suggested Mail-Merge for Zach’s problems, he creates a Database instead. What does Abby show him that allows him to correct and eliminate future mistakes?

A

Input-Mask

-requires data be entered in specific format

32
Q

In the Business Scenario:
How many properties did Zach have to manage?
What does REO stand for?
How many facts does each REO sheet contain?

A
  • 500 Properties
  • REO (Real Estate Owned)
  • 75 facts to each REO Sheet
33
Q

In the Business Scenario:

After Zach creates the database, how does he save the company time and money?

A

Time
-updates all REO sheets at once
Money
-sends REO sheets out to co-workers instead of printing

34
Q

In the Business Scenario:

Why did Zach’s co-workers and bosses not notice 100 properties in the database he created?

A

“Complete or Incomplete” filter was enabled

35
Q

Append - Database Term

A

Finding existing information in a database and adding it to a table

ISTM 210 (10 decks)

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