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ázisok
Databases
|
||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Subject code | BMEVITMAB04 | ||||||||||||
| Subject type | — | ||||||||||||
| Training Level | — | ||||||||||||
| Course types and hours (weekly/semester) |
|
||||||||||||
| Assessment type | vizsga | ||||||||||||
| Credits | 5 | ||||||||||||
| Subject coordinator |
DR. Gajdos Sándor
position: adjunktus
contact:
gajdos.sandor@vik.bme.hu
|
||||||||||||
| Responsible department |
Távközlési és Mesterséges Intelligencia Tanszék
|
||||||||||||
| Faculty | Villamosmérnöki és Informatikai Kar | ||||||||||||
| Subject website | — | ||||||||||||
| 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
- Data and information, structured, non-structured and semistructured data
- Database management systems, components, operation
- Data Definition Language, Data Manipulation Language, Host language
- Layered model of DBMS, principle of data independence
- Data models, data modelling.
- Entity-relationship model/diagram, attributes, relationship-types, constraints, specialization, weak entity sets.
- Relational data model, relational algebra
- Design of relational schemes from E/R diagram
- Physical data organization: heap, hash, indexing (sparse, dense) (flat, multilevel)
- Tuple relational calculus, domain relational calculus, safe expressions.
- Functional dependencies, key, superkey, candidate key
- Normal forms of 0NF, 1NF, 2NF, 3NF, BCNF
- Fundamentals of transaction management
Laboratory synopsis:
- Getting to know a relational database management system
- Definition of relational schemes in SQL
- Database queries in SQL
- Manipulation of data in SQL
- Team workshop on database schema design
To
make students familiar with the operation and usage of database
management systems. Application of the theory also in the engineering
practice focusing on relational systems.
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
Interactive lectures.
Bi-weekly practices.
The laboratories are scheduled biweekly. Individual preparation is needed for the labs from the specific materials provided
by the tutor, then consultation, working on the predefined tasks in the
computer laboratory of the university under the supervision of the
tutor. The students may finish their tasks and the laboratory report at
home as well.
Tanulástámogató anyagok
Online források
Recommended books: Silberschatz, H. F. Korth, S. Sudarshan: Database System Concepts, 6th Edition, 2010.Ullman: Principles of Database and Knowledge-Base Systems, Comp. Sci. Press vol. I-II, 1990.; Ullman-Widom: First Course in Database Systems, 2007.; For the labs:; Syllabi provided by the tutorWeb pages identified by the tutor
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 technical knowledge about programming languages, data structures
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 technical knowledge about programming languages, data structures
General rules
Requirements:
In the teaching period: 1
midterm test including numerical and theoretical problems. 1 midterm retake.Laboratory: each laboratory practice must be completed at least on passed level.The
laboratory practices will be graded based on the a) preparation of the
student b) activity during the lab c) quality of the laboratory report.
Condition for the signature is passing the tests in average and all of the laboratory practices must be satisfactory at least.
In
the exam's period: written or oral exam, similar to the problems of the midterm
tests. Scoring condition for successful exam is at least 40%. Below 40%
the exam is unsuccessful. Calculation of the final grade: 30% Laboratory average + 70% written exam.
Additional possibilities:
Accordig to the Code of Studies and Exams.
Only one laboratory practice can be repeated during the semester if the
student failed or missed the lab.
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
Not provided.
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.