Skip to content

Search

Find a program, subject or material type

CACS205 · Web Technology · Notes

Chapter 6: Working with Databases

Short, exam-focused notes · 15 pages · Updated Jun 6, 2026

Download

In this chapter

You will learn what working with databases means in Web Technology, why it matters, and how it is asked in TU exams.

1. What is Working with Databases?

Working with Databases is one of the building blocks of Web Technology. In simple words, it describes how a system is organised and how its parts work together to solve a real problem. Understanding this chapter makes the later chapters much easier.

Think of it like planning a building: before laying bricks, you need a clear plan. Working with Databases gives you that plan, so every later step has a solid base.

2. Key points to remember

  • Working with Databases breaks a large problem into smaller, manageable parts.
  • Each part has a clear role and a clear way of talking to other parts.
  • Good design reduces errors and makes changes easier later.
  • Most exam questions ask you to define, explain with an example, and give advantages.

3. Types and comparison

TypeUsed forMain benefit
BasicSmall and simple problemsEasy to understand
StructuredMedium-sized systemsClear organisation
AdvancedLarge real-world systemsScales well

4. Example

Consider a college library. Books, students and loans are separate parts. Working with Databases helps us decide how these parts are stored, linked and updated when a student borrows or returns a book.

5. Advantages and limitations

  • Makes the system easier to maintain
  • Improves accuracy and consistency
  • Can take more time to plan at the start
  • Needs practice to apply well

Exam tip

This chapter carries around 10 marks in most years. Always draw a diagram and give one real example.