Description

Database and Data Modelling has been designed to equip students with the practical skills required for database design and development. Students are introduced to basic and intermediate concepts of relational and object-orientated databases. The module also familiarises students with the rationale for relational databases in modern information systems and its key role as a valuable resource to organisations.

Year Level: 2

At the successful completion of this module the student should:
  • Apply the principles governing the design, functioning and use of relational and object-oriented databases at introductory level
  • Explain the role of databases in modern information systems
  • Design relational databases of moderate complexity
  • Abstract table structure from data requirement statements
  • Explain the principles of primary- and foreign-key data relationships
  • Normalise data up to third normal form
  • Utilise the SQL language to query databases
  • Utilise a modern relational database management system using the data manipulation language and the data definition language
  • Model data relationships

Main Content
  • The theory and application of relational and object-oriented databases
  • Data-oriented modelling theory and application
  • Data normalisation theory
  • Unified Modelling Language
  • Object-oriented design principles
  • The object-oriented development life cycle

NQF Level: 6

NQF Credit Value: 20

Pre-requisites BCom (IS) IFS131 or IFS132, QSC132 or QSF131 or MAM126 and ALC132
Launch Course

Leave a Reply