Domain 8: Databases Flashcards
Controls all access to the database and enforces the database security
Database Management System (DBMS)
- Allows for searching within a database
- i.e. Structured Query Language (SQL)
Query language
- Creates relationships between records in tables by using a primary key
- Contains two-dimensional tables made up of rows and columns
Relational database
Another name for a table
Relation
Row in a database
Tuple
Database column
Attribute
Single cell in a database
Value
Contains the data in a database
Cell
- Selected from the set of candidate keys inside a table
- Used to uniquely identify the records in a table
- Relational databases require unique value in each tuple in a table
Primary Key
Any attribute (column) in the table with unique values
Candidate Keys
- Key in a relational database table that matches a primary key in a parent database table
- Used to enforce relationships between two tables
Foreign Key
- Means that every foreign key in a secondary table matches a primary key in the parent table
- If not this is not true, integrity has been broken
Referential Integrity
Means each attribute (column) value is consistent with the attribute data type
Semantic Integrity
Means each tuple has a unique primary key that is not null
Entity Integrity
- Removes redundant data
- Purpose is to make data in a database table concise, organized and consistent
Database normalization