Karteikarten

Database Hell

Rubber_ Ducky122 Computing Year 10 Englisch 11 Karten

Karten in diesem Stapel (11)

1Flat FileIs When All the Data is Held In One Table
20NF (Zero Normal Form)An Un-normalized data base
3NormalizationIs a process used to create relational databases with no duplicate data
41NF (First Normal Form)Is A Table That Contains no repeating attributes or groups of attributes
52NF (Second Normal Form)A Table That is in 1NF and that has no partially dependencies (hence it must have a composite key)
63NF (Third Normal Form)A table that is in 2NF that has no key dependencies
7Entity Relationship DiagramsA graphical method of representing the relationships between entities such as
(One to One), (One to Many) and
(Many to Many)
8Foreign KeyAn Attribute that connects two tables together usually via the primary key of another table
9Primary KeyA unique code used to identify a specific table or array of information
10Composite Primary KeyA table containing two primary keys that link two tables together in order to remove reoccurring data in a table
11SQL

Beschreibung: Year 10 Computing Karteikarten am Database Hell, erstellt von Rubber_ Ducky122 am 15/02/2019.
Erstellt von: Rubber_ Ducky122
Aufrufe: 0
Bewertung