Skip to main content
Cyprus International University
TR

DESIGN AND PROGRAMMING FOR DATABASE MANAGEMENT SYSTEMS

Course
CMPE630 - DESIGN AND PROGRAMMING FOR DATABASE MANAGEMENT SYSTEMS
Department
Computer Engineering - English - PhD
Course Type
Course
Status
Required
Language
English
Credit
3
ECTS
0
T+P+L
3 + 0 + 0
Course Coordinator(s)
-
Prerequisite
-
Keywords
-

Course Description

Design theory for relational databases. Database modeling, entities, data types, relations. Entity Relationship Diagrams, Relational Algebra. Table indexing. Database Queries, triggers, stored functions, stored procedures. Query optimization and data manipulation languages.

DESIGN AND PROGRAMMING FOR 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.