One
Two
Three
Four
100
What would we call a collection of related data?
A database
100
What type of file has data separated by a character such as a comma or a Tab or a pipe (|)?
A delimited file or a comma delimited file (.csv)
100
What do we call a limit on what the database will do?
a constraint
100
Name three relational database products.
Microsoft Access / Microsoft SQL Server / Oracle / MySQL
200
What are two of the things that a Statement of Work should include?
A history / A scope / Objectives / Tasks and timeline
200
Who said "The thing about trains... it doesn't matter where they're going. What matters is deciding to get on."
The Conductor on the Polar Express
200
What database design is designed with a tree-like structure that resembles a file system?
Hierarchical
200
What do we call something a database must do to fulfill its business function?
A database requirement
300
How many reindeer pull Santa's Sleigh?
Eight.
300
What is the gift on the 11th day?
11 pipers piping
300
What will put your eye out?
Red Ryder BB gun
300
What happens every time a bell rings?
An angel gets wings.
400
What is the language relational databases use to create database objects and to manipulate and retrieve data.
Structured Query Language (SQL)
400
Who defined the core principles of a relational database in 1970?
E.F. Codd
400
In an ER diagram, which notation conveys more information about the relationships?
Crows Feet Notation
400
In a database, what would we call the same data recorded in more than one place?
data redundancy
500
What is it that must uniquely identify each record in a table?
A primary key
500
What is the primary key of one table repeated in another table in order to create a relationship between the tables?
A foreign key
500
What is the information stored about data in a database called?
Metadata
500
What do we call the accuracy and correctness of the data in the database?
Data Integrity
M
e
n
u