Description of Individual Course Units
Course Unit CodeCourse Unit TitleType of Course UnitYear of StudySemesterNumber of ECTS Credits
BİL1008DATABASE 1Elective124
Level of Course Unit
Short Cycle
Objectives of the Course
With this course the students, data base designing, creating, querying, data base administration functions, qualifications for the course.
Name of Lecturer(s)
Lecturer Fahri YILMAZ
Learning Outcomes
1database design
2You can create the database
3I can query the database
4Administrative functions are available to the database
Mode of Delivery
Formal Education
Prerequisites and co-requisities
None
Recommended Optional Programme Components
None
Course Contents
Database Needs Analysis normalization Installing the Database Tools Creating tables and determine the characteristics of Creating a query and use the kinds of Creating Tables associated with the query Using DML queries User Queries Writing
Weekly Detailed Course Contents
WeekTheoreticalPracticeLaboratory
1Database Needs Analysis normalization
2normalization
3normalization
4Installing the Database Tools
5Creating tables and determine the characteristics of
6Creating tables and determine the characteristics of
7Creating a query and use the kinds of
8Middle term exam
9Creating a query and use the kinds of Creating Tables associated with the query
10Creating Tables associated with the query Using DML queries
11Using DML queries User Queries Writing
12Write to the View Queries Writing Trigger Queries
13Writing Trigger Queries Sub-Programme Writing Queries
14Transaction Processing Make Writing Queries Index
15Writing Queries Index
16Final
Recommended or Required Reading
The textbook, books and other resources to help
Planned Learning Activities and Teaching Methods
Assessment Methods and Criteria
Term (or Year) Learning ActivitiesQuantityWeight
Midterm Examination1100
SUM100
End Of Term (or Year) Learning ActivitiesQuantityWeight
Final Examination1100
SUM100
Term (or Year) Learning Activities40
End Of Term (or Year) Learning Activities60
SUM100
Language of Instruction
Turkish
Work Placement(s)
None
Workload Calculation
ActivitiesNumberTime (hours)Total Work Load (hours)
Midterm Examination11515
Final Examination12525
Attending Lectures14342
Practice14114
Project Preparation11515
Project Presentation11010
TOTAL WORKLOAD (hours)121
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		PO
12		PO
13
LO15           5
LO25           5
LO35           5
LO45           5
* Contribution Level : 1 Very low 2 Low 3 Medium 4 High 5 Very High
 
Yozgat Bozok University, Yozgat / TURKEY • Tel  (pbx): +90 354 217 86 01 • e-mail: uo@bozok.edu.tr