|
|||||
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 |