| Subject name (in Hungarian, in English) | Databases | |||
|
Databases
|
||||
| Neptun code | BMEGEMIBMAB | |||
| Type | study unit with contact hours | |||
| Course types and number of hours (weekly / semester) | course type: | lecture (theory) | exercise | laboratory excercise |
| number of hours (weekly): | 1 | 0 | 2 | |
| nature (connected / stand-alone): | - | - | coupled | |
| Type of assessments (quality evaluation) | mid-term grade | |||
| ECTS | 3 | |||
| Subject coordinator | name: | Dr. Fekete Róbert Tamás | ||
| post: | adjunct | |||
| contact: | frt@mogi.bme.hu | |||
| Host organization | Department of Mechatronics, Optics and Mechanical Engineering Informatics | |||
| https://www.mogi.bme.hu | ||||
| Course homepage | https://www.mogi.bme.hu/tantargyak/BMEGEMIBMAB | |||
| Course language | hungarian | |||
| Primary curriculum type | mandatory | |||
| Direct prerequisites | Strong prerequisite | BMEGEMIBMGP | ||
| Weak prerequisite | ||||
| Parallel prerequisite | ||||
| Milestone prerequisite | at least obtained 0 ECTS | |||
| Excluding condition | BMEGERIAM6A | |||
Aim
Get to know and apply practical solutions to problems and tasks that occur in engineering practice and require data management. Learn and apply object-relational data models and the associated SQL database language. Learn about the possibilities of applying what has been learned in production management and logistics tasks and apply it from a database manager or programming language environment.
Learning outcomes
Competences that can be acquired by completing the course
Knowledge
Knows the basics of SQL (Structured Query Language) database management. Knows the possible types of data connections and how they are represented. He knows the concept of the switchboard, its features and its use. You are familiar with the necessary knowledge about derived tables. You are familiar with the concept of queries and subqueries (uncorrelated, correlated). You are familiar with the concepts of stored procedures, transactions, and triggers. He is aware of what they are for and how to use the language elements that establish the database connection (ODBC, COM). You are aware of using different database engines in MySQL. He has the knowledge to make the connection with mathematical, optimal calculation methods. Systematizes production scheduling processes to implement them at the database level.
Ability
Use basic SQL statements to manage, create and delete tables and enter data. Apply the implementation of basic queries in databases. Query data from connection tables in databases. Able to create uncorrelated, correlated scalar and column subqueries. It queries grouped data independently in databases. He uses his practice to create temporal and view tables. Describes the goal-oriented transactions required to complete your task. Able to connect with mathematical, optimal calculation methods. It manages the various MySQL database engines in a task-oriented manner. Ability to implement production scheduling processes at the database level.
Attitude
It is receptive to expanding knowledge with the instructor and fellow students. With the help of available resources, it strives for the continuous expansion of knowledge. Open to the use of database-related information technology tools. It seeks to learn about and routinely use the tools needed to resolve storage access issues. It strives for an accurate and error-free solution.
Independence and responsibility
It independently thinks through data storage IT tasks and problems and solves them based on specific resources. It accepts substantiated critical remarks and acts accordingly. In some situations, as part of a team, you work with your fellow students to solve tasks. He makes a decision in his thinking that is in line with the systematic approach. He feels responsible for using resource-efficient methods.
Teaching methodology
The course draws on the tradition of frontal education in the form of lectures and laboratory exercises. Communication in addition takes place in writing and orally, using IT tools and techniques during consultations. The instructors make it possible to carry out optional tasks prepared independently and in group work, during which the acquired knowledge is better recorded and they also gain insight into work organization techniques.
Support materials
Textbook
Lecture notes
Online material
https://www.mogi.bme.hu/tantargyak/BMEGEMIBMAB
Validity of the course description
| Start of validity: | 2022. May 15. |
| End of validity: | 2026. July 15. |
General rules
Learning outcomes are assessed on the basis of a mid-year written performance measurement (a summary assessment of academic performance). In written examinations, only the topics defined by the instructor will be considered, and the use of aids defined by the instructor is allowed. During these performance appraisals, students are examined for the competencies of knowledge and skills acquired during the semester.
Assessment methods
Detailed description of mid-term assessments
| Mid-term assessment No. 1 | ||
| Type: | summative assessment | |
| Number: | 1 | |
| Purpose, description: | The complex, written way of evaluating the knowledge and ability type competence elements of the subject in the form of a closed dissertation focuses on the application of the acquired knowledge, so it focuses on problem recognition and solution solving, ie practical (calculation) tasks the part of the curriculum is determined by the lecturer of the subject in agreement with the supervisors, the available working time is 90 minutes; | |
| Mid-term assessment No. 2 | ||
| Type: | formative assessment, simple | |
| Number: | 1 | |
| Purpose, description: | Partial performance assessment (homework): a complex way of evaluating the competence elements of the subject's knowledge, ability, attitude and independence and responsibility type, the form of which is determined individually or in groups, the content, requirements and deadline of the homework assessment meg; Group participation is also possible in the preparation of the homework. | |
Detailed description of assessments performed during the examination period
The subject does not include assessment during the examination period.
The weight of mid-term assessments in signing or in final grading
| ID | Proportion |
|---|---|
| Mid-term assessment No. 1 | 50 % |
| Mid-term assessment No. 2 | 50 % |
The weight of partial exams in grade
There is no exam belongs to the subject.
Determination of the grade
| Grade | ECTS | The grade expressed in percents |
|---|---|---|
| very good (5) | Excellent [A] | above 90 % |
| very good (5) | Very Good [B] | 85 % - 90 % |
| good (4) | Good [C] | 70 % - 85 % |
| satisfactory (3) | Satisfactory [D] | 55 % - 70 % |
| sufficient (2) | Pass [E] | 40 % - 55 % |
| insufficient (1) | Fail [F] | below 40 % |
The lower limit specified for each grade already belongs to that grade.
Attendance and participation requirements
The lack of the value means that there is no attendance requirement.
At least 80% of laboratory practices (rounded down) must be actively attended.
Special rules for improving, retaken and replacement
The special rules for improving, retaken and replacement shall be interpreted and applied in conjunction with the general rules of the CoS (TVSZ).
| Need mid-term assessment to invidually complete? | ||
| yes | ||
| Can the submitted and accepted partial performance assessments be resubmitted until the end of the replacement period in order to achieve better results? | ||
| yes | ||
| The way of retaking or improving a summary assessment for the first time: | ||
| each summative assessment can be retaken or improved | ||
| Is the retaking-improving of a summary assessment allowed, and if so, than which form: | ||
| one single, combined retake or grade-improving exam is possible for all assesments | ||
| Taking into account the previous result in case of improvement, retaken-improvement: | ||
| new result overrides previous result | ||
| The way of retaking or improving a partial assessment for the first time: | ||
| partial assesment(s) in this group can be improved or repeated once up to the end of the repeat period | ||
| Completion of unfinished laboratory exercises: | ||
| missed laboratory practices may be performed in the teaching term at pre-arranged appointment, non-mandatory | ||
| Repetition of laboratory exercises that performed incorrectly (eg.: mistake in documentation) | ||
| incorrectly performed laboratory practice (e.g. Incomplete/incorrect report) can be corrected by repeating the practice | ||
Study work required to complete the course
| Activity | hours / semester |
|---|---|
| participation in contact classes | 42 |
| preparation for laboratory practices | 14 |
| preparation for summary assessments | 16 |
| elaboration of a partial assessment task | 4 |
| additional time required to complete the subject | 14 |
| altogether | 90 |
Validity of subject requirements
| Start of validity: | 2022. May 15. |
| End of validity: | 2026. July 15. |
Primary course
The primary (main) course of the subject in which it is advertised and to which the competencies are related:
Mechatronics engineering
Link to the purpose and (special) compensations of the Regulation KKK
This course aims to improve the following competencies defined in the Regulation KKK:
Knowledge
- Student has acquired a theoretically sound, systems-oriented and practice-oriented engineering mindset.
- Student has the knowledge of information and communication technologies relevant to the field.
Ability
- Student has the ability to process and organise information collected during the operation of mechatronic systems and processes, to analyse it in different ways and to draw theoretical and practical conclusions.
- Student has the ability to design complex mechatronic systems globally, based on a systems- and process-oriented, theoretically sound way of thinking.
Attitude
- In student's work, will explore and pursue research, development and innovation objectives, Student is committed to enriching the field of mechatronics engineering with new knowledge and scientific results.
- Student strives to carry out their work in a complex approach based on a systems and process-oriented mindset.
Independence and responsibility
- Student shares gained knowledge and experience with those working in the field through formal, non-formal and informal information transfer.
- Student takes an independent and proactive approach to solving professional problems.
Prerequisites for completing the course
|
Knowledge type competencies
(a set of prior knowledge, the existence of which is not obligatory, but greatly facilitates the successful completion of the subject) |
Fundamentals of Informatics and Computer Science (BMEGEMIBMIS) C ++ Programming (BMEGEMIBMCP) Modeling and Measurement Data Collection Software (BMEGEMIBMMM) |
|
Ability type competencies
(a set of prior abilities and skills, the existence of which is not obligatory, but greatly contributes to the successful completion of the subject) |
Programming skills, Mathematical interest, Systems approach |