Course Code and Name
|
GE 103- Database Management
|
Term
|
Spring 2019-2020
|
Instructor
|
Associate Professor Aytuğ ONAN
|
E-mail
|
aytug.onan@cbu.edu.tr
aytugonan@gmail.com
|
Course Day and Time
|
Tuesday, 10.30-13.30
Office Hour:
Wednesday, 10.30-12.00.
|
Course Website
|
http://aytugonan.cbu.edu.tr/GE103_index.html
|
Objectives
|
The goal of this course is to give basic knowledge of
database systems to a student who intends to be an engineer.
It provides a comprehensive introduction to relational data
model and entityrelationship data model as a design tool.
Functional and multivalued dependencies in the context of
normalization process are described in detail for designing
relational database schema. SQL database language and system
aspects of SQL such as transaction management, indexing,
constraints, triggers and authorization are studied in
detail together with laboratory practices illustrating
different ways of database programming. |
|
Tentative Course Outline
|
Week#1: Course
Introduction
Week#2: Database
Design (Relations)
Week#3: The
Entity/Relationship Model
Week#4: Cardinality
Week#5: Special
Relations
Week#6: Midterm
Review + QUIZ#1
Week#7: Midterm
Exam
Week#8: Functional
Dependencies
Week#9: SQL-1
Week#10: SQL-2
Week#11: SQL-3
Week#12: SQL-4
Week#13: QUIZ#2
Week#14: Final
Review!
|
Textbook
|
"First Course in Database Systems, A, 3/E" by Jeffrey D. Ullman and
Jennifer Widom
|
Supplementary Materials
|
"Database Systems: The Complete Book", by Hector Garcia Molina,
Jeffrey D. Ullman, and Jennifer Widom
|
Evaluation
|
- Quizzes (2): 15%
- Term Project (1): 15%
- Midterm Exam (1): 30%
- Final Exam (1): 40%
|