Designing Database Tables (Grade 11 NSC Matric Computer Application Technology): Flashcards
📚Flashcards
Practise the cards
10 cards from this deck
ShowHide
Practise the cards
10 cards from this deck
Two main principles of good database design
Two main principles of good database design
No redundant data; Correct and complete information
What is redundant data?
What is redundant data?
Same information appearing in multiple places in database
4 planning steps for database structure
4 planning steps for database structure
Purpose, identify info, organise by subject, design tables
Input mask character: 0
Input mask character: 0
Required digit (0-9), no signs allowed
Input mask character: L
Input mask character: L
Required letter (A-Z)
Input mask character: >
Input mask character: >
Converts following characters to uppercase
Date format in Access validation rules
Date format in Access validation rules
yyyy/mm/dd enclosed in hash symbols (#)
Validation rule: only positive numbers
Validation rule: only positive numbers
0
Validation rule: text starting with G
Validation rule: text starting with G
Like "G*"
Purpose of validation text
Purpose of validation text
Error message when user enters data violating validation rule