Relational Databases (AQA A-Level Computer Science): Flashcards

Data organized in linked tables with relationships

One record links to many; each links to only one

Use link table to break into two one-to-many relationships

Object/thing to store info about; becomes a table

Info about an entity; becomes a field/column in table

Attribute that uniquely identifies each record in a table

Attribute in one table that is primary key from another

No repeating groups; all data is atomic

In 1NF + non-key attributes depend on whole primary key

In 2NF + no non-key depends on other non-key attributes