Nevşehir Hacı Bektaş Veli University Course Catalogue
|
|||||
| 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-16 Make installations, maintenance and checks in database. |
Examination |
| LO-2 | Can creating the database |
PO-10 Designs and manages databases |
Examination |
| LO-3 | Can query the database |
PO-10 Designs and manages databases PO-16 Make installations, maintenance and checks in database. |
Examination |
| LO-4 | Can use the database administrative functions |
PO-10 Designs and manages databases PO-16 Make installations, maintenance and checks in database. |
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 | Application on the PC |
| 2 | Normalization | Application on the PC |
| 3 | Normalization | Application on the PC |
| 4 | Installing the Database Tools | Application on the PC |
| 5 | Creating tables and determine the characteristics of | Application on the PC |
| 6 | Creating tables and determine the characteristics of | Application on the PC |
| 7 | Create and use the kinds of queries | Application on the PC |
| 8 | mid-term exam | |
| 9 | Create and use the kinds of queries | Application on the PC |
| 10 | Create and use the kinds of queries | Application on the PC |
| 11 | Prepare tables associated with the query | Application on the PC |
| 12 | Prepare tables associated with the query | Application on the PC |
| 13 | Using DML queries | Application on the PC |
| 14 | Using DML queries | Application on the PC |
| 15 | User queries Writing | Application on the PC |
| 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) | 3 | 14 | 42 |
| Outside Class | |||
| a) Reading | 2 | 4 | 8 |
| b) Search in internet/Library | 2 | 4 | 8 |
| c) Performance Project | 2 | 5 | 10 |
| d) Prepare a workshop/Presentation/Report | 2 | 5 | 10 |
| e) Term paper/Project | 0 | ||
| Oral Examination | 0 | ||
| Quiz | 0 | ||
| Laboratory exam | 0 | ||
| Own study for mid-term exam | 1 | 4 | 4 |
| mid-term exam | 1 | 1 | 1 |
| Own study for final exam | 1 | 6 | 6 |
| final exam | 1 | 1 | 1 |
| 0 | |||
| 0 | |||
| Total work load; | 90 | ||