MATHEMATICS
Bachelor	TR-NQF-HE: Level 6	QF-EHEA: First Cycle	EQF-LLL: Level 6

Course Introduction and Application Information

Course Code	Course Name	Semester	Theoretical	Practical	Credit	ECTS
SEN2102	IBM Database Programming	Fall	2	2	3	6

This catalog is for information purposes. Course status is determined by the relevant department at the beginning of semester.

Basic information

Language of instruction:	English
Type of course:	Departmental Elective
Course Level:	Bachelor’s Degree (First Cycle)
Mode of Delivery:	Face to face
Course Coordinator :	Dr. Öğr. Üyesi TAMER UÇAR
Recommended Optional Program Components:	None
Course Objectives:	The aim of the course is to let the students to design and implement the relational databases with web access for database-driven web applications. Main objective is to understand the database programming methods with advances in SQL and PL/SQL, and dynamic web programming techniques focusing on databases. The course covers SQL, Advanced SQL, PL/SQL, and architectural design by using DBMS.

Learning Outcomes

The students who have succeeded in this course;
1. Define the fundamental concepts for designing, using and constructing database systems
2. Develop an analytical approach to real world situations
3. Reconstruct problem solving skills
4. Design data models and logical database, construct database implementation
5. Design database queries by using SQL.
6. Identify the basics of PL/SQL programming.
7. Develop database applications with PL/SQL.
8. Develop database applications by properly managing concurrent transactions.
9. Design database interfaces.

Course Content

The course content is composed of database concepts, database design, data modeling and normalization, an overview to Oracle, Oracle tables, data management and retrieval, functions and grouping, join operations, the basics of PL/SQL, PL/SQL control structures and embedded SQL, PL/SQL cursor and exceptions, PL/SQL composite data types (Records, Tables, Varrays), procedure, function, package and trigger, Oracle with Java, architecture and administration.

Weekly Detailed Course Contents

Week	Subject	Related Preparation
1)	Database Concepts: A Relational Approach
2)	Database Design: Data Modeling and Normalization
3)	Oracle: An Overview / Oracle Tables: DDL
4)	Working with Tables: Data Management and Retrieval
5)	Working with Tables: Functions and Grouping / Joins
6)	PL/SQL: A Programming Language
7)	PL/SQL Basics
8)	More on PL/SQL: Control Structures and Embedded SQL
9)	PL/SQL Cursor and Exceptions
10)	PL/SQL Composite Data Types: Records, Tables, Varrays
11)	Procedure, Function, Package and Trigger
12)	Oracle with Java: A Tutorial on JDBC and SQLj
13)	Architecture and Administration
14)	Project Presentations

Sources

Course Notes / Textbooks:	Silberschatz, A., Korth, H.F., Sudarshan, S., Database System Concepts, 5th Edition, McGraw Hill. Elmasri, R., Navathe, S.B., Fundamentals of Database Systems, 5th Edition, Addison Wesley. Shah, N., Database Systems Using Oracle: A Simplified Guide to SQL and PL/SQL, Pearson Prentice Hall.
References:

Evaluation System

Semester Requirements	Number of Activities	Level of Contribution
Attendance	1	% 15
Quizzes	2	% 10
Homework Assignments	1	% 5
Presentation	1	% 10
Midterms	1	% 20
Final	1	% 40
Total		% 100
PERCENTAGE OF SEMESTER WORK		% 60
PERCENTAGE OF FINAL WORK		% 40
Total		% 100

ECTS / Workload Table

Activities	Number of Activities	Duration (Hours)	Workload
Course Hours	14	2	28
Laboratory	14	2	28
Study Hours Out of Class	5	3	15
Presentations / Seminar	1	8	8
Project	1	15	15
Homework Assignments	2	5	10
Quizzes	2	2	4
Midterms	1	14	14
Final	1	18	18
Total Workload			140

Contribution of Learning Outcomes to Programme Outcomes

No Effect	1 Lowest	2 Low	3 Average	4 High	5 Highest

	Program Outcomes	Level of Contribution
1)	To have a grasp of basic mathematics, applied mathematics and theories and applications in Mathematics
2)	To be able to understand and assess mathematical proofs and construct appropriate proofs of their own and also define and analyze problems and to find solutions based on scientific methods,
3)	To be able to apply mathematics in real life with interdisciplinary approach and to discover their potentials,
4)	To be able to acquire necessary information and to make modeling in any field that mathematics is used and to improve herself/himself,
5)	To be able to tell theoretical and technical information easily to both experts in detail and non-experts in basic and comprehensible way,
6)	To be familiar with computer programs used in the fields of mathematics and to be able to use at least one of them effectively at the European Computer Driving Licence Advanced Level,
7)	To be able to behave in accordance with social, scientific and ethical values in each step of the projects involved and to be able to introduce and apply projects in terms of civic engagement,
8)	To be able to evaluate all processes effectively and to have enough awareness about quality management by being conscious and having intellectual background in the universal sense,
9)	By having a way of abstract thinking, to be able to connect concrete events and to transfer solutions, to be able to design experiments, collect data, and analyze results by scientific methods and to interfere,
10)	To be able to continue lifelong learning by renewing the knowledge, the abilities and the competencies which have been developed during the program, and being conscious about lifelong learning,
11)	To be able to adapt and transfer the knowledge gained in the areas of mathematics ; such as algebra, analysis, number theory, mathematical logic, geometry and topology to the level of secondary school,
12)	To be able to conduct a research either as an individual or as a team member, and to be effective in each related step of the project, to take role in the decision process, to plan and manage the project by using time effectively.