Basic Architecture RDBMS Flashcards
What term can be used for “tables”?
Relations
What does a table contain?
attributes, fields
What terms can be used for “rows”?
records, tuples
What is a row?
data record within a table
What terms can be used for “columns”?
fields, attributes
What is a column?
set of data values of a particular type;
one value for each row
How many candidate keys can be in a table?
one or more
How many primary keys can be in a table?
one (set by designer)
Candidate Key
uniquely identifies any record in a table
Primary Key
selected from the candidate keys to uniquely identify the records
What is a Foreign Key used for?
Other definition of Foreign Key?
relationship between two tables;
aka referential integrity
Six common RDBMS threats / attacks
aggregation, inference, SQL injection, TOC/TOU, backdoor, DoS
Aggregation
creates sensitive information by combining non sensitive information
Inference
Deduction (verb = deduce) by observing non sensitive pieces / information
–> Key word: Deduction
