General Information
Course Code:
Course Title:
Credit:
Prerequisites:
Course Type:
Time & Room:
EGCO321
Database Systems
3 (3-0-6)
EGCO221 Data Structures and Algorithms
Core Course
Friday, 9:00 – 12:00 Room No. 6273
Course Description
Data model: entity-relationship, relational. Logical and Physical database design, Query Language, Data Dependencies and Normalization, Transaction, Crash Recovery, Concurrency control, Internet Databases.
Evaluation Method
Assignments
Project
Midterm Exam
Final Exam
50%
10%
20%
20%
Tentative Schedule
Week
Topic
Assignment
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
Introduction to Database Systems
Relational Data Model
Entity-Relationship Diagram (ERD)
Functional Dependencies and Normalization
Database Design
Structured Query Language (SQL) Part I
Structured Query Language (SQL) Part II
Views and Indexes
Stored Procedure and Trigger
Transaction Processing
Data Warehouse and Business Intelligence
Data Visualization
NoSQL: Basic Concepts
NoSQL: Document-Based Model
Project Presentation
Assignment 1 (5)
Assignemnt 2 (10)
Assignment 3 (10)
Assignment 4 (10)
Assignment 5 (5)
Assignment 6 (10)