The course will deal with entity relationship model, concepts behind normalization and the main language for relational database systems i.e. SQL.
The course aims to introduce basic database concepts, different data models, data storage and retrieval techniques and database design techniques. The course primarily focuses on relational data model and DBMS concepts.
Course Learning Outcomes
Upon successful completion of this course, students will have the skills to analyse business requirements and produce a viable model and implementation of a database to meet such requirements.
Course Material - Database Systems
Book Title : Modern Database Management
Author : Fred, R. McFadden Jeffrey, A Hoffer, Mary, B. Prescott
Book Title : Introduction to Oracle: SQL and PL/SQL
Book Title : Database Systems: A Practical Approach to Design, Implementation & Management
Author : Thomas Connnolly, Carolyn Begg
Book Title : Fundamentals of Database Systems
Author : Elmasri and Navathe,
Edition : 5/E
Publisher : Addison-Wesley