3 ECTS credits
84 h study time

Offer 1 with catalog number 1018537BNR for all students in the 1st semester at a (B) Bachelor - advanced level.

Semester
1st semester
Enrollment based on exam contract
Impossible
Grading method
Grading (scale from 0 to 20)
Can retake in second session
Yes
Taught in
Dutch
Faculty
Faculteit Ingenieurswetenschappen
Department
Industriële ingenieurswetenschappen
Educational team
Tom Godden
An Braeken (course titular)
Activities and contact hours
10 contact hours Lecture
12 contact hours Seminar, Exercises or Practicals
20 contact hours Independent or External Form of Study
Course Content

The course covers notions and concepts of relational databases with its standardization. The base of web technology is given so that coupling can be made with a database.

Lecture:

  • Fundamental concepts: relational databases and tables, database systems
  • Relational concepts: relationships, keys, functional dependencies, normalization
  • Structured Query Language SQL for data definition: insertion, retrieval, data modification and deletion; SQL for table and constraint modification or deletion; SQL Views
  • Data modeling and the Entity - Relationship data model
  • Database design conversion of a data model in a database design. Presentation of entities with the relational model
  • Advanced Topics control, safety and reliability
  • Web technology for interfacing with database
     

Practical exercises:
Students work on exercises or problems that have a direct connection with the concepts seen in the lecture.    

 

Self study:
Students develop a mid-sized webbased application.

     

Course material
Handbook (Recommended) : Database Concepts, D. M. Kroenke, 7de, Pearson, 9781292076232, 2015
Handbook (Recommended) : Databases, D.M. Kroenke, 11de, Pearson/Prentice Hall, 9789043019873, 2011
Digital course material (Required) : Slides, aansluitend bij het boek "Database Concepts" van Kroenke, A. Braeken
Additional info

Description tutoring: after class, by appointment or via e-mail.

Learning Outcomes

Learning outcomes

  • BaLO_2 To possess application-oriented knowledge, understanding and skills about engineering sciences and engineering techniques.
  • BaLO_3 To solve practical engineering problems from an understanding of the basic theory and from an understanding of basic methods for the schematisation and modelling of processes or systems.
  • BaLO_6 Based on acquired insight, to select the appropriate methods of research, design and solution and appropriately apply the results in a scientific and effective manner.
  • BaLO_9 To demonstrate an engineering attitude: attention to planning, to technical, economic and societal factors as well as managerial implications, assessment of the risks and feasibility of the proposed approach or solution, being result-driven and achieving effective solutions, innovative thinking.
  • BaLO_10 To correctly handle the scientific and discipline-specific terminology in language relevant to the programme.
  • BaLO_11 To present and communicate the results of technical and scientific work, in writing, orally and visually.
  • BaLO_13 To act in an ethical and socially responsible manner with attention to technical, economic, human and sustainability aspects.
  • BaSLO_14-ELO To possess application-oriented knowledge, understanding and skills in the broad field of engineering sciences and engineering techniques for electronics and ICT engineering.
     

Objectives

D1: knows the basic principles of a relational database application (BaLO 6, BaSLO 14 ELO)
D2: can for a particular sitation establish an appropriate data model and associated database (BaLO 3, 6, 11, BaSLO 14 ELO)
D3: can extract information from a database and write to a database via a web application (BaLO 2, 3; BaSLO 14 ELO)
D4: understands the different aspects and associated impacts of database administration (BaSLO 14 ELO)
 
AD1: reasons and acts in a structured and systematic manner (BaLO 9)
AD2: communicates in Dutch in a comprehensible and structured manner (BaLO 10, 11)
AD3: develops a professional attitude  (BaLO 9, 10, 13)
 

 

Grading

The final grade is composed based on the following categories:
Other Exam determines 100% of the final mark.

Within the Other Exam category, the following assignments need to be completed:

  • Other Exam with a relative weight of 100 which comprises 100% of the final mark.

    Note: Exam time 1st session:
    Evaluation of assignments and tasks: 100% (not transferred to 2nd session)
    Exam time 2nd session:
    Evaluation of assignments and tasks: 100%

Additional info regarding evaluation

Not applicable

Allowed unsatisfactory mark
The supplementary Teaching and Examination Regulations of your faculty stipulate whether an allowed unsatisfactory mark for this programme unit is permitted.

Academic context

This offer is part of the following study plans:
Bachelor of Engineering Technology: Electronics-ICT Engineering (only offered in Dutch)
Bachelor of Engineering Technology: verkort traject elektronica-ICT na vooropleiding prof. bachelor elektronica-ICT (only offered in Dutch)
Bachelor of Engineering Technology: verkort traject elektronica-ICT na vooropleiding prof. bachelor multimedia & communicatietechnologie. (only offered in Dutch)
Bachelor of Engineering Technology: verkort traject elektronica-ICT na vooropleiding prof. bachelor elektrotechniek. (only offered in Dutch)
Bachelor of Engineering Technology: verkort traject elektronica-ICT na vooropleiding prof. bachelor elektromechanica, luchtvaart en autotechnologie. (only offered in Dutch)
Bridging Programme Master of Science in Engineering Technology : Electronics-ICT Engineering: Standaard traject (90 ECTS) (only offered in Dutch)
Bridging Programme Master of Science in Engineering Technology : Electronics-ICT Engineering: Verkort traject (60 ECTS) (only offered in Dutch)