M6 Flashcards
is an ordered collection of information from which a computer program can quickly access
database
Information stored in computer databases is actually stored in _______ similar to spreadsheet.
tables
a single complete set of related information
record
are the individual categories of information stored in a record
fields
Stores information across multiple related tables.
Composed of Primary Table and Related Table
relational database
is a field that contains a unique identifier for each record in a primary table
primary key
is a field in a related table that refers to the primary key in a primary table
foreign key
is the process of breaking tables into multiple related tables to reduce redundant information
normalization
is a structured set of instructions and criteria for retrieving, adding, modifying, and deleting database information
query
used for creating queries
data manipulation language (DML)
has a standard data manipulation language among many database management system
structured query language (SQL)
An Australian academician who wrote a very lightweight database engine called mSQL
David Hughes
mSQL was distributed as _________
shareware
improvement was done by a Swedish programmer _____________
Monty Widenius
rapidly grew until, although it’s still a fast, light database, it’s also a pretty powerful one; written in C++, compiles using GNU gcc, and is pretty portable
MySQL
