ICT - Databases

Databases

Flat File

• All information is stored in one large table.
• This means that data has to be repeatedly entered if it appears again, e.g. if a patient makes another dentists appointment.
• Repeatedly entering unnecessary information is called data duplication.
• This allows room for mistakes.

Relational Database

• Instead of having different columns containing information (e.g. name, age, address, etc), the different categories are presented as seperate table.
• These tables are linked together so that data does not have to be entered again.

DBMS

Database Management System

"A database management system (DBMS) is system software for creating and managing databases…