Introduction to Database Management Systems, Architecture of Database Management Systems, Relational Model, Relational Database Design, Relational Algebra, SQL (DML), SQL (DDL), Normalization, Consistency and Security, Query Optimization, Concurrency, Term Projects

Course Objectives

Gain ability to design, implement and query a database which is a component of an information system, teach the methods and techniques to assure the consistency in databases to make them to be able to create and enhance available databases, make it possible to understand and use query techniques in order to be efficient users of data management layer of an information system.

Recommended or Required Reading

Edward Sciore, Database Design and Implementation, Second Edition, Wiley, 2020. ,Raghu Ramakrishnan and Johannes Gehrke, Database Management Systems, McGraw-Hill, 2001, 3rd Edition. ,J. Ullman, Principles of Database Systems, Second Edition, Computer Science Press, 1982. ,R. Elmasri, S.K. Navathe, Fundamentals of Database Systems, Third Edition, Addison-Wesley, 2000.

Learning Outcomes:

Upon the completion of this course a student :

1. Capacity to design a relational database

2. Capacity to create a relational database

3. Master relational algebra and SQL

4. Learn concurrecy methods, normalization, security and consistency methods in database management systems

5. Use databases

Grading

Midterm 25%

Application / Practice 10%

Research Presentation 25%

Final 40%