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
