- Foundation
- About 11 min
- 5 practice questions
Data, database and DBMS
Define a database and a DBMS and explain why they replace scattered paper or file records.
If something looks wrong, please tell us.
Schools, banks, railways and shops all keep huge amounts of records. A database is the organised way they store and find that information quickly and safely.
Definitions
A database is an organised collection of related data stored so it can be easily accessed, managed and updated. A Database Management System (DBMS) is the software that creates the database and lets users store, retrieve, change and protect the data. Examples of DBMS software are MySQL, Oracle, PostgreSQL and Microsoft Access.
Problems with plain files
- Redundancy: the same data repeated in many files, wasting space.
- Inconsistency: one copy updated and another forgotten, so they disagree.
- Hard to search: finding a record may mean reading many files.
- Weak security: difficult to control who sees what.
- Hard to share: many users editing together causes clashes.
Advantages of a DBMS
- Less redundancy and better consistency.
- Quick searching and reporting.
- Data security with user permissions.
- Shared access for many users at once.
- Backup and recovery support.
- Data integrity: rules that keep data correct.
Worked examples
Example 1. A school keeps a student's address in the library file, the fee file and the exam file. A student moves house and only the fee file is updated. What problem arises? Data inconsistency: three records now disagree.
Example 2. If a database stores the address once and other tables refer to it, a single update corrects it everywhere. This is how a DBMS reduces redundancy.
Database = organised data. DBMS = software that manages the database.
Key takeaways
- A database stores organised data; a DBMS manages it.
- A DBMS reduces redundancy and inconsistency and adds security.
Check your understanding
-
1. What is a Database Management System (DBMS)?
- Software that creates a database and lets users store, retrieve, change and protect its data
- A printed register of records kept in an office
- A storage device that holds files permanently
- A single spreadsheet with no rules
Show answer
Answer: A. A DBMS is the software; the database is the organised data it manages.
-
2. The same customer address is stored in three separate files. What is this repetition called?
- Integrity
- Redundancy
- Authorisation
- Recovery
Show answer
Answer: B. Repeating the same data in many places is redundancy; it wastes space and invites mistakes.
-
3. A student's address is changed in the fee file but not in the library file, so the two files disagree. What is this problem called?
- Data security
- Data backup
- Data inconsistency
- Data sharing
Show answer
Answer: C. When copies of the same data disagree, the data is inconsistent.
-
4. Which of these is DBMS software?
- Microsoft Paint
- Google Chrome
- Windows Media Player
- PostgreSQL
Show answer
Answer: D. PostgreSQL is a DBMS, like MySQL, Oracle and Microsoft Access. The others are a drawing program, a browser and a media player.
-
5. Which is NOT an advantage of a DBMS over separate plain files?
- More copies of the same data in many places
- Backup and recovery support
- Shared access for many users at once
- Data security with user permissions
Show answer
Answer: A. A DBMS reduces repeated copies; more copies is the redundancy problem of plain files.
Sign in to keep track of the lessons you finish.