Course Description
Course | Code | Semester | T+P (Hour) | Credit | ECTS |
---|---|---|---|---|---|
DATABASE PROGRAMMING I | BPR1114984 | Fall Semester | 4+0 | 4 | 7 |
Course Program | Perşembe 16:30-17:15 Perşembe 17:30-18:15 Perşembe 18:30-19:15 Perşembe 19:30-20:15 |
Prerequisites Courses | |
Recommended Elective Courses |
Language of Course | Turkish |
Course Level | Short Cycle (Associate's Degree) |
Course Type | Required |
Course Coordinator | Lect. Nada A. M. MISK |
Name of Lecturer(s) | Lect. Nada A. M. MISK |
Assistant(s) | Microsoft SQL Server |
Aim | Students should understand the concept of a database and that a database is the basic element of a software To teach SQL language effectively to students and to teach the platforms that will use this language to students to introduce them to the world is one of the objectives of the course. |
Course Content | This course contains; General information about database systems. Database types and usage areas,Entity Relational Model, Relational Model, Object Oriented Database Design Concepts. Types of Relationships between Entities One to One, One to Many, Many to One, Many to One, Many to Many relationships.,Database schema design Primary key, attribute, record concepts. Design and importance of auxiliary tables. Entity tables, Relationship tables. . Schema design for concurrent access.,Normalization, Prevention of Data Repetition ,Applied database design,Applied Database Design, SQL: Select, union, distinct, where, having, group by concepts and sample queries.,Stored Procedure,Functions,Cursor ,Tigers,User and role definitions,General Review. |
Dersin Öğrenme Kazanımları | Teaching Methods | Assessment Methods |
Learns the concept of database and file systems. Understands the advantages of VTYS. | 17, 9 | A, E, F, G |
Schematically builds the entity relational model for any software | 14, 17, 9 | A, E, F, G |
Makes queries on the database with SQL language | 12, 14, 17, 6, 9 | A, E, F, G |
C# uses SQL language embedded in languages such as VB | 11, 12, 16, 17, 6, 9 | A, E, F, G |
Designs web-based database applications | 10, 16, 17, 8, 9 | A, E, F, G |
Analyzes the whole by looking at the software from the database point of view | 10, 11, 17, 9 | A, E, F |
Teaching Methods: | 10: Discussion Method, 11: Demonstration Method, 12: Problem Solving Method, 14: Self Study Method, 16: Question - Answer Technique, 17: Experimental Technique, 6: Experiential Learning, 8: Flipped Classroom Learning, 9: Lecture Method |
Assessment Methods: | A: Traditional Written Exam, E: Homework, F: Project Task, G: Quiz |
Course Outline
Order | Subjects | Preliminary Work |
---|---|---|
1 | General information about database systems. Database types and usage areas | |
2 | Entity Relational Model, Relational Model, Object Oriented Database Design Concepts. Types of Relationships between Entities One to One, One to Many, Many to One, Many to One, Many to Many relationships. | |
3 | Database schema design Primary key, attribute, record concepts. Design and importance of auxiliary tables. Entity tables, Relationship tables. . Schema design for concurrent access. | |
4 | Normalization, Prevention of Data Repetition | |
5 | Applied database design | |
6 | Applied Database Design | |
7 | SQL: Select, union, distinct, where, having, group by concepts and sample queries. | |
8 | Stored Procedure | |
9 | Functions | |
10 | Cursor | |
11 | Tigers | |
12 | User and role definitions | |
13 | General Review |
Resources |
[1] Database Mangement Systems, R. Ramakrishnan, J.Gehrke, Second Edition – Mc Graw Hill. [2] Database System Concepts, A. Silberschatz |
Course Contribution to Program Qualifications
Course Contribution to Program Qualifications | |||||||
No | Program Qualification | Contribution Level | |||||
1 | 2 | 3 | 4 | 5 | |||
1 | Algoritma programlama, bilgisayar uygulaması geliştirme ve yazılım projelerinde kod geliştirme konularında yeterli altyapıya ve bunları iş hayatlarında kullanma yeteneğine sahiptir. | ||||||
2 | Programlama problemleri için bilinen çözüm yöntemlerini ve özel teknikleri kullanır ve uygular. | ||||||
3 | Yazılım uygulamaları için gerekli olan modern teknik ve araçları kullanır. | ||||||
4 | Bireysel olarak ve çok disiplinli takımlarda etkin olarak çalışır. | ||||||
5 | Geliştirilmiş uygulama veya yazılımın test aşamalarını gerçekler ve takip eder. | ||||||
6 | İşyeri uygulamaları, çalışanların sağlığı, çevre ve iş güvenliği, mesleki ve etik sorumluluk, programlama uygulamalarının hukuksal sonuçları konularında farkındalığa sahiptir. | ||||||
7 | Bilgiye erişir ve bu amaçla kaynak araştırması yapar. | ||||||
8 | Yaşam boyu öğrenmenin gerekliliği bilincindedir; bilim ve teknolojideki gelişmeleri izler ve kendini sürekli yeniler. | ||||||
9 | Sözlü ve yazılı, gerektiğinde teknik resimler ve modern araçlar kullanarak etkin iletişim kurar. | ||||||
10 | Yazılım çözümlerinin ve uygulamalarının evrensel ve toplumsal boyutlardaki etkilerinin bilincinde olur; çağın sorunları çözmede ve toplumsal ilerlemede yeni yazılımlar geliştirir. | ||||||
11 | Geliştirdiği yazılımın temiz ve anlaşılır olmasına özen ve dikkat gösterir. | ||||||
12 | Kullanıcı odaklı tasarım ilkelerine riayet eder. |
Assessment Methods
Contribution Level | Absolute Evaluation | |
Rate of Midterm Exam to Success | 40 | |
Rate of Final Exam to Success | 60 | |
Total | 100 |
ECTS / Workload Table | ||||||
Activities | Number of | Duration(Hour) | Total Workload(Hour) | |||
Course Hours | 0 | 0 | 0 | |||
Guided Problem Solving | 0 | 0 | 0 | |||
Resolution of Homework Problems and Submission as a Report | 0 | 0 | 0 | |||
Term Project | 0 | 0 | 0 | |||
Presentation of Project / Seminar | 0 | 0 | 0 | |||
Quiz | 0 | 0 | 0 | |||
Midterm Exam | 0 | 0 | 0 | |||
General Exam | 0 | 0 | 0 | |||
Performance Task, Maintenance Plan | 0 | 0 | 0 | |||
Total Workload(Hour) | 0 | |||||
Dersin AKTS Kredisi = Toplam İş Yükü (Saat)/30*=(0/30) | 0 | |||||
ECTS of the course: 30 hours of work is counted as 1 ECTS credit. |
Detail Informations of the Course
Course Description
Course | Code | Semester | T+P (Hour) | Credit | ECTS |
---|---|---|---|---|---|
DATABASE PROGRAMMING I | BPR1114984 | Fall Semester | 4+0 | 4 | 7 |
Course Program | Perşembe 16:30-17:15 Perşembe 17:30-18:15 Perşembe 18:30-19:15 Perşembe 19:30-20:15 |
Prerequisites Courses | |
Recommended Elective Courses |
Language of Course | Turkish |
Course Level | Short Cycle (Associate's Degree) |
Course Type | Required |
Course Coordinator | Lect. Nada A. M. MISK |
Name of Lecturer(s) | Lect. Nada A. M. MISK |
Assistant(s) | Microsoft SQL Server |
Aim | Students should understand the concept of a database and that a database is the basic element of a software To teach SQL language effectively to students and to teach the platforms that will use this language to students to introduce them to the world is one of the objectives of the course. |
Course Content | This course contains; General information about database systems. Database types and usage areas,Entity Relational Model, Relational Model, Object Oriented Database Design Concepts. Types of Relationships between Entities One to One, One to Many, Many to One, Many to One, Many to Many relationships.,Database schema design Primary key, attribute, record concepts. Design and importance of auxiliary tables. Entity tables, Relationship tables. . Schema design for concurrent access.,Normalization, Prevention of Data Repetition ,Applied database design,Applied Database Design, SQL: Select, union, distinct, where, having, group by concepts and sample queries.,Stored Procedure,Functions,Cursor ,Tigers,User and role definitions,General Review. |
Dersin Öğrenme Kazanımları | Teaching Methods | Assessment Methods |
Learns the concept of database and file systems. Understands the advantages of VTYS. | 17, 9 | A, E, F, G |
Schematically builds the entity relational model for any software | 14, 17, 9 | A, E, F, G |
Makes queries on the database with SQL language | 12, 14, 17, 6, 9 | A, E, F, G |
C# uses SQL language embedded in languages such as VB | 11, 12, 16, 17, 6, 9 | A, E, F, G |
Designs web-based database applications | 10, 16, 17, 8, 9 | A, E, F, G |
Analyzes the whole by looking at the software from the database point of view | 10, 11, 17, 9 | A, E, F |
Teaching Methods: | 10: Discussion Method, 11: Demonstration Method, 12: Problem Solving Method, 14: Self Study Method, 16: Question - Answer Technique, 17: Experimental Technique, 6: Experiential Learning, 8: Flipped Classroom Learning, 9: Lecture Method |
Assessment Methods: | A: Traditional Written Exam, E: Homework, F: Project Task, G: Quiz |
Course Outline
Order | Subjects | Preliminary Work |
---|---|---|
1 | General information about database systems. Database types and usage areas | |
2 | Entity Relational Model, Relational Model, Object Oriented Database Design Concepts. Types of Relationships between Entities One to One, One to Many, Many to One, Many to One, Many to Many relationships. | |
3 | Database schema design Primary key, attribute, record concepts. Design and importance of auxiliary tables. Entity tables, Relationship tables. . Schema design for concurrent access. | |
4 | Normalization, Prevention of Data Repetition | |
5 | Applied database design | |
6 | Applied Database Design | |
7 | SQL: Select, union, distinct, where, having, group by concepts and sample queries. | |
8 | Stored Procedure | |
9 | Functions | |
10 | Cursor | |
11 | Tigers | |
12 | User and role definitions | |
13 | General Review |
Resources |
[1] Database Mangement Systems, R. Ramakrishnan, J.Gehrke, Second Edition – Mc Graw Hill. [2] Database System Concepts, A. Silberschatz |
Course Contribution to Program Qualifications
Course Contribution to Program Qualifications | |||||||
No | Program Qualification | Contribution Level | |||||
1 | 2 | 3 | 4 | 5 | |||
1 | Algoritma programlama, bilgisayar uygulaması geliştirme ve yazılım projelerinde kod geliştirme konularında yeterli altyapıya ve bunları iş hayatlarında kullanma yeteneğine sahiptir. | ||||||
2 | Programlama problemleri için bilinen çözüm yöntemlerini ve özel teknikleri kullanır ve uygular. | ||||||
3 | Yazılım uygulamaları için gerekli olan modern teknik ve araçları kullanır. | ||||||
4 | Bireysel olarak ve çok disiplinli takımlarda etkin olarak çalışır. | ||||||
5 | Geliştirilmiş uygulama veya yazılımın test aşamalarını gerçekler ve takip eder. | ||||||
6 | İşyeri uygulamaları, çalışanların sağlığı, çevre ve iş güvenliği, mesleki ve etik sorumluluk, programlama uygulamalarının hukuksal sonuçları konularında farkındalığa sahiptir. | ||||||
7 | Bilgiye erişir ve bu amaçla kaynak araştırması yapar. | ||||||
8 | Yaşam boyu öğrenmenin gerekliliği bilincindedir; bilim ve teknolojideki gelişmeleri izler ve kendini sürekli yeniler. | ||||||
9 | Sözlü ve yazılı, gerektiğinde teknik resimler ve modern araçlar kullanarak etkin iletişim kurar. | ||||||
10 | Yazılım çözümlerinin ve uygulamalarının evrensel ve toplumsal boyutlardaki etkilerinin bilincinde olur; çağın sorunları çözmede ve toplumsal ilerlemede yeni yazılımlar geliştirir. | ||||||
11 | Geliştirdiği yazılımın temiz ve anlaşılır olmasına özen ve dikkat gösterir. | ||||||
12 | Kullanıcı odaklı tasarım ilkelerine riayet eder. |
Assessment Methods
Contribution Level | Absolute Evaluation | |
Rate of Midterm Exam to Success | 40 | |
Rate of Final Exam to Success | 60 | |
Total | 100 |