Courses  >

SD 6032 – RDBMS & SQL

At a glance

  • 5 lecture hours per week
  • 2 practice hours per week
  • 4 credits

Prerequisites

None

Topics Covered

  • Fundamental concepts underlying database management systems
  • Database models
  • Entity relationship modelling
  • Data definition language (DDL)
  • Relational algebra and relational calculus
  • Normalisation of data using first, second, and third normal forms
  • Basic SQL commands and syntax
  • Use of mySQL to convert database design into tables in a database

Learning Resources

  • Elmasri, R., & Navathe, S.B. (2013). Database systems – Models, languages, design and application programming (6th Edition). Pearson.
  • Elmasri, R., & Navathe, S. B. (2011). Fundamentals of database systems (5th Edition). Pearson.
  • Gillenson, M. L. (2015). Fundamentals of database management systems (1st Edition). John Wiley & Sons.