SCS2101 Database Management Systems

This course is to provide students with a strong foundation in systematic approaches to design and implementing of database applications. Preliminarily, operations like requirements gathering and database planning will be covered. The course will also introduce students to developing of application programs that talk to the database. These applications may be online or offline.

Objectives:
 The objectives of the course are to:

• Provide a background for the evolution of database (management) systems
• Provide the students with the steps one has to go through when developing good database applications
• Give hands- on experience and knowledge in developing database (driven) applications.

Learning Outcomes: 
By the end of the course, students should be able to: 

• develop a sound data model for an application domain
• realize this model as a relational database schema
• implement this schema as a postgreSQL application
• build an HTML/forms based (PHP) interface to a relational database
• analyse the costs/benefits of data structures and algorithms used in the implementation of relational database   management systems
• understand the theory and techniques behind managing concurrent access to databases and recovery from errors
• and appreciate the limitations of existing relational database technology and have an overview of upcoming technologies.