Programmes

BACHELOR OF SCIENCE IN SOFTWARE ENGINEERING

SENG 12543

DATABASES

Status : Core Pre-requisite : SENG 11512 Co-requisite : None

 

On completion of this course, the student should be able to:

  • Identify information needs of an organization
  • Analyze information neeeds
  • Prepare logical data model using ER diagrams
  • Convert ER diagram to relational database tables
  • Recognize relational algebra and calculus as mathematical foundation for relational databases
  • Normalize relational tables
  • Apply integrity constrains to a database
  • Use DDL and DML to create and manipulate databases, tables and data
  • Migrate from one database to another
  • Recognize new trends in databases.

Introduction to data and information, need of storing and maintaining data in an organization, information requirement elicitation and analysis for an organization, entities, attributes, relationships, cardinality, degree and domain, logical data modeling using ER diagrams, network, hierarchical, relational and object-oriented databases, relational algebra and calculus, converting an ER diagram to a relational database, 1st, 2nd and 3rd normalizations and their objectives, integrity constrains and their purposes, Data Definition Language (DDL) and its applications, Data Manipulation Language(DML) and its applications, Application interface to database, database migration, backup and restore, export and import, data exchange using XML and CSV, NoSQL databases, big data concept and technologies.

Lectures, supervised hands-on practical sessions on SQL, tutorials and group work.

End of course unit examination and continuous assessment.

  1. Elmasri, R and Navathe, S B (2011). Fundamentals of Database Systems. Addison Wesley
  2. McFadden, FR, Hoffer, J A and Prescott,M B (2010). Modern Database Management. Addison-Wesley Pub Co
  3. Date,CJ (2004).Introduction to Database Systems. Addison Wesley.

Back