Nevşehir Hacı Bektaş Veli University Course Catalogue
|
|||||
| Year/Semester of Study | 2 / Spring Semester | ||||
| Level of Course | 1st Cycle Degree Programme | ||||
| Type of Course | Compulsory | ||||
| Department | DEPARTMENT OF COMPUTER ENGINEERING | ||||
| Pre-requisities and Co-requisites | None | ||||
| Mode of Delivery | Face to Face | ||||
| Teaching Period | 14 Weeks | ||||
| Name of Lecturer | SEMA ATASEVER (sema@nevsehir.edu.tr) | ||||
| Name of Lecturer(s) | EBUBEKİR KAYA, | ||||
| Language of Instruction | Turkish | ||||
| Work Placement(s) | None | ||||
| Objectives of the Course | |||||
| The aim of this course is to teach students the SQL query language, which enables them to manage the data modeling, logical design concepts and data for the storage and effective management of interrelated data groups that they can encounter in many areas of daily life, and to develop applications with common relational database management systems. | |||||
| Learning Outcomes | PO | MME | |
| The students who succeeded in this course: | |||
| LO-1 | Can model the data. |
PO-5 Students gain the ability to define, model, formulate and solve general engineering problems. PO-11 Students will be able to perform database setup, maintenance and check. PO-15 Students will be able to design a system or process to meet the desired needs. PO-19 Students develop self-renewal and researcher skills in order to adapt to innovations and developing technology. |
Examination |
| LO-2 | Can knows the basic features of relational database management systems. |
PO-5 Students gain the ability to define, model, formulate and solve general engineering problems. PO-11 Students will be able to perform database setup, maintenance and check. PO-15 Students will be able to design a system or process to meet the desired needs. PO-19 Students develop self-renewal and researcher skills in order to adapt to innovations and developing technology. |
Examination |
| LO-3 | Can use SQL commands, it makes structural arrangements in the database, adds data, deletes data, organizes data and designs complex queries. |
PO-5 Students gain the ability to define, model, formulate and solve general engineering problems. PO-11 Students will be able to perform database setup, maintenance and check. PO-19 Students develop self-renewal and researcher skills in order to adapt to innovations and developing technology. |
Examination Performance Project |
| LO-4 | Can normalize the database. |
PO-5 Students gain the ability to define, model, formulate and solve general engineering problems. PO-11 Students will be able to perform database setup, maintenance and check. PO-19 Students develop self-renewal and researcher skills in order to adapt to innovations and developing technology. |
Examination Performance Project |
| LO-5 | Can manages the data by establishing a database connection over the current programming languages. |
PO-5 Students gain the ability to define, model, formulate and solve general engineering problems. PO-11 Students will be able to perform database setup, maintenance and check. PO-19 Students develop self-renewal and researcher skills in order to adapt to innovations and developing technology. |
Examination Performance Project |
| LO-6 | Can view and report in SQL. |
PO-5 Students gain the ability to define, model, formulate and solve general engineering problems. PO-11 Students will be able to perform database setup, maintenance and check. PO-19 Students develop self-renewal and researcher skills in order to adapt to innovations and developing technology. |
Examination |
| PO: Programme Outcomes MME:Method of measurement & Evaluation |
|||
| Course Contents | ||
| Basic database concepts; data and data models; relational database design; SQL structured query language; basic SQL dwellings; SQL functions; grouping; combining; SQL administrative functions; use of multiple tables; SQL programming and function; Transaction and error conditions in SQL programming; DBMS setup and administrative operations; SQL queries on database management system. | ||
| Weekly Course Content | ||
| Week | Subject | Learning Activities and Teaching Methods |
| 1 | Data and Information Concepts | Lecture / Question - Answer |
| 2 | Database Management Systems and Historical Development | Lecture / Question - Answer |
| 3 | Data Modeling, Entity-Relationship Model | Lecture / Question - Answer, problem solving, application |
| 4 | Relationships Between Assets: 1-1, 1-N, N-M Type Relationships | Lecture / Question - Answer, problem solving, application |
| 5 | Logical Design | Lecture / Question - Answer, problem solving, application |
| 6 | SQL (DDL) - Data Definition Language | Lecture / Question - Answer, problem solving, application |
| 7 | SQL (DML) - Data Manipulation Language | Lecture / Question - Answer, problem solving, application |
| 8 | mid-term exam | |
| 9 | Advanced SQL: Complex Queries | Lecture / Question - Answer, problem solving, application |
| 10 | Database Normalization | Lecture / Question - Answer, problem solving, application |
| 11 | Object Oriented Databases | Lecture / Question - Answer, problem solving, application |
| 12 | Object Oriented Databases | Lecture / Question - Answer, problem solving, application |
| 13 | Database Connection From Application Programs | Lecture / Question - Answer, problem solving, application |
| 14 | Database Connection From Application Programs | Lecture / Question - Answer, problem solving, application |
| 15 | Database Connection From Application Programs | Lecture / Question - Answer, problem solving, application |
| 16 | final exam | |
| Recommend Course Book / Supplementary Book/Reading | ||
| 1 | - Ramez Elmasri, Shamkant B. Navathe, Fundamentals of Database Systems, 5th ed., Pearson Education, Inc, Boston, MA, 2007. | |
| 2 | Veri Tabanı Sistemleri, Ünal Yarımağan, TBV Yayınları. | |
| Required Course instruments and materials | ||
| Auxiliary textbook, projection, computer. | ||
| 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 | 8 | 5 | 40 |
| b) Search in internet/Library | 8 | 5 | 40 |
| c) Performance Project | 8 | 1 | 8 |
| 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 | 8 | 1 | 8 |
| mid-term exam | 1 | 1 | 1 |
| Own study for final exam | 10 | 1 | 10 |
| final exam | 1 | 1 | 1 |
| 0 | |||
| 0 | |||
| Total work load; | 150 | ||