Designing Database Tables (Grade 11 NSC Matric Computer Application Technology): Flashcards

Two main principles of good database design

No redundant data; Correct and complete information

What is redundant data?

Same information appearing in multiple places in database

4 planning steps for database structure

Purpose, identify info, organise by subject, design tables

Input mask character: 0

Required digit (0-9), no signs allowed

Input mask character: L

Required letter (A-Z)

Input mask character: >

Converts following characters to uppercase

Date format in Access validation rules

yyyy/mm/dd enclosed in hash symbols (#)

Validation rule: only positive numbers

0

Validation rule: text starting with G

Like "G*"

Purpose of validation text

Error message when user enters data violating validation rule