Data Base Management Systems - I
Computer Programming
Vocational School of Kocaeli
Short Cycle (Associate's Degree)
| Course Unit Title | Course Unit Code | Type of Course Unit | Level of Course Unit | Year of Study | Semester | ECTS Credits |
|---|---|---|---|---|---|---|
| Data Base Management Systems - I | BPP211 | Compulsory | Associate degree | 2 | Fall | 4 |
Name of Lecturer(s)
Lecturer NEVIN ANTAR
Lecturer Burak ÇAKIR
Lecturer Birsen KÖSELE BAYHAN
Learning Outcomes of the Course Unit
1) Explain database concepts.
2) Compare the differences between database users.
3) Express the concept of data independence.
4) Explain to relationship of in database architecture components.
5) Use, explain and sample to relational model concepts.
6) Identify constraints to the relational model, express to using cases.
7) Write queries using the SQL SELECT statement.
8) Write action queries using with SQL INSERT, UPDATE, and DELETE statements.
Program Competencies-Learning Outcomes Relation
| Program Competencies | ||||||||||||||||
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | ||
| Learning Outcomes | ||||||||||||||||
| 1 | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | High | No relation | No relation | No relation | |
| 2 | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | High | No relation | No relation | No relation | |
| 3 | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | High | No relation | No relation | No relation | |
| 4 | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | High | No relation | No relation | No relation | |
| 5 | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | High | No relation | No relation | No relation | |
| 6 | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | High | No relation | No relation | No relation | |
| 7 | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | High | No relation | No relation | No relation | |
| 8 | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | High | No relation | No relation | No relation | |
Mode of Delivery
Face to Face
Prerequisites and Co-Requisites
None
Recommended Optional Programme Components
There is not.
Course Contents
Begining of Database Relational Data Model and SQL Conceptual Database Design Database Normalization Theory Query Processing, Optimization, and Database Tuning Movement Processing and Concurrency Control New Generation Database Applications
Weekly Schedule
1) The concept of database2) Introduction to structured query language
3) Basic SQL statements
4) Basic functions in the SQL: MIN, MAX, COUNT
5) Average and sum functions in SQL: AVG, SUM
6) Using a nested SELECT command
7) Using a nested SELECT command
8) Midterm examination/Assessment
9) Working with more than one table
10) Working with multiple tables and data
11) Enter data to the database with SQL
12) Updating the data
13) Delete data from table
14) Condition statement in SQL
15) Writing SQL commands for related tables
16) Final examination
Recommended or Required Reading
1- Veritabanı Yönetim Sistemleri ve SQL/PL-SQL/T-SQL , Zehra Alakoç BURMA , Seçkin Yayıncılık , 2009.
2- Veritabanı Yönetim Sistemleri , Yaşar DAŞDEMİR , Türkmen Kitabevi , 2004.
3- SQL Server ve Veritabanı , Yaşar GÖZÜDELİ , Seçkin Yayıncılık , 2010.
4- ¦¦¦
5- ¦¦¦
6- ¦¦¦
7- ¦¦¦
8- ¦¦¦
9- ¦¦¦
10- /¦¦¦
11- /¦¦¦
12- /¦¦¦
13- /¦¦¦
14- /¦¦¦
15- /¦¦¦
16- /¦¦¦
17- /¦¦¦
18- /¦¦¦
19- /¦¦¦
20- /¦¦¦
21- /¦¦¦
Planned Learning Activities and Teaching Methods
1) Lecture
2) Question-Answer
3) Discussion
4) Drill and Practice
5) Lab / Workshop
Assessment Methods and Criteria
Contribution of Midterm Examination to Course Grade |
30% |
|---|---|
Contribution of Final Examination to Course Grade |
70% |
Total |
100% |
Language of Instruction
Turkish
Work Placement(s)
Not Required