Flashcards
Database Hell
Flashcards do conjunto (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
Informações
- Descrição
- Year 10 Computing FlashCards sobre Database Hell, criado por Rubber_ Ducky122 em 15-02-2019.
- Criado por
- Rubber_ Ducky122
- Visualizações
- 0
- Avaliação