Database Management System (DBMS)

Accounts · Chapter 14 · 7. Database Management System (Section C)

Not started Not started

Your path through this chapter

1
Visual lesson Beta
1. Part 1: Concepts, Types, Features and Database Design21 slides
2. Part 2: SQL, Aggregate Functions and DBMS in Business20 slides
Step 1: Not started
Notes Beta
8 sections with key terms, formulas and exam tips.
Read the notes Step 2: Not started
Flashcards Beta
30 cards for quick recall of key terms and facts.
Review the cards Step 3: Not started
Practice
86 board-style questions with instant checks: Multiple choice 27, Short answer 23, Assertion and reason 7, Long answer 7.
Practise Step 4: Not started
5
Chapter test Free
Short and long chapter tests in board pattern, with results and analysis.
- Chapter test (long) — Database Management System · 40 marks · 100 min
- Chapter test (short) — Database Management System · 20 marks · 50 min
Step 5: Not started

DBMS: concept, types and features
SQL basics: SELECT, WHERE, AND, OR, UPDATE, DELETE
SQL aggregate functions: AVG, COUNT, MAX, MIN, SUM
Database design: tables, fields, relationships, forms, reports and indexing
DBMS in business: accounting information, debtors and creditors, bank reconciliation, asset accounting