Nevşehir Hacı Bektaş Veli University Course Catalogue

Information Of Programmes

VOCATIONAL SCHOOL OF NEVŞEHİR / BİL207 - COMPUTER PROGRAMMING

Code: BİL207 Course Title: DATABASE I Theoretical+Practice: 2+2 ECTS: 3
Year/Semester of Study 2 / Fall Semester
Level of Course Short Cycle Degree Programme
Type of Course Compulsory
Department COMPUTER PROGRAMMING
Pre-requisities and Co-requisites None
Mode of Delivery Face to Face
Teaching Period 14 Weeks
Name of Lecturer MEHMET KIRTAY (mehmet@nevsehir.edu.tr)
Name of Lecturer(s) MEHMET KIRTAY,
Language of Instruction Turkish
Work Placement(s) None
Objectives of the Course
With this course, students, data base designing, creating, querying, data base administrative functions, gain qualifications.

Learning Outcomes PO MME
The students who succeeded in this course:
LO-1 Can design database PO-1 Has basic, current, and practical knowledge related to his/her profession
PO-3 Follows current developments and practices for his/her profession and uses them effectively
PO-13 Performs database design and management
Examination
LO-2 Can creating the database PO-1 Has basic, current, and practical knowledge related to his/her profession
PO-3 Follows current developments and practices for his/her profession and uses them effectively
PO-4 Uses information technologies related to his/her profession (software, programs, animations, etc.) effectively
PO-13 Performs database design and management
Examination
LO-3 Can query the database PO-1 Has basic, current, and practical knowledge related to his/her profession
PO-3 Follows current developments and practices for his/her profession and uses them effectively
PO-4 Uses information technologies related to his/her profession (software, programs, animations, etc.) effectively
PO-7 Takes responsibility as a team member to solve unforeseen and complex problems encountered in applications related to his/her field
PO-13 Performs database design and management
Examination
PO: Programme Outcomes
MME:Method of measurement & Evaluation

Course Contents
Normalization Installing the Database Tools Creating tables and determine the characteristics of Create and use the kinds of queries Prepare tables associated with the query Using DML queries Writing Queries View
Weekly Course Content
Week Subject Learning Activities and Teaching Methods
1 Database Needs Analysis Lectures, Questions and Answers, practice
2 Database Normalization Rules Lectures, Questions and Answers, practice
3 Database Normalization Rules Lectures, Questions and Answers, practice
4 Creating Tables and Specifying Their Properties Lectures, Questions and Answers, practice
5 SQL Basics , SELECT, INSERT, Lectures, Questions and Answers, practice
6 SQL Temelleri: UPDATE, DELETE Lectures, Questions and Answers, practice
7 Example Create and use the kinds of queries Lectures, Questions and Answers, practice
8 mid-term exam
9 SQL String Functions Lectures, Questions and Answers, practice
10 SQL String Functions Lectures, Questions and Answers, practice
11 SQL Math Functions Lectures, Questions and Answers, practice
12 SQL Date Functions Lectures, Questions and Answers, practice
13 SQL Grouping Operations Lectures, Questions and Answers, practice
14 SQL Aggregate Functions and Grouping Lectures, Questions and Answers, practice
15 Example Create and use the kinds of queries Lectures, Questions and Answers, practice
16 final exam
Recommend Course Book / Supplementary Book/Reading
1 Çoruh, P. D. M. (2017). Veritabanı:" Felsefesi, Tasarımı ve Yönetimi": MS-Access ve SQL Server Projeleri. eKitap Projesi & Cheapest Books.
2 Turgut ÖSEVEN.(2020).Veritabanı Yönetim Sistemleri 1.Ekin Yayınevi
Required Course instruments and materials

Assessment Methods
Type of Assessment Week Hours Weight(%)
mid-term exam 8 1 40
Other assessment methods
1.Oral Examination
2.Quiz
3.Laboratory exam
4.Presentation
5.Report
6.Workshop
7.Performance Project
8.Term Paper
9.Project
final exam 16 1 60

Student Work Load
Type of Work Weekly Hours Number of Weeks Work Load
Weekly Course Hours (Theoretical+Practice) 4 14 56
Outside Class
       a) Reading 2 4 8
       b) Search in internet/Library 2 4 8
       c) Performance Project 0
       d) Prepare a workshop/Presentation/Report 0
       e) Term paper/Project 0
Oral Examination 0
Quiz 0
Laboratory exam 0
Own study for mid-term exam 1 6 6
mid-term exam 1 1 1
Own study for final exam 2 5 10
final exam 1 1 1
0
0
Total work load; 90