Course Objectives

Students successfully completing this course should be able to:
  • Understand the different issues involved in the design and implementation of a database system.
  • Study the physical and logical database designs, database modeling, relational, hierarchical, and network models
  • Understand and use data manipulation language to query, update, and manage a database
  • Develop an understanding of essential DBMS concepts such as: database security, integrity, concurrency, distributed database, and Data Warehousing.
  • Design and build a simple database system and demonstrate competence with the fundamental tasks involved with modeling, designing, and implementing a DBMS.

Prerequisites

Students registering for CSE 3101 must have previously completed courses in C and Java programming languages and Data Structures.

Topics Covered

  • The Relational Data Model and Relational Algebra, Relational Calculus, Tuple Calculus
  • Standard Query Language (SQL)
  • The Entity-Relationship Data Model
  • Database Design Theory
  • Storage and File Structure, Indexing and Hashing
  • Query Processing, Query Optimization
  • Transactions
  • Distributed Databases
  • Data Warehousing, Mining, Information Retrieval

Textbook

Text Book: A. Silberschatz, H. F. Korth,S. Sudarshan, “ Database System Concepts”, McGraw-Hill Company, 6th Edition, 2010.

Grading

  • Final Exam: 60%
  • Continuous Assessment: 30%
  • Attendance: 10%