Databases
The Relational Model, Keys, Normalization, and SQL
Model structured data and express questions using relational operations.
0/6Articles read
0/18Latest correct answers
18Unanswered questions
0Due for review
Loading learning records…
Readings and practice
Referential integrity: preventing references to missing rows
Unread · Latest correct 0/3
Practise these questionsAnswer history and review dates
Question 1
Not yet answered
Question 2
Not yet answered
Question 3
Not yet answered
Reason about SQL rows, joins, and aggregates
Unread · Latest correct 0/3
Practise these questionsAnswer history and review dates
Question 1
Not yet answered
Question 2
Not yet answered
Question 3
Not yet answered
Functional dependencies: a determinant fixes a value
Unread · Latest correct 0/3
Practise these questionsAnswer history and review dates
Question 1
Not yet answered
Question 2
Not yet answered
Question 3
Not yet answered
Normal forms: reduce update redundancy using dependencies
Unread · Latest correct 0/3
Practise these questionsAnswer history and review dates
Question 1
Not yet answered
Question 2
Not yet answered
Question 3
Not yet answered
OLTP versus OLAP
Unread · Latest correct 0/3
Practise these questionsAnswer history and review dates
Question 1
Not yet answered
Question 2
Not yet answered
Question 3
Not yet answered
Design decomposition and constraints from functional dependencies
Unread · Latest correct 0/3
Practise these questionsAnswer history and review dates
Question 1
Not yet answered
Question 2
Not yet answered
Question 3
Not yet answered