Department of Mechanical Engineering

CE 223 | Course Introduction and Application Information

Course Name

Database Systems

Code	Semester	Theory (hour/week)	Application/Lab (hour/week)	Local Credits	ECTS
CE 223	SPRING	3	2	4	7

Prerequisites	None
Course Language	English
Course Type	Required (Core Course)
Course Level	First Cycle
Mode of Delivery	Face-To-Face
Teaching Methods and Techniques of the Course	Problem Solving Application: Experiment / Laboratory / Workshop Lecture / Presentation
National Occupational Classification Code	-
Course Coordinator	Prof. Dr. Turhan Tunalı
Course Lecturer(s)	Prof. Dr. Cem Evrendilek Dr. Öğr. Üyesi Çağlar Durmaz
Assistant(s)	Araş. Gör. Tugay Direk

Course Objectives

The goal of this course is to give basic knowledge of database systems to a student who intends to be a computer or software engineer. It provides a comprehensive introduction to relational data model and entity relationship 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.

Learning Outcomes

The students who succeeded in this course;

Name	Description	PC Sub	* Contribution Level
Name	Description	PC Sub	1	2	3	4	5
LO1	Students who can successfully complete this course; Identify and define all the information needed in the design of a database schema specific to a database application,				X
LO2	create conceptual and physical database designs for a management information system by drawing the E/R diagram and performing the normalization of relations				X
LO3	understand the core terms, concepts, and tools of relational database management systems				X
LO4	query a database using SQL				X
LO5	implement database applications by properly managing concurrent transactions				X
LO6	finetune a database design to improve the performance of applications by the use of beneficial indexes and additional data structures conforming to the characteristics of applications running on them			X

Course Description

Topics related to both database design and database programming are covered.

Related Sustainable Development Goals

Course Category	Core Courses	X
	Major Area Courses
	Supportive Courses
	Media and Managment Skills Courses
	Transferable Skill Courses

WEEKLY SUBJECTS AND RELATED PREPARATION STUDIES

Week	Subjects	Required Materials	Learning Outcome
1	Introduction to Database Systems, Relational Data Model, Semi Structured, Data Model	J. D. Ullman, J. Widom, A First Course In Database Systems, 3/e, PrenticeHall, 2008 (Ch. 1, Ch. 2.1, 2.2, 2.3, Ch. 11.1, 11.2, 11.3)	LO3
2	Entity-Relationship Data Model	J. D. Ullman, J. Widom, A First Course In Database Systems, 3/e, PrenticeHall, 2008 (Ch. 4.1, 4.2, 4.3, 4.4, 4.5, 4.6)	LO1
3	Introduction to Relational Databases, Functional Dependencies	J. D. Ullman, J. Widom, A First Course In Database Systems, 3/e, PrenticeHall, 2008 (Ch. 2.4, 3.1, 3.2, 3.3, 3.4, 3.5)	LO2
4	Design of Relational Databases, Multivalued Dependencies	J. D. Ullman, J. Widom, A First Course In Database Systems, 3/e, PrenticeHall, 2008 (Ch. 3.6, 3.7)	LO2
5	Functional Dependencies and Multivalued Dependencies Revisited	J. D. Ullman, J. Widom, A First Course In Database Systems, 3/e, PrenticeHall, 2008 (Ch. 2.4, 3.1, 3.2, 3.3, 3.4, 3.5, 3.6, 3.7)	LO2
6	Introduction to SQL (Part I)	J. D. Ullman, J. Widom, A First Course In Database Systems, 3/e, PrenticeHall, 2008 (Ch. 6.1, 6.2, 6.3, 6.4.1, 6.4.2)	LO4
7	Introduction to SQL (Part II)	J. D. Ullman, J. Widom, A First Course In Database Systems, 3/e, PrenticeHall, 2008 (Ch. 5.2, 6.4, 6.5)	LO4
8	Midterm		LO3
9	Constraints and Triggers	J. D. Ullman, J. Widom, A First Course In Database Systems, 3/e, PrenticeHall, 2008 (Ch. 7)	LO6
10	SQL Programming: Embedded SQL, PSM (PL/SQL)	J. D. Ullman, J. Widom, A First Course In Database Systems, 3/e, PrenticeHall, 2008 (Ch. 9.3, 9.4)	LO4
11	SQL Programming: CLI, JDBC, PHP/PEAR	J. D. Ullman, J. Widom, A First Course In Database Systems, 3/e, PrenticeHall, 2008 (Ch. 9.1, 9.2, 9.5, 9.6, 9.7)	LO4
12	Transactions, Views, Indexes	J. D. Ullman, J. Widom, A First Course In Database Systems, 3/e, PrenticeHall, 2008 (Ch. 6.6, 8.1, 8.2, 8.3, 8.4, 8.5)	LO5
13	SQL Authorization	J. D. Ullman, J. Widom, A First Course In Database Systems, 3/e, PrenticeHall, 2008 (Ch. 10.1)	LO4
14	Logical Query Languages (Datalog) and SQL Recursion	J. D. Ullman, J. Widom, A First Course In Database Systems, 3/e, PrenticeHall, 2008 (Ch. 5.3, 5.4, 10.2)	LO4
15	Review of the Semester		LO1
16	Final Exam		LO1

