Normalisation

Description

Describing 1st to 3rd Normal form in Databases
tosepage
Note by tosepage, updated more than 1 year ago
tosepage
Created by tosepage over 10 years ago
25
0

Resource summary

Page 1

1st Normal Form No repeating Groups (no arrays) All data is atomic Has primary key (No repeated tuples)

2nd Normal form In first normal form No Partial Dependencies

Partial Dependencies: This is when non-key attributes are dependent on part of a composite key in a relation. This only applies to tables with composite keys (more than 1 primary key).

New Page

Show full summary Hide full summary

Similar

Cell Biology
foleyshannon0
Unit 5: Evolution
Gurleen Dhillon
Chemistry 5 Cracking Hydrocarbons GCSE Core
Chloe Roberts
Comparative Vs. Superlative - Grade 5
Stephanie Constantino
traveller 5 vocabulary
siham
Punctuating Dialogue - Grade 5
Stephanie Constantino
Context Clues
Stephanie Constantino
Mechanics-Chapter 5-Moments
Thomas Marshall
Identify Parts of Speech - Grade 5
Stephanie Constantino
Computer Networking Quiz 4, 5, 6
Genardas Janonis
Coordinating and Subordinating Conjunctions - Grade 5
Stephanie Constantino