Pamukkale University
University is the guide to life
Welcome to PAU;
Prospective Student
Our Students
Our Staff
TR
Information Package & Course Catalogue
Home Page
About University
Name And Address
Acedemic Authorities
General Discription
Academic Calendar
General Admission Requirements
Recognition of Prior Learning
General Registration Procedures
ECTS Credit Allocation
Academic Guidance
Information For Students
Cost Of Living
Accommodation
Meals
Medical Facilities
Facilities for Special Needs Students
Insurance
Financial Support for Students
Student Affairs
Learning Facilities
International Programs
Language Courses
Internships
Sports Facilities and Leisure Activities
Student Associations
Practical Information for Mobile Students
Degree Programmes
FIRST CYCLE - BACHELOR'S DEGREE
FACULTY OF ENGINEERING
INDUSTRIAL ENGINEERING DEPARTMENT
255 Industrial Engineering
Course Information
Course Learning Outcomes
Course's Contribution To Program
ECTS Workload
Course Details
Print
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
PO 01
PO 02
PO 03
PO 04
PO 05
PO 06
PO 07
PO 08
PO 09
PO 10
PO 11
PO 12
PO 13
LO 001
LO 002
LO 003
LO 004
LO 005
Sub Total
Contribution
0
0
0
0
0
0
0
0
0
0
0
0
0
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
All Years
2023-2024 Fall
2022-2023 Fall
2021-2022 Fall
Course Term
No
Instructors
Details
2023-2024 Fall
1
ERKAN YEŞİL
Details
2023-2024 Fall
2
ERKAN YEŞİL
Print
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
Weeks
Topics
1
2
3
4
5
6
7
8
9
10
11
12
13
14
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
{1}
##LOC[OK]##
{1}
##LOC[OK]##
##LOC[Cancel]##
{1}
##LOC[OK]##
##LOC[Cancel]##
Home Page
About University
Name And Address
Acedemic Authorities
General Discription
Academic Calendar
General Admission Requirements
Recognition of Prior Learning
General Registration Procedures
ECTS Credit Allocation
Academic Guidance
Information For Students
Cost Of Living
Accommodation
Meals
Medical Facilities
Facilities for Special Needs Students
Insurance
Financial Support for Students
Student Affairs
Learning Facilities
International Programs
Language Courses
Internships
Sports Facilities and Leisure Activities
Student Associations
Practical Information for Mobile Students
Degree Programmes