Subject Datasheet
Completion requirements
Subject Datasheet
Download PDFI. Subject Specification
1. Basic Data
1.1 Title
Database systems
1.2 Code
BMEEOFTMSFCI04-00
1.3 Type
Module with associated contact hours
1.4 Contact hours
| Type | Hours/week / (days) |
| Lecture | 1 |
| Seminar | 2 |
1.5 Evaluation
Midterm grade
1.6 Credits
4
1.7 Coordinator
| name | Dr. Koppányi Zoltán |
| academic rank | Associate professor |
| koppanyi.zoltan@emk.bme.hu |
1.8 Department
Department of Photogrammetry and Geoinformatics
1.9 Website
1.10 Language of instruction
hungarian
1.11 Curriculum requirements
Compulsory in the Construction Information Technology Engineering (MSc) programme
1.12 Prerequisites
1.13 Effective date
1 September 2025
2. Objectives and learning outcomes
2.1 Objectives
The course aims to introduce databases and database management systems to students.
Further goal to give the sutdents tools to query relational databases and hence to deliver
actionable data from existing databases. Students will get familiar to database design and
will be able to cooperate with IT professionals during the design of complicated databases.
2.2 Learning outcomes
Upon successful completion of this subject, the student:
A. Knowledge
1. understand the concepts of relational databases,
2. understands the advantages and disadvantages of relational databases,
3. familiar with the most popular database managment systems,
4. understands queries written in SQL,
5. familiar with the steps of database design
6. knows the steps of normalization and how to store data without redundancy.
B. Skills
1. is able to create the specification of an engineering task that can be solved with databases,
2. design a redundancy-free relational database based on a suitable specification,
3. is able to implement a relational database in a database management system,
4. is able to formulate analyzes using SQL language,
5. is able to automatically process and convert data sources and then load them into a database.
C. Attitudes
1. open to the use of information technology tools,
2. seeks to solve an engineering problem with the help of co-actors,
3. actively participates during the class.
D. Autonomy and Responsibility
Openly answers her colleagues' questions and seeks professionally correct answers to them.
2.3 Methods
Lectures, exercises, written and oral communication, use of IT tools and techniques,
independent and group work, work organization techniques.
2.4 Course outline
1. Lecture: Introduction, Lab: Relational algebra
2. Lab: Relational algebra
3. Lecture: SQL queries (SELECT-WHERE), Lab: SQL SELECT-WHERE with one table
4. Lab: SQL queries: SELECT-WHERE with multiple tables
5. Lecture: SQL queries (Grouping & aggregations), Lab: SQL aggregations
6. Lab: SQL grouping & aggregations
7. Lecture: SQL Data Definition Language& CRUD, Lab: SQL practice before midterm
8. Midterm
9. Lecture: Database design 1 (concepts, ER diagram), Lab: Database design practice
10. Lab: Database design practice
11. Lecture: Database design 2 (database schema diagram), Lab: Intro to MS Access.
12. Lab: Building a database with MS Access
13. Lecture: Managing databases (security, access control, legal aspects), Lab: Consultation / back-up
14. Databases in the Civil Engineering Practice: Invited talk
The above programme is tentative and subject to changes due to calendar variations and other reasons specific to the actual semester. Consult the effective detailed course schedule of the course on the subject website.
The above programme is tentative and subject to changes due to calendar variations and other reasons specific to the actual semester. Consult the effective detailed course schedule of the course on the subject website.
2.5 Study materials
a) Books:
Avi Silberschatz, Henry F. Korth, S. Sudarshan: Database System Concepts - Seventh Edition, 2019 McGraw-Hill, ISBN: 9780078022159
Jeffrey D. Ullman, Jennifer Widom: Database systems - The Complete Book, 2008.
b) Online materials:
Presentation slides
Access tutorial
2.6 Other information
0
2.7 Consultation
Consultation hours: as specified on the department's website, or by prior arrangement via email.
This Subject Datasheet is valid for:
2026/2027 semester I
II. Subject requirements
Assessment and evaluation of the learning outcomes
3.1 General rules
Learning outcomes formulated in point 2.2 are assessed on one test, two assignments, and active participation in the exercises (partial performance assessment).
3.2 Assessment methods
| Assessment Name (Type) | Code | Assessed Learning Outcomes |
|---|---|---|
| Midterm | MT1 | A.1-A.6, B.4, C.1 |
| Home assignment 1 | HA1 | A.2-4, C.3 |
| Home assignment 2 | HA2 | A.5-6, B.1-5, C.1-2 |
| Participatn | P | C.1-3 |
The dates of deadlines of assignments/homework can be found in the detailed course schedule on the subject’s website.
3.3 Evaluation system
| Code | Weight |
|---|---|
| MT1 | 45 |
| HA1 | 20 |
| HA2 | 30 |
| P | 5 |
| Total | 100% |
3.4 Requirements and validity of signature
3.5 Grading system
| Grade | Score (P) |
|---|---|
| excellent (5) | 85≤P |
| good (4) | 75≤P<85% |
| satisfactory (3) | 65≤P<75% |
| pass (2) | 50≤P<65% |
| fail (1) | P<50% |
3.6 Retake and repeat
Students can retake midterm.
3.7 Estimated workload
| Activity | Hours/Semester |
|---|---|
| participation in contact classes | 14x3=42 |
| assignment 1 | 10 |
| assignment 2 | 28 |
| preparation for midterm | 34 |
| independent acquisition of designated written curriculum | 6 |
3.8 Effective date
1 September 2025
This Subject Datasheet is valid for:
2026/2027 semester I