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
3303003105	DATABASE MANAGEMENT SYSTEMS	Elective	2	3	4

Level of Course Unit

Short Cycle

Objectives of the Course

To gain sufficiency to design and create databases and queries, to manage databases and set up security.

Name of Lecturer(s)

Learning Outcomes

1	To design database
2	To create database
3	To query the database
4	To manage the database and Set up the security

Mode of Delivery

Daytime Class

Prerequisites and co-requisities

None

Recommended Optional Programme Components

None

Course Contents

Database necessity analysis Normalization Installation of database tools Creating tables and specifying the properties Creating queries and using its kinds Making queries with Relational tables Using the DML queries Managing the databases Ensure the security of database

Weekly Detailed Course Contents

Week	Theoretical	Practice	Laboratory
1	Database necessity analysis
2	Normalization
3	Normalization
4	Installation of database tools Creating tables and specifying the properties
5	Creating queries and using its kinds
6	Creating queries and using its kinds
7	Creating queries and using its kinds
8	Creating queries and using its kinds
9	Making queries with Relational tables
10	Making queries with Relational tables
11	Making queries with Relational tables
12	Using the DML queries
13	Managing the databases
14	Ensuring the security of database

Recommended or Required Reading

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
Quiz	3	1	3
Attending Lectures	14	4	56
Project Preparation	5	1	5
Project Presentation	5	1	5
Project Design/Management	3	1	3
Self Study	14	2	28
Individual Study for Homework Problems	4	1	4
Individual Study for Mid term Examination	1	8	8
Individual Study for Final Examination	1	10	10
Individual Study for Quiz	3	1	3
Homework	4	1	4
TOTAL WORKLOAD (hours)			132

Contribution of Learning Outcomes to Programme Outcomes

	PO 1	PO 2	PO 3	PO 4	PO 5	PO 6	PO 7	PO 8	PO 9	PO 10	PO 11
LO1	4		4				5
LO2	4		4				5
LO3	4		4				5
LO4	4		4				5

* Contribution Level : 1 Very low 2 Low 3 Medium 4 High 5 Very High