CH 15: Database

A name of a field is also called what?

Attribute

What was Zach's database "filter?"

Complete or Incomplete

The structure of a well thought-out DBMS helps avoid what?

Data Redundency

Insuring a field is populated with usable data is called what?

Data Validation

What software is a well thought-out collection of computer files, the most important of which are called tables?

Database

What is the most widely used database in the world?

Oracle

A map of a database that shows tables and relationships is called what?

Schema

What does the acronym SQL mean?

Structured Query Language

In the SQL Statement "FROM Book," Book refers to what?

Table

Where does a database hold data?

Tables

The most widely used query language for a DBMS is called what?

SQL

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

ERM

What do database designers use to construct databases?

Entity Relationship Diagrams

A column in a table is called what?

Field

In the SQL Statement "ORDER BY Title," Title refers to what? (Field)

Field

In the SQL Statement "SELECT Title," Title refers to what?

Field

In the SQL Statement "WHERE Price," Price refers to what?

Field

It can be argued that the first database management systems were what?

Filing Cabinets

Why did Zach's database not show all REOs?

Filter

What overlays a table for a more specific view?

Form

What database did Zach choose?

Microsoft Access

What software did Abby's first suggest after Microsoft Word?

Microsoft Excel

What software did Zach use originally?

Microsoft Word

What is used to find specific populations within a database?

Queries

Which is not an SQL function?

RELAY

What does the acronym REO mean?

Real Estate Owned

A row in a table is called what?

Record

"One-to-many" is an example of what?

Relationship