Flashcards
Database Hell
Cards in this deck (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
Information
- Description
- Year 10 Computing Flashcards on Database Hell, created by Rubber_ Ducky122 on 15/02/2019.
- Created by
- Rubber_ Ducky122
- Views
- 0
- Rating