UBI
502 Database Management Systems
Spring
2019-2020
Instructor:
Asst. Prof. Dr. İlker Kocabaş
(ilker.kocabas@ege.edu.tr)
Assistant:
Cemre Candemir (cemre.candemir@ege.edu.tr)
Time:
Thursday 13:15– 12:00
Office
Hour: Friday 13:15 – 12:00
All important
information about the course is available from this Web page.
Announcements:
Assignment-1
can be reached from here. (Submission deadline: 05.03.2020)
Course Description:
The
aim of the Database Management Systems course is to teach the basics of the
database systems. Covers the following topics: Entity-Relationship Model,
Relational Model, SQL, MySQL, PHP Data Storage, Indexing, Hashing, Internet
Databases and XML, Normal Forms, Integrity and Security, Oracle, PL-SQL, Query
Processing and Transactions.
Goals:
Objectives
of this course are; to make the student identify fundamental database
management concepts which include database design, designing languages, system
implementation and implement the designed application.
Prerequisites:
There are no course prerequisites.
Course Material:
Required lecture slides (available on
the course’s web page)
Textbook:
A First Course in Database Systems, Jeffrey D. Ullman, Jennifer Widom (2001), 2nd edition, Prentice Hall, USA
Reference Books:
[1] Database
System Concepts, Silberschatz, Korth,
Sudarsham (2004), 4th edition, McGraw Hill, USA.
[2]
PHP ve MySQL,
Weilling, Thomson, ceviri B.Elcioglu (2005),3th edition,
ALFA, Turkey.
Required
Applications & Libraries:
[1]
Apache Web Server (free, ver:2.2.8), (Alternative: Microsoft IIS)
[2]
MySQL Database (free, version:5.1 or
6), (Alternative: Microsoft SQLServer, Oracle ), MySQL Admin Tool (free, version:1.2), MySQL Query
Browse (free, version:1.2)
[3]
PHP (free, version: 5.2.5), (Alternative: Microsoft
ASP)
[4]
WAMP (All-in-one server)
[5]
Macromedia Dreamweaver 8
Tentative Course Syllabus:
|
Date/Week |
Topics |
Supplementary Notes |
|
1 |
Overview:
Course content & sources |
|
|
2 |
||
|
3 |
||
|
4 |
||
|
5 |
||
|
6 |
SQL, Query Language |
|
|
7 |
SQL-Extanded |
|
|
8 |
MIDTERM |
|
|
9 |
||
|
10 |
||
|
11 |
Query Processing,
& Optimization |
|
|
12 |
Object-based
Databases |
|
|
13 |
Database System Architecture |
|
|
14 |
Project Presentations |
|
Grading (Tentative):
Assignments + Project 30%
Midterm 30%
Final 40%