Iğdır University Lifelong Learning Programme

Description of Individual Course Units

Course Unit Code	Course Unit Title	Type of Course Unit	Year of Study	Semester	Number of ECTS Credits
3303002102	DATABASE -1	Compulsory	1	2	4

Level of Course Unit

Short Cycle

Objectives of the Course

It is aimed that, with this course, students will gain basic skills in designing database, creating, querying, using database management functions.

Name of Lecturer(s)

Öğr. Gör. Metehan GÜNDE

Learning Outcomes

1	Sturents will analyse database needs.
2	Students will normalize.
3	Students will install database tools.
4	Students will create table and define properties.
5	Students will create query and use types of it.
6	Students will create query with related tables.
7	Students will use DML query.
8	Students will write user, image and trigger queries.
9	Students will write sub-programme, transaction, index queries.

Mode of Delivery

Daytime Class

Prerequisites and co-requisities

None

Recommended Optional Programme Components

None

Course Contents

"1. Database Needs Analysis 2. Normalization (1NF, 2NF, 3NF, BCNF, 4NF, 5NF, Algorithm) 3. Constitute Database Tools (Server, Management Tools) 4. Create Tables and Define the Properties of Tables 5. Create Query and Use Types of it (Structure of SQL Language, Grup Data) 6. Create Query with Related Tables 7. Use DML Query 8. Write User Queries (Create user, Changes to Rights, Delete User) 9. Write Display Queries (Aims of Using Image, Create Image, Improved Queries, Delete Queries) 10. Write Trigger Queries (Aims of Using Trigger, Create Trigger, Use Variables, Changes to Trigger Structure, Delete Trigger) 11. Write Sub-programme Queries (Aim, Create, Variables, Changes, Delete) 12. Transaction Actions (Aims of Using, Create, Variable, Change, Delete) 13. Write Index Queries(Aims, Create, Variable, Delete)"

Weekly Detailed Course Contents

Week	Theoretical	Practice	Laboratory
1	Database Needs Analysis
2	Normalization (1NF, 2NF, 3NF)
3	Normalization (BCNF, 4NF, 5NF)
4	Constitute Database Tools
5	Create Tables
6	Define the Properties of Tables
7	"Create Query, Use Types of it
8	Create Query with Related Tables
9	Use DML Query
10	Write User and Image Queries
11	Write User and Image Queries
12	Write Sub-programme Queries
13	Write Transaction Queries
14	Write Index Queries

Recommended or Required Reading

Yazılımcılar İçin SQL Server 2008 R2 & Veritabanı Programlama, Yaşar GÖZÜDELİ, Seçkin Yayıncılık, Ankara, 2011.

Planned Learning Activities and Teaching Methods

Assessment Methods and Criteria

Term (or Year) Learning Activities	Quantity	Weight
Midterm Examination	1	100
SUM		100
End Of Term (or Year) Learning Activities	Quantity	Weight
Final Examination	1	100
SUM		100
Term (or Year) Learning Activities		40
End Of Term (or Year) Learning Activities		60
SUM		100

Language of Instruction

Turkish

Work Placement(s)

None

Workload Calculation

Activities	Number	Time (hours)	Total Work Load (hours)
Midterm Examination	1	1	1
Final Examination	1	2	2
Attending Lectures	14	4	56
Practice	1	1	1
Self Study	14	3	42
Individual Study for Mid term Examination	1	6	6
Individual Study for Final Examination	1	12	12
TOTAL WORKLOAD (hours)			120

Contribution of Learning Outcomes to Programme Outcomes

	PÇ 1	PÇ 2	PÇ 3	PÇ 4	PÇ 5	PÇ 6	PÇ 7	PÇ 8	PÇ 9	PÇ 10	PÇ 11
ÖÇ1	2		3
ÖÇ2	4		4
ÖÇ3	3		3
ÖÇ4	4		3
ÖÇ5	4		3
ÖÇ6	2		4
ÖÇ7	5		4
ÖÇ8	5		5
ÖÇ9	1		5

* Katkı Düzeyi : 1 Çok düşük 2 Düşük 3 Orta 4 Yüksek 5 Çok yüksek