Front | Back |
Spreadsheet
|
Not
as interactive, single themed if the list is simple
|
Database
|
Self
describing collection of integrated records (contains metadata- data that describes data), Self
describing- tells you what each field is, contains metadata
|
Primary key
|
Unique
identifier, every table has a key
|
Foreign key
|
Same
name of primary key in another table
|
Entity
|
What
you keep track of; singular not plural
|
Attribute
|
Describes
the entity; characteristics of entity
|
Field
|
Columns
in the table
|
Record
|
Rows
in the table
|
Table
|
Group
of similar rows and records, every table has a key
|
DBMS
|
Software/program, tracks problems and manages solutions, processes database into tables and breaks data into forms for processing, licensed by companies (you don't own it), sets up security system (accounts, passwords, permission, limits), uses SQL, data application, locking
|
SQL
|
Structured query language, an international standard for processing data, Add data structure to improve performance; keeps
everything organized and in same language
|
Data application
|
Collection
of forms to update, add, insert, delete data
|
Permission
|
Allows
for special access
|
Limit
|
Create
a ceiling/floor that established a max/min
|
Event programming
|
Clicking
mouse or pressing enter key
|