Database Management System

What Will I Learn?

 Database concepts
 Relational model

 Relational query languages
       – Relational Algebra and Calculus
       – Datalog  
       –  SQL
       – QBE
 Triggers
 Embedded SQL
 Recursion
 Web database programming
 Conceptual data modeling
 E/R data model
 OO data model
 Relational database design
      – Normal Forms (NF)
      – 1-4NF
      – Lossless join decomposition
XML, XPath and XQuery

 E/R data model

OO data model
 Relational database design
      – Normal Forms (NF)
      – 1-4NF
      – Lossless join decomposition

 XML, XPath and XQuery

 Semantic Web
 RDF, RDF Schema, and OWL• Storage and indexing
 Query processing and optimization
 Parallel and distributed databases
 NoSQL databases

 Transaction processing and database recovery
 Database security
 Current developments in knowledgebase

Learning Skills

The course content is balanced on theory and practice, the course aims at
achieving the following learning outcomes:
• An appreciation of pervasive use of Knowledgebase and DBMS in different
application domains
• Skill for developing database applications
• Skills for devising data models and query languages
• Skills for developing web database applications
• Learning storage and indexing of data
• Learning transaction processing and database recovery
• Learning knowledge representation and semantic web technologies
• Skills to integrate knowledge to databases

July 5, 2018