Database Management Systems
Software Engineering
Faculty of Engineering
First Cycle (Bachelor's Degree)
| Course Unit Title | Course Unit Code | Type of Course Unit | Level of Course Unit | Year of Study | Semester | ECTS Credits |
|---|---|---|---|---|---|---|
| Database Management Systems | YZM303 | Compulsory | Bachelor's degree | 3 | Fall | 5 |
Name of Lecturer(s)
Associate Prof. Dr. Hakan GÜNDÜZ
Assistant Prof. Dr. Yasemin GÜLTEPE
Assistant Prof. Dr. İrfan KÖSESOY
Learning Outcomes of the Course Unit
1) Recognize the concepts of database management systems.
2) Classify database management systems.
3) Design the Entity Relationship Model (VIM) for the database.
4) Apply the normalization rules on the database.
5) Apply SQL commands on database.
6) Design a database.
7) Define the relational algebra operations.
Program Competencies-Learning Outcomes Relation
| Program Competencies | |||||||||||||
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | ||
| Learning Outcomes | |||||||||||||
| 1 | High | Low | Low | Middle | Low | Low | Low | Low | Low | Low | Low | Low | |
| 2 | High | Middle | Low | Middle | Low | Low | Low | Low | Low | Low | Low | Low | |
| 3 | High | High | High | Middle | Middle | Low | Middle | Middle | Middle | Low | Low | Low | |
| 4 | High | High | Low | Middle | Low | Low | Low | Low | Low | Low | Low | Low | |
| 5 | High | High | Low | Middle | Middle | Low | Low | High | Low | Low | High | Low | |
| 6 | High | High | Middle | Middle | High | Low | Low | High | High | Low | High | Low | |
| 7 | High | High | Middle | Middle | Middle | Low | Low | High | Low | Low | High | Low | |
Mode of Delivery
Face to Face
Prerequisites and Co-Requisites
None
Recommended Optional Programme Components
Not Required
Course Contents
Components of database systems, database management system (DBMS) functions, architecture, data independence, data models, conceptual models, object oriented models and relational data model. Translation of conceptual schemas into relational schemas, relational algebra and relational computation, links, key types, functional dependency, normal forms, multivalued dependency and database design. In SQL; data definition, relational query, data editing, use of SQL in applications and updating a designed database. Creating a transaction using SQL, efficiency characteristics, uncovering probabilities, reliability levels, concurrency, errors and solutions, protection levels, distributed data storage, distributed data processing, distributed transaction model, concurrent control, homogeneous and heterogeneous solutions. File structures, index files, complex (hash) files, signature files, binary tree, multi-indexed files, variable compatibility registered files.
Weekly Schedule
1) Introduction to database systems2) Relational Data Model-Relational Model
3) Relational Data Model-Relational Algebra
4) Database Design-ER Data Model
5) Database Design-ER Data Model
Recommended or Required Reading
Planned Learning Activities and Teaching Methods
Assessment Methods and Criteria
Contribution of Semester Studies to Course Grade |
50% |
|||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
||||||||||||
Contribution of Final Examination to Course Grade |
50% |
|||||||||||
Total | 100% | |||||||||||
Language of Instruction
English
Work Placement(s)
Not Required