65 students from the Department of Software Engineering and Automatics (ISA) from Faculty of Computers, Informatics and Microelectronics (FCIM), participated in the 4th edition of the contest “Database Management”, held online on the platform Microsoft TEAMS.
The participants in the competition were greeted by assoc. prof., Dr. Dumitru CIORBĂ, dean of FCIM, assoc. prof., Dr. Ion FIODOROV, head of ISA Department, and Dorian SARANCIUC, professor of the “Database” course and the moderator of the competition, who urged the students to fully embrace their ingenuity, inventiveness and imagination, and exploit the knowledge and analytical, design and management skills acquired during the Database courses. The competition aims to bring forward the technical creativity and team spirit of those participating.
The contestants – students of the study programs “Information Technology”, “Information Security” and “Software Engineering” – were tasked with developing a database for Bank deposits, which would contain information about customers, current and deposit accounts of the branches in which the accounts are opened, the conditions for attracting deposits and their types, and money transactions. In stage I, the students were to logically design a Database, which would include collecting the necessary information and recording it in the database, dividing it into tables by categories (customers, accounts, branches), configuring the relationships between the tables, and applying the normalization rules for data. When creating the tables and defining the constraints, the students were to use the SQL language, represented in a single script with comments, launch the code and present the BD diagram. Stage II included 3 steps: Database administration; Database query (5 queries in SQL 5, using the functions of aggregation, grouping, subquery and joins); performing various transactions – registering a new customer, opening a current account and a deposit account, linked to the account; entering the amount of money in the account; the transfer of money from the current account to the newly created deposit account.
During the 8 hours of the competition, the 13 teams demonstrated their ability to work in teams, formulate and distribute tasks and manage time efficiently in terms of logical database design, table creation and defining integrity constraints, managing, querying and performing transactions in the database – skills the students acquired during the “Databases” courses.
The jury, consisting of Vitalie VALACHE, senior Data Consultant, and TUM graduates Alexandru FRECĂUȚAN, Data Consultant, ICS ENDAVA SRL; Iurii HOHAN, full stack engineer, Mixbook SRL; Boris GALCENCO, Data Science Team Lead, Mezellini Group of Companies, announced the winners:
First place: “sALTER mortale” team (gr. TI-196) – Roman COVALI (captain), Nicolai SCURTU, Eduard ȚURCAN, Iana ZABOLOTNÎI, Alexei COZMA, who also won the Grand Prize – a voucher worth 1600 lei for each member of the team from the company “Endava” and a T-shirt offered by the company “Mixbook”.
Second place: “SELECT us” team (FAF-203) – Maria-Mădălina UNGUREANU (captain), Irina TIORA, Marcel VLASENCO, Daniela AFTENI, Valeria DUBINA; and “DataPower” team (gr. TI-195) – Valeriu POPA (captain), Dan ROTARU, Gheorghe ISAC, Ana GHERLAC, Cristian BORODIN; prizes – a voucher worth 800 lei for each member of the two teams.
Third place: „Ctrl + F5” team (FAF-202) – Anastasia IAȚCO (captain), Iulia TARUS, Marius PURICI, Dan CEBAN, Victor BOTNARU; „01jan70” team (gr. SI-191, TI-193) – Cătălin MÎȚU (captain), Andrei PAVALACHI, Octavian MAGDEI, Alexandru PANCO, Alina ENACHE; „DBSM – DataBase Solution Makers” team (gr. TI-197, TI-196) – Nicolae ȘARAFUDINOV (captain), Nichita MACHEEV, Dmitrii ROMANENCO, Lucia NIGAI, Oleg BOGACI; prizes – 500 lei for each member of the three teams.
The students of the 6 award-winning teams benefited from souvenirs with the “Endava” logo.
The competition concluded with a roundtable meeting of the members of the jury and the organizers, who appreciated the level of training of students in the management of Databases and were open for further discussions on the establishment of new collaborative relationships between companies, teachers and students, in order to ensure an efficient transfer of knowledge and experience in the field.
The management of the Faculty of Computers, Informatics and Microelectronics and of the Department of Software Engineering and Automatics expresses their gratitude to the professors of the “Databases” course – Dorian SARANCIUC, Rodica BULAI, Octavian RĂDUCANU, Corina SCLIFOS, Sergiu SCROB, and to the sponsors and partners of the contest – ICS ENDAVA SRL, Mixbook SRL, Mezellini, Technical University of Moldova – for support, generosity and contribution to the successful organization of the contest.
[av_gallery ids=’98972,98973,98974,98975,98976,98977,98978,98979,98980,98981,98982,98983,98984,98985′ style=’big_thumb’ preview_size=’2048×2048′ crop_big_preview_thumbnail=’avia-gallery-big-crop-thumb’ thumb_size=’2048×2048′ columns=’7′ imagelink=’lightbox’ link_dest=” lightbox_text=’caption’ lazyload=’avia_lazyload’ img_scrset=” html_lazy_loading=’disabled’ alb_description=” id=” custom_class=” template_class=” av_uid=’av-11p9uze’ sc_version=’1.0′ admin_preview_bg=”]
[av_gallery ids=’98986′ style=’big_thumb lightbox_gallery’ preview_size=’2048×2048′ crop_big_preview_thumbnail=’avia-gallery-big-crop-thumb’ thumb_size=’portfolio’ columns=’5′ imagelink=’lightbox’ link_dest=” lightbox_text=’caption’ lazyload=’avia_lazyload’ img_scrset=” html_lazy_loading=’disabled’ alb_description=” id=” custom_class=” template_class=” av_uid=’av-jl5s3e’ sc_version=’1.0′ admin_preview_bg=”]
