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

FIRST CYCLE - BACHELOR'S DEGREE . FACULTY OF ENGINEERING . COMPUTER ENGINEERING DEPARTMENT . 253 Computer Engineering (2014)

Course Information | Course Learning Outcomes | Course's Contribution To Program | ECTS Workload | Course Details

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 01	5		5	5	5			3			5
LO 02	5		5	5	5			3			5
LO 03	5		5	5	5			3			5
LO 04	5		5	5	5			3			5
LO 05	5		5	5	5			3			5
LO 06	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

	Course Term	No	Instructors
Details	2018-2019 Fall	1	BEDİA SÜNDÜZ KILIÇ
Details	2018-2019 Fall	2	BEDİA SÜNDÜZ KILIÇ

Course Details

Course Code: CENG 301

Course Title: DATABASE MANAGEMENT & MODELING

L+P Hour : 3 + 2

Course Code : 1

Language Of Instruction: Turkish

Course Semester : 2018-2019 Fall

Course Coordinator : LECTURER BEDİA SÜNDÜZ KILIÇ

E-Mail: bskilic@pau.edu.tr

Phone Number :

Course Location

MUH A0327, MUH A0435,

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.

Attendance :

%70

Topics

Weeks	Topics
1	Introduction to Database Topics
2	Fundemantals of Relational Database
3	Database design according to normalization rules
4	SQL Server Interface and DDL
5	SQL Queries
6	Queries with multiple tables, View and Index
7	Complex Query Examples and DML
8	T-SQL, Stored Procedure
9	Function and Trigger
10	Midterm Exam
11	Transactions
12	SQL User Types and User Management
13	Project Presentations
14	Project Presentations

Materials

Materials are not specified.

Resources

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

Information Package & Course Catalogue