Databases and Data (Grade 12 NSC Matric Computer Application Technology): Flashcards
📚Flashcards
Practise the cards
10 cards from this deck
ShowHide
Practise the cards
10 cards from this deck
Database definition
Database definition
Collection of related information that can be processed
Data integrity
Data integrity
How accurate and consistent information remains over time
Data redundancy
Data redundancy
Same information appearing in multiple locations in database
Four main database components in Access
Four main database components in Access
Tables, Forms, Queries, Reports
Primary key function
Primary key function
Uniquely identifies each record in a table
Tables in databases
Tables in databases
Store actual data in organised rows and columns
Forms in databases
Forms in databases
User-friendly interfaces that make data entry easier
Queries in databases
Queries in databases
Ask specific questions and retrieve targeted results
AND operator in queries
AND operator in queries
Returns results only when both conditions are true
OR operator in queries
OR operator in queries
Returns results when at least one condition is true