Chapter 15 - Exam 3 Flashcards by Jack Amheiser

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

Database

How well did you know this?

Not at all

Perfectly

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

Attributes

How well did you know this?

Not at all

Perfectly

DBMS stands for what? What is it used for?

Database Management System

-creates databases

How well did you know this?

Not at all

Perfectly

Relational Database

Within a database:

-tables linked together by Primary and Foreign Keys

How well did you know this?

Not at all

Perfectly

World’s first databases?

Filing Cabinets

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

How well did you know this?

Not at all

Perfectly

Form - database term

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

How well did you know this?

Not at all

Perfectly

Report - database term

Is the database information displayed on your screen

How well did you know this?

Not at all

Perfectly

Another name for Tables (of databases) is what?

Files

How well did you know this?

Not at all

Perfectly

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?

-Entity Relationship Diagram

How well did you know this?

Not at all

Perfectly

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

ERM

-Entity Relationship Modeling

How well did you know this?

Not at all

Perfectly

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

Map Schema

How well did you know this?

Not at all

Perfectly

Data Validation

When rules are set requiring data be entered in specific format

How well did you know this?

Not at all

Perfectly

What do all DBMS need to work?

Data Validation

How well did you know this?

Not at all

Perfectly

Who is responsible for the security of the Database?

Human Resources (HR)
 -set limit to what people can/cannot see

How well did you know this?

Not at all

Perfectly

Data Redundancy

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

How well did you know this?

Not at all

Perfectly

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

Edgar F. Codd in 1970s

SQL stands for what? Used for what?

Structured Query Language used for Relational Databases

2 things that SQL can be used for are

to locate items, customers who.., location (querying) (SEARCH)
to update items (UPDATE)

What is significant about Oracle?

Most used database in the world

___ is a business social networking site

___ are used to find specific populations in a database

Queries

Describe an Entity - Database term

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

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

Foreign Key

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

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

CRN

Course Registration Number | -A&M didn't have this in database couple years ago

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

Wanted him to learn Latin Roots

The database shown in class by Phinney displayed information on ___

Vet Clinic in River Oaks Houston

In the Business Scenario: | How was Zach's initial system of creating/storing REO fact sheets made up?

- 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

In the Business Scenario: | Why did Zach want to change up his original filing system of the REO fact sheets?

Boss informs Zach that Executive President want every REO sheet updated

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?

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"

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?

Input-Mask | -requires data be entered in specific format

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?

- 500 Properties - REO (Real Estate Owned) - 75 facts to each REO Sheet

In the Business Scenario: | After Zach creates the database, how does he save the company time and money?

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

In the Business Scenario: | Why did Zach's co-workers and bosses not notice 100 properties in the database he created?

"Complete or Incomplete" filter was enabled

Append - Database Term

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