Building Blocks: Fields, Records, and Tables
Discover the core components of a database: tables, records, and fields. Learn how to define the structure for storing specific types of information.
About This Topic
Discover the core components of a database: tables, records, and fields. Learn how to define the structure for storing specific types of information.
Key Questions
- Explain the relationship between fields, records, and tables in a database.
- Identify appropriate data types, such as Text, Number, or Date/Time, for different fields in a school library database.
- Justify the importance of selecting a primary key for a table to uniquely identify each record.
Active Learning Ideas
See all activities→Activities & Teaching Strategies
See all activities
More in Databases
What is a Database?
Learn what a database is, why it's a powerful tool for organising information, and explore examples of databases you use every day.
8 methodologies
Entering and Managing Data
Practise adding, editing, and deleting information in a database. Explore how to use forms for easier data entry and the importance of keeping data accurate.
8 methodologies
Asking Questions: Simple Queries
Uncover the power of queries to search for and retrieve specific information from your database by setting clear criteria.
8 methodologies
Presenting Your Findings: Creating Reports
Learn to design and generate professional-looking reports to present and summarise the information from your database tables and queries.
8 methodologies