2.2 Database Management Systems (DBMS)

• explain the importance of DBMS productivity tools in data management
• select DBMS productivity tools to manage data
• use DBMS productivity tools to manage data
• appreciate the role of DBMS productivity tools in managing data

“Why are database productivity tools better than other productivity tools in managing data?”

“What makes one database tool more suitable than another in certain situations?”

The titles are open to everyone. Reading a lesson needs an account — sign in or create one.

1. Data, databases and DBMS
   40 min · 1 practice tasks · quiz
   Describe a database and a database management system.
2. Why DBMS is better for managing data
   40 min · 1 practice tasks · quiz
   Explain the advantages of a DBMS over simple methods.
3. DBMS tools
   40 min · 1 practice tasks · quiz
   Name common DBMS tools and their features.
4. Choosing the right DBMS tool
   40 min · 1 practice tasks · quiz
   Select a DBMS tool to suit a situation.
5. Where DBMS is used in real life
   40 min · 1 practice tasks · quiz
   Describe real-life uses of database management systems.
6. How data is organised
   40 min · 1 practice tasks · quiz
   Describe file, table, field, record and data value.
7. Tables and records
   40 min · 1 practice tasks · quiz
   Create and work with tables and records.
8. Fields, data types and keys
   40 min · 1 practice tasks · quiz
   Choose data types and use keys in a table.
9. What an entity-relationship diagram is
   40 min · 1 practice tasks · quiz
   Describe an ERD and its symbols.
10. Drawing an ERD
    40 min · 1 practice tasks · quiz
    Draw an ERD for a small database.
11. Designing a database
    40 min · 1 practice tasks · quiz
    Turn an ERD into a database design.
12. Creating a database file
    40 min · 1 practice tasks · quiz
    Create a database file and build its tables.
13. Entering and editing data with forms
    40 min · 1 practice tasks · quiz
    Use forms to enter and edit records.
14. Queries and extracting data
    40 min · 1 practice tasks · quiz
    Use queries to extract data from a database.
15. Sorting and filtering
    40 min · 1 practice tasks · quiz
    Sort and filter records to view them clearly.
16. Validation and data integrity
    40 min · 1 practice tasks · quiz
    Use validation to keep data correct.
17. Relationships between tables
    40 min · 1 practice tasks · quiz
    Link tables with keys and explain why.
18. Reports and presenting data
    40 min · 1 practice tasks · quiz
    Create reports to present database data.
19. Introduction to SQL
    40 min · 1 practice tasks · quiz
    Read and write simple SQL commands.
20. Security, backup and sharing
    40 min · 1 practice tasks · quiz
    Protect, back up and share a database safely.
21. Gathering and managing real-life data
    40 min · 1 practice tasks · quiz
    Gather data from a real source and manage it in a DBMS.
22. Appreciating database tools
    40 min · 1 practice tasks · quiz
    Value DBMS and reflect on the node.