Create a Database Structure

Revise Create a Database Structure for ICT 0417 (O Level) — revision notes and instant AI marking.

📖 Revision notes · preview

Create a Database Structure

Master the art of organizing data with relational databases, keys, calculations, and effective form design.

💾 Database Types

Flat file databases store everything in one table; relational databases use multiple tables with relationships.

🔑 Keys Matter

Primary keys uniquely identify records; foreign keys link tables together and reduce data redundancy.

📊 Calculations

Use formulas and aggregate functions to calculate field values and extract statistical insights from data.

🔍 Sorting & Searching

Organize data in ascending/descending order; use queries with criteria and wildcards to find specific information.

📋 Form Design

Create user-friendly forms with clear labels, logical grouping, appropriate spacing, and helpful controls.

1. Types of Database

What is a Database?

A database is a structured, persistent collection of data that allows easy storage, retrieval, and management of information. Think of it like a super-organized filing cabinet that can instantly find what you're looking for and update multiple files at once.

Key benefits of electronic databases:

Easier to add, delete, modify, and update data
Data can be backed up and copied easily
Multiple users from multiple locations can access the same database simultaneously
Reduces data redundancy (avoiding duplicate information)
Minimizes data inconsistency

Flat File Databases

A flat file database stores all data in a single table. It's simple and easy to understand, but it causes serious problems as data grows.

Example: Student Registration (Flat File)

ID	First Name	Last Name	Personal Tutor	Form Room
1	Sam	Smith	Roger Hinds	6b
2	Fred	Lynch	Jess Little	8j
3	Depak	Noor	Roger Hinds	6b
4	Archie	Henns	Mary Kent	8k

Problem: Notice how "Roger Hinds" and "6b" are repeated. If Roger Hinds changes rooms, you'd have to find and update every single instance — miss one, and your data becomes inconsistent!

Problems with flat file design:

Data redundancy: The same information (like a tutor's name) is repeated multiple times
Inefficient storage: You're wasting space by storing duplicate data
Hard to maintain: Updating information means finding and changing it in multiple places

🔓 Read the full Create a Database Structure note → You're seeing the preview · sign in to read it all

Also in the full note

2. Tables, Records, Fields & Keys
3. Perform Calculations
4. Sorting & Searching Data
5. Form Design
What to Memorise
Concepts Checklist
Exam Tips & Common Mistakes
Relational Databases

What's inside

📖 Revision notes 🎯 Learn mode ✦ AI flashcards ✓ Instant AI marking 🧊 3D explorers 🧪 Experiments & simulations 📈 Progress tracking

📄 Practise Create a Database Structure with ICT 0417 past papers Every paper with its mark scheme — answer online, marked instantly. Open →

Read the full Create a Database Structure notes free

That's the preview — create a free account to read the rest, plus flashcards and practice questions with instant AI marking. No credit card.

Unlock the full notes free →

Create a Database Structure