CBEHub

← Computer Studies / 3 Software Development

3.3 Relational Database Fundamentals

Computer Studies · Grade 11 · 14 lessons in the design

What you will be able to do

  • explain the types of database models used in computing
  • create a database for a real life task
  • represent a database structure in an entity relationship diagram
  • acknowledge the importance of relational databases in computing

Key questions

“Why are relational databases preferred for organisational and management of data?”

“How are relational database applications applied in real life situations?”

Lessons

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

  1. Database terms
    40 min · 1 practice tasks · quiz
    Define data, information, metadata and data dictionary.
  2. Database and DBMS components
    40 min · 1 practice tasks · quiz
    Describe the components of a database and a DBMS.
  3. Types of database models
    40 min · 1 practice tasks · quiz
    Describe the main database models.
  4. The relational model
    40 min · 1 practice tasks · quiz
    Explain how the relational model organises data.
  5. Entities and attributes
    40 min · 1 practice tasks · quiz
    Describe entities and attributes in a database.
  6. Data types
    40 min · 1 practice tasks · quiz
    Choose suitable data types for attributes.
  7. Key fields
    40 min · 1 practice tasks · quiz
    Describe primary, foreign, composite and secondary keys.
  8. Listing entities, attributes and keys
    40 min · 1 practice tasks · quiz
    Prepare a database plan by listing entities, attributes and keys.
  9. Creating a database for a real task
    40 min · 1 practice tasks · quiz
    Create a database for a real task.
  10. Representing a database in an ERD
    40 min · 1 practice tasks · quiz
    Draw an entity relationship diagram for a database.
  11. Creating relationships between entities
    40 min · 1 practice tasks · quiz
    Create relationships between database entities.
  12. Importance of relational databases
    40 min · 1 practice tasks · quiz
    Explain why relational databases are preferred and used.
  13. Creating an operational database
    40 min · 1 practice tasks · quiz
    Create and use a database for a real community task.
  14. Reviewing relational databases
    40 min · 1 practice tasks · quiz
    Review and appreciate relational database fundamentals.