Skip to main content
Cyprus International University
TR

ADVANCED DATABASE MANAGEMENT SYSTEMS

Course
CMPE540 - ADVANCED DATABASE MANAGEMENT SYSTEMS
Department
Computer Engineering - English - Master
Course Type
Course
Status
Required
Language
English
Credit
3
ECTS
0
T+P+L
3 + 0 + 0
Course Coordinator(s)
-
Prerequisite
-
Keywords
-

Course Description

This course covers a number of advanced topics in database management systems and modern database applications. The specific topics include advanced concurrency control techniques, query processing and optimization strategies for relational database systems, advanced indexing methods, parallel and distributed database systems, next-generation data models, data mining on large databases, data on the web, and topics in data security and privacy.

ADVANCED DATABASE MANAGEMENT SYSTEMS

Evaluation Tools (Active Term)

No evaluation items have been defined.

Course outcomes

  1. 01 TO DEVELOP SKILLS FOR DESIGNING AND IMPLEMENTING A RELATIONAL DATABASE
  2. 02 TO GIVE STUDENTS AN UNDERSTANDING OF THE FUNDAMENTAL CONCEPTS IN RELATIONAL THEOREY
  3. 03 TO GIVE STUDENTS A WORKING KNOWLEDGE OF IMPLEMENTATION OF DATABASE DESIGN
  4. 04 TO GIVE STUDENTS BACKGROUND ON STORED PROCEDURES, FUNCTIONS AND TRIGGERS
  5. 05 TO ENABLE STUDENTS IN THE USE OF SQL FOR DML AND DDL
  6. 06 TO INTRODUCE THE STUDENTS HOW TO DEVLOP DESKTOP APPLICATIONS WITH RDMS

Course Syllabus

Week Topic
Week 1 INTRODUCTION TO DATABASE MANAGEMENT SYSTEMS
Week 2 DBMS CONCEPTS ( CHARACTERISTICS, LEVEL OF ABSTRACTION, ADVANTAGES, QUERY TYPES)
Week 3 RELATIONAL DATABASE MODELING (RELATIONAL MODEL, ER DIAGRAM)
Week 4 RELATIONAL ALGEBRA AND CALCULUS
Week 5 STRUCTURES QUERY LANGUAGE, NESTED QUERIES, SUB QUERIES
Week 6 DATA MANIPULATION LANGUAGE (DML)
Week 7 DATA DEFINITION LANGUAGE (DDL) (TABLE OPERATIONS, CONSTRAINTS, INDEXING)
Week 8 MIDTERM
Week 9 NORMALIZATION
Week 10 VIEWS, INDEXING
Week 11 STORED PROCEDURES
Week 12 STORED FUNCTIONS/TRIGGERS
Week 13 DEVELOPING DATABASE DRIVEN APPLICATIONS
Week 14 PROJECT PRESENTATION
Week 15 -

Reference Books & Course Materials

  1. 01 "FUNDAMENTALS OF DATABASE SYSTEMS", ELMASRI AND NAVTHE, , 5th edition, 2007, ADDISON WESLEY

Learning Outcomes

  1. L01 TO DEVELOP SKILLS FOR DESIGNING AND IMPLEMENTING A RELATIONAL DATABASE
  2. L02 TO GIVE STUDENTS AN UNDERSTANDING OF THE FUNDAMENTAL CONCEPTS IN RELATIONAL THEOREY
  3. L03 TO GIVE STUDENTS A WORKING KNOWLEDGE OF IMPLEMENTATION OF DATABASE DESIGN
  4. L04 TO GIVE STUDENTS BACKGROUND ON STORED PROCEDURES, FUNCTIONS AND TRIGGERS
  5. L05 TO ENABLE STUDENTS IN THE USE OF SQL FOR DML AND DDL
  6. L06 TO INTRODUCE THE STUDENTS HOW TO DEVLOP DESKTOP APPLICATIONS WITH RDMS

Program Outcomes

No program outcomes have been defined.

Po-Lo Matrix

The PO-LO matrix has not been populated yet.