Study programme 2024-2025Français
SQL and NoSQL database management
Programme component of Master's in Computer Engineering and Management (CHARLEROI) (shift schedule) à la Faculty of Engineering

CodeTypeHead of UE Department’s
contact details
Teacher(s)
UI-M1-IRIGIG-312-CCompulsory UEMAHMOUDI SidiF114 - Informatique, Logiciel et Intelligence artificielle
  • BENJELLOUN Mohammed
  • MAHMOUDI Sidi

Language
of instruction
Language
of assessment
HT(*) HTPE(*) HTPS(*) HR(*) HD(*) CreditsWeighting Term
  • Français
Français183000055.001st term

AA CodeTeaching Activity (AA) HT(*) HTPE(*) HTPS(*) HR(*) HD(*) Term Weighting
I-ILIA-103SQL and NoSQL database management1830000Q1100.00%

Programme component

Objectives of Programme's Learning Outcomes

  • Imagine, design, develop, and implement conceptual models and computer solutions to address complex problems including decision-making, optimisation, management and production as part of a business innovation approach by integrating changing needs, contexts and issues (technical, economic, societal, ethical and environmental).
    • Identify complex problems to be solved and develop the specifications with the client by integrating needs, contexts and issues (technical, economic, societal, ethical and environmental).
    • On the basis of modelling, design a system or a strategy addressing the problem raised; evaluate them in light of various parameters of the specifications.
    • Deliver a solution selected in the form of diagrams, graphs, prototypes, software and/or digital models.
  • Mobilise a structured set of scientific knowledge and skills and specialised techniques in order to carry out computer and management engineering missions, using their expertise and adaptability.
    • Master and appropriately mobilise knowledge, models, methods and techniques specific to computer management engineering.
    • Analyse and model an innovative IT solution or a business strategy by critically selecting theories and methodological approaches (modelling, optimisation, algorithms, calculations), and taking into account multidisciplinary aspects.
    • Identify and discuss possible applications of new and emerging technologies in the field of information technology and sciences and quantifying and qualifying business management.
  • Plan, manage and lead projects in view of their objectives, resources and constraints, ensuring the quality of activities and deliverables.
    • Define and align the project in view of its objectives, resources and constraints.
    • Exploit project management principles and tools, particularly the work plan, schedule, document monitoring, versioning and software development methodologies.
    • Assess the approach and achievements, regulate them in view of the observations and feedback received.
  • Work effectively in teams, develop leadership, and make decisions in multidisciplinary, multicultural and international contexts.
    • Interact effectively with others to carry out common projects in various contexts (multidisciplinary, multicultural, and international).
    • Contribute to the management and coordination of a team that may be composed of people of different levels and disciplines.
    • Identify skills and resources, and research external expertise if necessary.
  • Communicate and exchange information in a structured way - orally, graphically and in writing, in French and in one or more other languages - scientifically, culturally, technically and interpersonally, by adapting to the intended purpose and the relevant public.
    • Argue to and persuade customers, teachers and boards, both orally and in writing.
    • Select and use the written and oral communication methods and materials adapted to the intended purpose and the relevant public.
    • Use and produce scientific and technical documents (reports, plans, specifications) adapted to the intended purpose and the relevant public.
  • Adopt a professional and responsible approach, showing an open and critical mind in an independent professional development process.
    • Analyse their personal functioning and adapt their professional attitudes.
    • Finalise a realistic career plan in line with the realities in the field and their profile (aspirations, strengths, weaknesses, etc.).
  • Contribute by researching the innovative solution of a problem in engineering sciences.
    • Construct a theoretical or conceptual reference framework, formulate innovative solutions from the analysis of scientific literature, particularly in new or emerging disciplines.
    • Develop and implement conceptual analysis, numerical modelling, software implementations, experimental studies and behavioural analysis.
    • Collect and analyse data rigorously.

Learning Outcomes of UE

UE composed of :
- AA "Banque de données"

UE Content: description and pedagogical relevance

- Banque de données : I-ILIA-103

Prior Experience

Not applicable

Type of Teaching Activity/Activities

AAType of Teaching Activity/Activities
I-ILIA-103
  • Cours magistraux
  • Exercices dirigés
  • Démonstrations

Mode of delivery

AAMode of delivery
I-ILIA-103
  • Face-to-face

Required Learning Resources/Tools

AARequired Learning Resources/Tools
I-ILIA-103Not applicable

Recommended Learning Resources/Tools

AARecommended Learning Resources/Tools
I-ILIA-103Not applicable

Other Recommended Reading

AAOther Recommended Reading
I-ILIA-103Not applicable

Grade Deferrals of AAs from one year to the next

AAGrade Deferrals of AAs from one year to the next
I-ILIA-103Unauthorized

Term 1 Assessment - type

AAType(s) and mode(s) of Q1 assessment
I-ILIA-103
  • Written examination - Face-to-face
  • Production (written work, report, essay, collection, product, etc.) - To be submitted in class
  • Oral examination - Face-to-face

Term 1 Assessment - comments

AATerm 1 Assessment - comments
I-ILIA-103Completion of a database management project during the term. Submission of the project report one week before the exam.
Oral presentation: group presentation (30 min) of the project carried out. Assessment criteria for the oral: technical quality of the project (modelling, SQL queries, interface and implementation), quality of the presentation, quality of the report; weighting 50%.
Written test: will focus on the theoretical concepts seen in the course (independent of the oral and the project); duration 1 hour; weighting 50%.

Resit Assessment - Term 1 (B1BA1) - type

AAType(s) and mode(s) of Q1 resit assessment (BAB1)
I-ILIA-103
  • Written examination - Face-to-face
  • Production (written work, report, essay, collection, product, etc.) - To be submitted in class

Term 3 Assessment - type

AAType(s) and mode(s) of Q3 assessment
I-ILIA-103
  • Written examination - Face-to-face
  • Production (written work, report, essay, collection, product, etc.) - To be submitted in class
  • Oral examination - Face-to-face

Term 3 Assessment - comments

AATerm 3 Assessment - comments
I-ILIA-103idem Q1
(*) HT : Hours of theory - HTPE : Hours of in-class exercices - HTPS : hours of practical work - HD : HMiscellaneous time - HR : Hours of remedial classes. - Per. (Period), Y=Year, Q1=1st term et Q2=2nd term
Date de dernière mise à jour de la fiche ECTS par l'enseignant : 13/05/2024
Date de dernière génération automatique de la page : 14/03/2025
20, place du Parc, B7000 Mons - Belgique
Tél: +32 (0)65 373111
Courriel: info.mons@umons.ac.be