Relational Database

MIS Exam 2

36 cards   |   Total Attempts: 188
  

Related Topics

Cards In This Set

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