CENG 435

Database System Design and Implementation

Prerequisites: CENG 315

Revisiting database systems, data definition, relational algebra, disk management, file management, memory management, transaction management, record management, metadata management, query processing, parsing, planning, database server, indexing, query optimization

Course Objectives

To master the topic of data management in computer science field, to be able to produce parts of a database management system, to gain to skill of researching

Recommended or Required Reading

E. Sciore, Database Design and Implementation, Secon Edition, Wiley, 2020., M. Fisher, J. Ellis, J. Bruce, JDBC(TM) API Tutorial and Reference , 3rd Edition (Java Series), Addison Wesley, Reading, Massachisetts, 2006.

Learning Outcomes

1. To install SimpleDB database management system, customize it as required

2. To develop applications that realize all the functions of a database management system

3. To learn the approaches and methods behind the functions of a database management system

4. Finding, implementing and presening solution to an engineering problem by means of software development in a team

Topics
Introduction to Database Systems and Data Definition
Relational Algebra
Relational Algebra
Disk and File Management
Memory Management
Transaction Management
Record Management
Metadata Management
Recovery and Concurrency
Query Processing
Query Parsing
Query Planning
Query Optimization
Term Projects

Grading

Midterm 30%

Research Presentation 30%

Final 40%