Basic Information

Course Code:

CS 2003

Course Name:

Introduction to Database Systems

Language of Instruction:

English

Course Type:

Class

Course Level:

Bachelor

ECTS:

5.00

Instructor:

Dr. Öğr. Üyesi Göksel ASLAN

Course Objectives

The main objective of this course is to introduce students to the nature of database systems and how to view and manipulate the structures and data in such systems.

Course Content

This course introduces the fundamentals of database systems including relational data model, entity/relationship model, SQL, query optimization, integrity constraints, normalization, transaction management, concurrency control and recovery systems.

Prerequisites / Corequisites

CS 1002

Course Books / Materials / Recommended Resources

Fundamentals of Database Systems (7th Edition) – March 30, 2015 - Ramez Elmasri, Shamkant B. Navathe, ISBN 978-01-339-70777

Learning Outcomes

Code	Description
LO1	Understand DBMS and RDBMS
LO2	Explain the basic components of an E-R Model
LO3	Normalize a database
LO4	Obtain data from a database using SELECT SQL queries
LO5	Alter data in a database using UPDATE, DELETE, INSERT SQL queries
LO6	Design, create, and modify structure of a database

Weekly Course Content

Week	Content
1	Introduction
2	Relational Model
3	SQL
4	Database System Development
5	Database Analysis
6	Entity Relationship Model
7	Entity Relationship Model
8	Normalization
9	Normalization
10	Conceptual Database Design
11	Logical Database Design
12	Physical Database Design

Workload Calculation

Activity	Count	Duration (Hours)	Total
Attendance	14	3.00	42.00
Pre-Class Individual Study	14	2.00	28.00
Post-Prectice Individual Study	1	22.00	22.00
Midterm Exam/Preparation	1	10.00	10.00
Final Exam/Preparation	1	10.00	10.00
Homework	6	5.00	30.00
Other	14	0.50	7.00
Total Workload (Hours)			149
ECTS Credit (Workload / 25)			5

Assessment

#	Assessment Type	Contribution (%)
1	Midterm Exam	%25
2	Project	%25
3	Final Exam	%50
TOTAL		%100

PO - LO Matrix

PO \ LO	LO1	LO2	LO3	LO4	LO5	LO6
PO-1
PO-2
PO-3
PO-4
PO-5
PO-6
PO-7
PO-8
PO-9
PO-10
PO-11

1

Low Contribution

2

Medium Contribution

3

High Contribution

Teaching and Learning Methods

#	Method Name	Description	Tools
1	Lecture (expository teaching), interactive discussion	Listening and taking notes.	Standard classroom technologies, multimedia tools (projector, computer, digital presentations)
2	Homework	Solving and analyzing homework questions using a computer and Excel.	Computer

Academic Integrity and Artificial Intelligence

Violations of scholastic honesty include, but are not limited to cheating, plagiarizing, fabricating information or citations, facilitating acts of dishonesty by others, having unauthorized possession of examinations, submitting work of another person or work previously used without informing the instructor, or tampering with the academic work of other students. Any for of scholastic dishonesty is a serious academic violation and will result in a disciplinary action.