Course Notes/Textbooks	J. D. Ullman. J. Widom. A First Course In Database Systems. 3/e. PrenticeHall. 2008 Course slides (URL for textbook: http://wwwdb.stanford.edu/~ullman/fcdb.html)
Suggested Readings/Materials	Silberschatz et. al. Database System Concepts. 4th ed. McGrawHill. 2002.

EVALUATION SYSTEM

Semester Activities	Number	Weighting	LO1	LO2	LO3	LO4	LO5	LO6
Laboratory / Application	1	15				X
Quizzes / Studio Critiques	1	15	X	X	X	X	X	X
Midterm	1	30	X	X	X	X	X	X
Final Exam	1	40	X	X	X	X	X	X
Total	4	100

ECTS / WORKLOAD TABLE

Semester Activities	Number	Duration (Hours)	Workload
Participation	-	-	-
Theoretical Course Hours	16	3	48
Laboratory / Application Hours	16	2	32
Study Hours Out of Class	14	3	42
Field Work	-	-	-
Quizzes / Studio Critiques	1	15	15
Portfolio	-	-	-
Homework / Assignments	12	2	24
Presentation / Jury	-	-	-
Project	-	-	-
Seminar / Workshop	-	-	-
Oral Exams	-	-	-
Midterms	1	21	21
Final Exam	1	28	28
		Total	210

COURSE LEARNING OUTCOMES AND PROGRAM QUALIFICATIONS RELATIONSHIP

#	PC Sub	Program Competencies/Outcomes	* Contribution Level
			1	2	3	4	5
No program competency data found.

*1 Lowest, 2 Low, 3 Average, 4 High, 5 Highest

NEWSALL NEWS

‘Vibrating Smart Wristband’ Wins Regional First Prize

A vibrating smart wristband project developed for visually impaired individuals through the collaboration of the Izmir University of Economics Faculty ...

Related SDG:

Detail

IZMIR UNIVERSITY OF ECONOMICS GÜZELBAHÇE CAMPUS

Details

GLOBAL CAREER

As Izmir University of Economics transforms into a world-class university, it also raises successful young people with global competence.

More..

CONTRIBUTION TO SCIENCE

Izmir University of Economics produces qualified knowledge and competent technologies.

More..

VALUING PEOPLE

Izmir University of Economics sees producing social benefit as its reason for existence.

More..

BENEFIT TO SOCIETY

Transferring 22 years of power and experience to social work…

More..

You are one step ahead with your graduate education at Izmir University of Economics.

Master Programs Doctorate Programs