A tantárgyleírás hatályossága
Hatályosság kezdete:
2026. March 21.
Hatályosság vége:
—
| Subject name (Hungarian, English) |
Adatbáziskezelés
Database Management
|
||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Subject code | BMEVISZA027 | ||||||||||||
| Subject type | — | ||||||||||||
| Training Level | — | ||||||||||||
| Course types and hours (weekly/semester) |
|
||||||||||||
| Assessment type | vizsga | ||||||||||||
| Credits | 4 | ||||||||||||
| Subject coordinator |
DR. Gajdos Sándor
position: adjunktus
contact:
gajdos.sandor@vik.bme.hu
|
||||||||||||
| Responsible department |
Számítástudományi és Információelméleti Tanszék
|
||||||||||||
| Faculty | Villamosmérnöki és Informatikai Kar | ||||||||||||
| Subject website | https://www.db.bme.hu/Adatbaziskezeles/ | ||||||||||||
| Primary curriculum type | — | ||||||||||||
| Direct prerequisites – Strong prerequisite | none | ||||||||||||
| Direct prerequisites – Weak prerequisite | none | ||||||||||||
| Direct prerequisites – Parallel prerequisite | none | ||||||||||||
| Direct prerequisites – Milestone prerequisite | none | ||||||||||||
| Direct prerequisites – Exclusion | none |
Objectives
Programme
1. Database Management Systems, expectations on the system, parts of the system. The history of database management systems, database management systems incidence levels.
2. Data Modeling Concepts, E/R diagrams, Data Modeling Concepts, entities, attributes, specifying relationships, E/R link types, changing multiple connections to binary, subclasses, constraints.
3. Relational data model, relational algebra operations, derivative transactions, E/R conversion to relational schema.
4. Tuple relational and domain relational calculus, examples safe expressions.
5. SQL basic concepts, statements, DML, DDL, nested queries, examples.
6. Using MySQL
7. Functional dependence, logical consequences, Armstrong axioms. Closure, truth and completeness theorem.
8. Key, key algorithms in the closure, decomposition and faithful decomposition, BCNF, normalization, dependency preserving decomposition.
9. 3NF, decmposition to 3NF. Implementation of queries, physical design, optimization of queries.
10. Physical organization: basic concepts, sequential organization, hash, dynamic hash, increasing hash, indexing concepts, sparse and dense index.
11. Transaction Management Concepts: Concept of transactions, atomicity, isolation, consistency, durability. Multi-user operation: serial, serializability, serializability with locks.
12. serializability testing in simple transaction model with serialization graph; Serialization graph, 2PL. RLOCK / WLOCK model: lock types and thier use, problems with locks, two methods to test serializability.
13. System errors: logging, recovery, UNDO, REDO protocol UNDO / REDO protocol archiving.
14. Non-relational databases.
Basic knowledge about the use, operation and creation of database management systems. How to apply these in practice.
Learning outcomes
Ez a tantárgy a KKK rendeletben meghatározott, következő kompetenciák fejlesztését szolgálja:
Knowledge
No learning outcomes recorded.
Skills
No learning outcomes recorded.
Attitudes
No learning outcomes recorded.
Autonomy and responsibility
No learning outcomes recorded.
Oktatási módszertan
lectures and practice sessions
Tanulástámogató anyagok
Online források
Ullman, Widom: A First Course in Database Systems (2014) Pearson; Garcia-Molina, Ullman, Widom: Database systems: The complete book (2009) Prentice Hall
Recommended preliminary knowledge for completing the subject
Knowledge type competencies
(azon előzetes ismeretek összessége, amelyek megléte nem kötelező, de a tantárgy eredményes teljesítését nagyban elősegíti)
Basic programming skills; general awareness programming languages; data structures, basic knowledge of algorithms.
Skill type competencies
(azon előzetes képességek és készségek összessége, amelyek megléte nem kötelező, de a tantárgy eredményes teljesítését nagyban elősegíti)
nincs
Recommended (non-compulsory) preliminary competencies
(azon ajánlott (nem kötelező) előzetesen megszerzendő kompetenciák összessége, amelyek jelentősen hozzájárulnak a tantárgy eredményes teljesítéséhez)
Basic programming skills; general awareness programming languages; data structures, basic knowledge of algorithms.
General rules
Requirements:
Midterm during the semester.
Final: written and oral.
Additional possibilities:
One midterm retake during the semester.
Assessment methods
In-term assessments
No detailed assessments provided.
Weight of in-term assessments
No weights provided.
Exam-period assessments
No detailed assessments provided.
Weight of exam elements
No weights provided.
Grade calculation
No grade thresholds provided.
Attendance requirements
No attendance requirements provided.
Rules for retake and resubmission
Not provided.
Short description
Not provided.
Detailed description
Not provided.
Recommended courses
Combinatorics and graph theory (BMEVISZA025)
Theory of Algorithms (BMEVISZAB01)
Not intended for students of Software Engineering
Workload to complete the subject
No workload breakdown provided.
Validity of subject requirements
Requirements valid from:
—
Requirements valid until:
—
Curriculum placement
No curriculum placements recorded for this subject version.