In the move to our new system and website, we are encountering some technical issues.
We are working hard to fix these and we appreciate your patience and understanding.

Subject details

  • Topics
    • Introduction to databases
    • Basic relational modelling
    • Basic entity-relationship modelling
    • Basic SQL programming
    • Advanced Relational Modelling
    • Relational database design
    • Advanced ER modelling
    • Advanced SQL programming
  • Study resources
    • Instructional Methods
      • Audio/Video conferencing
      • Disscusion forum/Discussion Board
      • Embedded Multimedia
      • Online assignment submission
      • Podcasting/Leacture capture
      • Standard Media
      • Streaming Multimedia
      • Web links
    • Online Materials
      • FAQs
      • Printable format materials
      • Resources and Links
      • Audio-Video streaming

Upon successful completion of this subject you should be able to:

  1. Describe various data modelling and database system technologies

  2. Explain the main concepts for data modelling and characteristics of database systems

  3. Identify issues with and compare, justify relational database design using the functional dependency concepts

  4. Apply SQL as a programming language to define database schemas and update database contents

  5. Apply SQL as programming language to extract data from databases for specific users’ information needs

  6. Design a database schema using conceptual modeling mechanisms such as entity-relationship diagrams.

  • Assignment 1 - Assignment 1 (20%)
  • Assignment 2 - Invigilated Exam (50%)
  • Assignment 3 - Assignment 2 (30%)

Textbooks are subject to change within the academic year. Students are advised to purchase their books no earlier than one to two months before the start of a subject

Recommended

  • A First Course in Database Systems, Pearson New International Edition (3e)
  • Jeffrey D Ullman, Jennifer Widom
  • 9781292025827
  • Print

Entry Requirements

You are recommended to have completed the following subjects(s) or have equivalent knowledge before starting this unit:

Special requirements

No special requirements

Databases and the database technology are having a major impact on the growing use of computers. They play a critical role in almost all areas where computers are used.
 
This degree is an introduction to the principles, use, and applications of database systems. It assumes no previous knowledge of databases or database technologies. This degree focuses on developing skills in designing databases for efficient data management and SQL programming for querying and using databases for various database applications. 

Related degrees