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
COMPUTER ENGINEERING DEPARTMENT
253 Computer 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 301
DATABASE MANAGEMENT & MODELING
3 + 2
5th Semester
7
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 SQL server architecture
5
Lists concurrency controls
6
Explains working with connected servers and web services
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
LO 001
5
5
5
5
3
5
LO 002
5
5
5
5
3
5
LO 003
5
5
5
5
3
5
LO 004
5
5
5
5
3
5
LO 005
5
5
5
5
3
5
LO 006
5
5
5
5
3
5
Sub Total
30
30
30
30
18
30
Contribution
5
0
5
5
5
0
0
3
0
0
5
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
5
70
Hours for off-the-classroom study (Pre-study, practice)
14
3
42
Assignments
1
8
8
Mid-terms
1
8
8
Laboratory
15
2
30
Final examination
1
9
9
Presentation / Seminar Preparation
1
2
2
Report / Project
1
13
13
Total Work Load
ECTS Credit of the Course
182
7
COURSE DETAILS
Select Year
All Years
2018-2019 Fall
2017-2018 Fall
2016-2017 Fall
2015-2016 Fall
2014-2015 Fall
2013-2014 Fall
2012-2013 Fall
2011-2012 Fall
2010-2011 Fall
2008-2009 Fall
Course Term
No
Instructors
Details
2013-2014 Fall
1
ŞEVKET UMUT ÇAKIR
Details
2013-2014 Fall
2
ŞEVKET UMUT ÇAKIR
Print
Course Details
Course Code
Course Title
L+P Hour
Course Code
Language Of Instruction
Course Semester
CENG 301
DATABASE MANAGEMENT & MODELING
3 + 2
1
English
2013-2014 Fall
Course Coordinator
E-Mail
Phone Number
Course Location
Attendance
Lecturer ŞEVKET UMUT ÇAKIR
sucakir@pau.edu.tr
MUH A0005 MUH A04155
%
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
Introduction to Database Topics
2
Fundemantals of Relational Database
3
SQL Server Interface
4
Database Design
5
Fundementals of Database Objects
6
SQL Queries
7
View and Index Theory, Stored Procedure
8
Programming with T-SQL
9
Transactions
10
Midterm
11
Working with XML
12
Service Brokers, ADO.NET
13
Project Presentations
14
Project Presentations
Materials
Materials are not specified.
Resources
Resources
Resources Language
Yazılımcılar için SQL Server 2008 & Veritabanı Programlama, Gözüdeli Y., Seçkin Yayıncılık
Türkçe
Database Systems: Design, Implementation & Management,Rob P., Coronel C., Thomson Course Technology
English
Course Assessment
Assesment Methods
Percentage (%)
Assesment Methods Title
Final Exam
35
Final Exam
Midterm Exam
35
Midterm Exam
Project
30
Project
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