Database Systems

Learning Outcomes

Upon successful completion of this course, students are expected to be able to Explain the database design concept and applications, Analyze the strength and weaknesses of alternative solutions developed from the given requirements and queries, Use appropriate techniques to maintain a database system, Design and implement a database system from a set of requirements, Explain and apply various methods of data storage, organization and access.

Topics

This course is designed to teach the internals of a database system, such as record storage, primary files organizations and index structures for files as an introduction to the concepts of database system and architecture.

This course also includes relational data models, relational constraints, and relational algebra as this will enable students to understand the technical aspects internal to database system architecture. This course introduces database systems such as OO database, the extended relational database system, and RDBMS in Oracle, thus ensuring student familiarity with current database systems. Database security and authorization will be elaborated at the end of the course, ensuring students understand the importance of securing the database system.

Pre-requisite: IS203 Database Design