Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
6 Cards in this Set
- Front
- Back
How to get from un-normalised form to 1st normal form? |
Remove repeating groups |
|
1st normal to second normal |
Remove partial dependency |
|
2nd to 3rd normal |
Remove transitive dependencies |
|
What is a functional dependency? |
Describes the relationship between two sets of attributes in a relation |
|
What is partial dependency? |
A non-key attribute is determined by a part but not the whole of a composite primary key |
|
What is transitive dependency |
An attribute is functionally dependent on an attribute that is not part of the primary key |