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.