PAÜ .:. Eğitim Öğretim Bilgi Sistemi

COURSE INFORMATION

Course Code	Course Title	L+P Hour	Semester	ECTS
CENG 217	DATABASE MANAGEMENT AND MODELING	3 + 0	3rd Semester	3

COURSE DESCRIPTION

Course Level	Bachelor's Degree
Course Type	Compulsory
Course Objective	The aim of the course is to make students have the ability of database modelling based on standards and technologies. At the end of this course, students will be able to identify database processing systems, understand the components of a database application and use Structured Query Language (SQL) to query relational databases.
Course Content	Database management software. The relational model: Data structure, data integrity, relational algebra. Data manipulation by using SQL. Transaction management: Recovery, concurrency. Relational database theory: Dependencies, normal forms. SQL data definition, other features. DBMS architectures and implementations. Query optimization. Procedural extensions to SQL: PL/SQL, database triggers. DBMSs, OQL. Distributed databases, distributed architectures and ODBC. Databases and the Web, Java database programming - JDBC, SQLJ, databases and XML. ORACLE9i. A real-world application project is performed by students.
Prerequisites	No the prerequisite of lesson.
Corequisite	No the corequisite of lesson.
Mode of Delivery	Face to Face

COURSE LEARNING OUTCOMES

1	Explains database concepts
2	Explains database design
3	Queries data in tables
4	Explains working with connected servers and web services
5	Explains architecture of one of the up-to-date database management systems

COURSE'S CONTRIBUTION TO PROGRAM

ECTS ALLOCATED BASED ON STUDENT WORKLOAD BY THE COURSE DESCRIPTION

Activities	Quantity	Duration (Hour)	Total Work Load (Hour)
Course Duration (14 weeks/theoric+practical)	14	2	28
Hours for off-the-classroom study (Pre-study, practice)	13	2	26
Mid-terms	1	10	10
Final examination	1	14	14
Total Work Load ECTS Credit of the Course			78 3

COURSE DETAILS

Select Year

	Course Term	No	Instructors
Details	2023-2024 Fall	1	ERKAN YEŞİL
Details	2023-2024 Fall	2	ERKAN YEŞİL

Course Details

Course Code	Course Title	L+P Hour	Course Code	Language Of Instruction	Course Semester
CENG 217	DATABASE MANAGEMENT AND MODELING	3 + 0	1	Turkish	2023-2024 Fall

Course Coordinator	E-Mail	Phone Number	Course Location	Attendance
Lecturer ERKAN YEŞİL	eyesil@pau.edu.tr		MUH A0425	%70

Goals		The aim of the course is to make students have the ability of database modelling based on standards and technologies. At the end of this course, students will be able to identify database processing systems, understand the components of a database application and use Structured Query Language (SQL) to query relational databases.
Content		Database management software. The relational model: Data structure, data integrity, relational algebra. Data manipulation by using SQL. Transaction management: Recovery, concurrency. Relational database theory: Dependencies, normal forms. SQL data definition, other features. DBMS architectures and implementations. Query optimization. Procedural extensions to SQL: PL/SQL, database triggers. DBMSs, OQL. Distributed databases, distributed architectures and ODBC. Databases and the Web, Java database programming - JDBC, SQLJ, databases and XML. ORACLE9i. A real-world application project is performed by students.

Topics

Materials

Materials are not specified.

Resources

Resources	Resources Language
Yazılımcılar için SQL Server 2014 & Veritabanı Programlama, Yaşar GÖZÜDELİ	Türkçe
An Introduction to Database Systems, C. J. DATE	English

Course Assessment

Assesment Methods	Percentage (%)	Assesment Methods Title
Final Exam	50	Final Exam
Midterm Exam	50	Midterm Exam

L+P: Lecture and Practice
PQ: Program Learning Outcomes
LO: Course Learning Outcomes

Prospective Student