Please enable JavaScript.
Coggle requires JavaScript to display documents.
Section 10: Databases - Coggle Diagram
Section 10: Databases
normalisation
-
-
-
-
third normal form
-
database must also not have any non-key dependencies, so all non-key attributes must depend on a key attribute
entities and attributes
-
entity identifiers
-
some database tables have multiple attributes which are combined to form the table's entity identifier
-
composite primary keys
if it is not possible to form a primary key from one attribute, multiple attributes are combined to make a composite primary key
-
-
relational databases
-
a relational database contains tables that are related to each other, as they are linked by common attributes