This course provides an overview of database architecture, database system and management design, which covers both the theoretical and practical aspects of the relational model. Topics include an in-depth study of relational database model, fundamentals of database design techniques, structured query language (SQL), schema refinement and normal forms, storage and various indexing techniques. The course also includes a study of a commercially available database system and database application programming.

CILO-1: An ability to apply knowledge of computing and mathematics appropriate to the programme outcomes and to the discipline. CILO-2: An ability to apply knowledge of a computing specialisation, and domain knowledge appropriate for the computing specialisation to the abstraction and conceptualisation of computing models. CILO-3: An ability to analyse a problem, and identify and define the computing requirements appropriate to its solution. CILO-4: An ability to design, implement, and evaluate a computer-based system, process, component, or program to meet desired needs with appropriate consideration for public health and safety, social and environmental considerations. CILO-5: An ability to interpret and describe professional, ethical, legal, security and social issues and responsibilities. CILO-6: An ability to recognize the need for and an ability to engage in continuing professional development. CILO-7: An ability to use current techniques, skills, and tools necessary for computing practice with an understanding of the limitations.