Code |
Name of the Course Unit |
Semester |
In-Class Hours (T+P) |
Credit |
ECTS Credit |
BGT108 |
DATABASE BASICS |
2 |
4 |
3 |
5 |
GENERAL INFORMATION |
Language of Instruction : |
Turkish |
Level of the Course Unit : |
ASSOCIATE DEGREE, TYY: + 5.Level, EQF-LLL: 5.Level, QF-EHEA: Short Cycle |
Type of the Course : |
Compulsory |
Mode of Delivery of the Course Unit |
- |
Coordinator of the Course Unit |
Lecturer TUĞÇE YÜKSEL |
Instructor(s) of the Course Unit |
Lecturer AYSUN YILMAZ KIZILBOĞA |
Course Prerequisite |
No |
OBJECTIVES AND CONTENTS |
Objectives of the Course Unit: |
It aims to be able to organize data in a computer environment, design structural database models, secure and effective acceptance of data, processing of data and providing competence in reporting data. |
Contents of the Course Unit: |
Data and organization - Recognition of existing database technologies - Data model design - Database normalization - Data entry, Modification, Destruction, Reporting operations and batch operations. |
KEY LEARNING OUTCOMES OF THE COURSE UNIT (On successful completion of this course unit, students/learners will or will be able to) |
Designing a Database |
Creating a Database |
Querying a Database |
Using Database Administrative Functions |
WEEKLY COURSE CONTENTS AND STUDY MATERIALS FOR PRELIMINARY & FURTHER STUDY |
Week |
Preparatory |
Topics(Subjects) |
Method |
1 |
Literature research |
Data and Database Concepts, Needs Analysis |
Expression |
2 |
Research |
Data Models, Entity Relationship Diagram |
Expression |
3 |
Research |
Normalization |
Application |
4 |
Research |
Installing Database Tools, Creating Tables and Specifying Properties |
Application |
5 |
Research |
Creating Tables and Specifying Properties |
Application |
6 |
Research |
Create Query and Using The Type |
Application |
7 |
Research |
Creating Query and Using Its Types, Preparing Query with Related Tables |
Application |
8 |
- |
MID-TERM EXAM |
- |
9 |
Research |
Preparing Query with Related Tables |
Application |
10 |
Research |
Using DML Queries |
Application |
11 |
Research |
Using DML Queries, Writing User Queries |
Application |
12 |
Research |
Writing View Queries, Writing Trigger Queries |
Application |
13 |
Research |
Writing Subprogram Queries, Making Transactions |
Application |
14 |
Research |
Writing Index Queries |
Application |
15 |
Research |
Database Security and Backup |
Application |
16 |
- |
FINAL EXAM |
- |
17 |
- |
FINAL EXAM |
- |
SOURCE MATERIALS & RECOMMENDED READING |
Yazılımcılar İçin SQL Server 2012 ve Veritabanı Programlama, Yaşar Gözüdeli, Seçkin Yayıncılık |
ASSESSMENT |
Assessment & Grading of In-Term Activities |
Number of Activities |
Degree of Contribution (%) |
Description |
Level of Contribution |
0 |
1 |
2 |
3 |
4 |
5 |
CONTRIBUTION OF THE COURSE UNIT TO THE PROGRAMME LEARNING OUTCOMES
KNOWLEDGE |
Theoretical |
|
Programme Learning Outcomes |
Level of Contribution |
0 |
1 |
2 |
3 |
4 |
5 |
1 |
Knows the necessary terms and information in the computer field.
|
|
|
2 |
|
|
|
2 |
Gains knowledge of the concept of information security.
|
|
|
2 |
|
|
|
KNOWLEDGE |
Factual |
|
Programme Learning Outcomes |
Level of Contribution |
0 |
1 |
2 |
3 |
4 |
5 |
1 |
Gains the ability to learn the necessary concepts in the computer field.
|
|
|
2 |
|
|
|
SKILLS |
Cognitive |
|
Programme Learning Outcomes |
Level of Contribution |
0 |
1 |
2 |
3 |
4 |
5 |
1 |
Ability to identify, define, formulate and solve complex Information Security problems; for this purpose, the ability to select and apply appropriate analysis and modeling methods
|
|
|
|
3 |
|
|
SKILLS |
Practical |
|
Programme Learning Outcomes |
Level of Contribution |
0 |
1 |
2 |
3 |
4 |
5 |
1 |
Ability to design a complex computer-based system, process, security to meet specific requirements under realistic constraints and conditions; for this purpose, the ability to apply modern design methods.
|
|
1 |
|
|
|
|
OCCUPATIONAL |
Autonomy & Responsibility |
|
Programme Learning Outcomes |
Level of Contribution |
0 |
1 |
2 |
3 |
4 |
5 |
1 |
Ability to design, conduct experiments, collect data, analyze and interpret results for examining Information Security problems
|
|
|
|
|
4 |
|
2 |
Ability to work effectively within the discipline of Information Security and in multi-disciplinary teams; individual study skills
|
|
1 |
|
|
|
|
3 |
Professional and ethical responsibility awareness
|
|
1 |
|
|
|
|
4 |
Knowledge of project management and business practices such as risk management and change management; awareness of entrepreneurship, innovation and sustainable development
|
|
|
2 |
|
|
|
OCCUPATIONAL |
Learning to Learn |
|
Programme Learning Outcomes |
Level of Contribution |
0 |
1 |
2 |
3 |
4 |
5 |
1 |
Ability to develop, select and use modern techniques and tools required for Information Security applications
|
|
1 |
|
|
|
|
2 |
Awareness of the necessity of lifelong learning; ability to access information, follow developments in science and technology, and constantly renew oneself
|
|
1 |
|
|
|
|
OCCUPATIONAL |
Communication & Social |
|
Programme Learning Outcomes |
Level of Contribution |
0 |
1 |
2 |
3 |
4 |
5 |
1 |
Ability to communicate effectively in Turkish orally and in writing, foreign language knowledge
|
|
1 |
|
|
|
|
OCCUPATIONAL |
Occupational and/or Vocational |
|
Programme Learning Outcomes |
Level of Contribution |
0 |
1 |
2 |
3 |
4 |
5 |
1 |
Information about the effects of Information Security practices on health, environment and security in universal and social dimensions and the problems of the age; Awareness of the legal consequences of Information Security solutions
|
|
1 |
|
|
|
|
WORKLOAD & ECTS CREDITS OF THE COURSE UNIT |
Workload for Learning & Teaching Activities |
Type of the Learning Activites |
Learning Activities (# of week) |
Duration (hours, h) |
Workload (h) |
Lecture & In-Class Activities |
14 |
4 |
56 |
Preliminary & Further Study |
14 |
2 |
28 |
Land Surveying |
0 |
0 |
0 |
Group Work |
0 |
0 |
0 |
Laboratory |
0 |
0 |
0 |
Reading |
0 |
0 |
0 |
Assignment (Homework) |
0 |
0 |
0 |
Project Work |
2 |
12 |
24 |
Seminar |
0 |
0 |
0 |
Internship |
0 |
0 |
0 |
Technical Visit |
0 |
0 |
0 |
Web Based Learning |
0 |
0 |
0 |
Implementation/Application/Practice |
1 |
12 |
12 |
Practice at a workplace |
0 |
0 |
0 |
Occupational Activity |
0 |
0 |
0 |
Social Activity |
0 |
0 |
0 |
Thesis Work |
0 |
0 |
0 |
Field Study |
0 |
0 |
0 |
Report Writing |
0 |
0 |
0 |
Final Exam |
1 |
1 |
1 |
Preparation for the Final Exam |
1 |
2 |
2 |
Mid-Term Exam |
1 |
1 |
1 |
Preparation for the Mid-Term Exam |
1 |
2 |
2 |
Short Exam |
0 |
0 |
0 |
Preparation for the Short Exam |
0 |
0 |
0 |
TOTAL |
35 |
0 |
126 |
|
Total Workload of the Course Unit |
126 |
|
|
Workload (h) / 25.5 |
4,9 |
|
|
ECTS Credits allocated for the Course Unit |
5,0 |
|