TÜRKÇE
ENGLISH
Information
| Unit | TECHNICAL SCIENCES VOCATIONAL SCHOOL |
| GEOGRAPHICAL INFORMATION SYSTEMS PR. | |
| Code | CSS216 |
| Name | Database Aplications |
| Term | 2017-2018 Academic Year |
| Semester | 4. Semester |
| Duration (T+A) | 2-1 (T-A) (17 Week) |
| ECTS | 3 ECTS |
| National Credit | 2.5 National Credit |
| Teaching Language | Türkçe |
| Level | Üniversite Dersi |
| Type | Normal |
| Label | E Elective |
| Mode of study | Yüz Yüze Öğretim |
| Catalog Information Coordinator | Öğr. Gör. MEHMET AKİF ERDOĞAN |
| Course Instructor |
The current term course schedule has not been prepared yet. Previous term groups and teaching staff are shown.
|
Course Goal / Objective
Aimed to provide the know-how to perform GIS applications in different database environments.
Course Content
The structure of the data, data collection and analysis, asset and property tables, relationships between entities, entity relationships table, table operations
Course Precondition
Resources
Notes
Course Learning Outcomes
| Order | Course Learning Outcomes |
|---|---|
| LO01 | Having general perception about the database |
| LO02 | Perception of data concept |
| LO03 | Learning entity and property of tables |
| LO04 | Understanding of relations between entities |
| LO05 | Understanding dependent and independent entities of relationships |
| LO06 | Learning relationship between entity and table |
| LO07 | Having general knowledge about SQL language |
| LO08 | Midterm Exam |
| LO09 | Comprehension of relations between tables and space constrained tables |
| LO10 | Ability to add information to the table |
| LO11 | Ability to delete and update information from table |
| LO12 | Ability to drawing information from table |
| LO13 | Ability to draw information from different tables |
| LO14 | Understanding of nested selection |
| LO15 | Understanding database analysis |
Relation with Program Learning Outcome
| Order | Type | Program Learning Outcomes | Level |
|---|---|---|---|
| PLO01 | - | In mathematics, science, and issues related to their areas to have adequate infrastructure. | |
| PLO02 | - | Using the basic level knowledge and skills in the field, interpret and evaluate data, identify problems, develop solutions to have the ability. | |
| PLO03 | - | Knows the concepts related to Geographic Information Systems, Knows the use of GIS software | |
| PLO04 | - | Awareness of the need for life-long learning, to follow developments in science and technology and continuous self-renewal with the skill. | |
| PLO05 | - | Following the application of production processes in industrial and service sector to have the ability. | |
| PLO06 | - | The ability to perform drawings of vocational plans and projects related to the field wins. | |
| PLO07 | - | To recognize the corporate structure of the company for the profession and have the entrepreneurial spirit. | |
| PLO08 | - | To show what they have learned and can apply independently to learn in the field of GIS and have the ability to act independently to take risks. | |
| PLO09 | - | Modern techniques that are necessary on the field, and specify the information technologies and effective tools to use. | |
| PLO10 | - | To have knowledge of GIS and produce project and apply knowledge. | |
| PLO11 | - | Design using simulation programs related to computer-aided drawing and field and professional plan and gain the ability to perform the drawings of the project. | |
| PLO12 | - | Respect for historical values, social responsibility, global, to have a social and professional ethics. | |
| PLO13 | - | Innovations in the field of effective communication techniques and be able to follow the judge to have knowledge of a foreign language. | |
| PLO14 | - | To produce a solution for problems related to GIS, to take responsibility for the team or individual it will be equipped with the ability to work. | |
| PLO15 | - | Occupational safety, health and environmental protection, and to be conscious. | |
| PLO16 | - | Required by the field to be able to use basic computer software and hardware. |
Week Plan
| Week | Topic | Preparation | Methods |
|---|---|---|---|
| 1 | Basic Concepts | Literature reading | |
| 2 | Data and structure of data, data compiling and analysis | Literature reading and course review | |
| 3 | The creation of assets and table | Literature reading and course review | |
| 4 | Relationship between assets | Literature reading and course review | |
| 5 | Relationship of dependent and independent assets | Literature reading and course review | |
| 6 | Asset and table relationship | Literature reading and course review | |
| 7 | Introduction to SQL and database properties | Literature reading and course review | |
| 8 | Midterm Exam | Literature reading and course review | |
| 9 | The tables and relationships between tables and Area Restrictions | Literature reading and course review | |
| 10 | Data entery to table | Literature reading and course review | |
| 11 | Update and delete data from a table | Literature reading and course review | |
| 12 | Pull information from table | Literature reading and course review | |
| 13 | Pull information from different tables | Literature reading and course review | |
| 14 | Nested selection | Literature reading and course review | |
| 15 | functions like Grouping, calculation, counting etc. | Literature reading and course review | |
| 16 | Final exam | Literature reading and course review | |
| 17 | Final exam | Literature reading and course review |
Assessment (Exam) Methods and Criteria
Current term shares have not yet been determined. Shares of the previous term are shown.
| Assessment Type | Midterm / Year Impact | End of Term / End of Year Impact |
|---|---|---|
| 1. Homework | 100 | 40 |
| General Assessment | ||
| Midterm / Year Total | 100 | 40 |
| 1. Final Exam | - | 60 |
| Grand Total | - | 100 |