Skip to main content
TR

DATABASE MANAGEMENT SYSTEMS AND PROGRAMMING

Course
ISYE342 - DATABASE MANAGEMENT SYSTEMS AND PROGRAMMING
Department
Information Systems Engineering - English - Master
Course Type
Scientific Preparation
Status
Required
Language
English
Credit
0
ECTS
0
T+P+L
0 + 0 + 0
Course Coordinator(s)
-
Prerequisite
-
Keywords
-

Course Description

-

DATABASE MANAGEMENT SYSTEMS AND PROGRAMMING

Evaluation Tools (Active Term)

Item Type Weight (%)
Midterm Midterm 35
Final Final 40
Project Project 15
Lab Assignment 10
Total 100

Course Syllabus

Week Topic
Week 1 Introduction to Database Management Systems
Week 2 DMBS concepts (Characteristics, levels of abstraction, advantages, query types )
Week 3 Relational database ( relational model, ER diagram)
Week 4 1 Week Break due to Covid19 Pandemy
Week 5 Introduction to Structured Query Language
Week 6 Restricting and Sorting Data
Week 7 Single Row Functions
Week 8 Conversion Functions
Week 9 Aggregate Functions
Week 10 Nested Queries - joins
Week 11 Nested queries - Subqueries
Week 12 Data Definition Languages (DDL) (table operations, constraints, indexing)
Week 13 Data Manipulation Language(DML)
Week 14 Normalization
Week 15 Revision

Reference Books & Course Materials

  1. 01 Elmasri & Navthe: Fundamentals of Database Systems, Addison Wesley, fifth ed., 2007.

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 theory
  3. L03 To give students a working knowledge of Oracle DBMS Server
  4. L04 To enable students in the use of SQL for DML and DDL

Program Outcomes

No program outcomes have been defined.

Po-Lo Matrix

The PO-LO matrix has not been populated yet.