Artesis Plantijn Hogeschool Antwerpen
Wetenschap en Techniek
campus Spoor Noord Ellermanstraat
Ellermanstraat 33 - 2060 Antwerpen
wt@ap.be
Databases24991/2199/2122/1/79
Study guide

Databases

24991/2199/2122/1/79
Academic year 2021-22
Is found in:
  • Bachelor of Applied Computer Science, programme stage 1
In other study programme:
  • Bachelor of Electronics - ICT as Databases
This is a single course unit.
Study load: 3 credits
It is not possible to enrol in this course unit under
  • exam contract (to obtain a credit).
  • exam contract (to obtain a degree).
Co-ordinator: De Pooter Marijn
Other teaching staff: Verhulst David
Languages: Dutch
Scheduled for: Semester 1
This course unit is marked out of 20 (rounded to an integer).
Possible deadlines for learning account: 15.10.2021 ()
Re-sit exam: is possible.
Possibility of tolerance: This course unit is eligible for tolerance according to the criteria as determined by the degree programme you are enrolled in.
Total study time: 78,00 hours

Prerequisites

There are no prerequisites for this course.

Learning outcomes (list)

A.6. Application Design
Designs database objects with respect for the integrity rules and application needs.
Applies normalisation to relational databases
Identifies to what requirements (definitions, rules and standards) data must comply.
Gathers relevant entities, attribute types, the relations between the entities and cardinalities from the relations of (un) structured information source(s).
B.1. Design and Development
Creates a data base and data base objects.
Manipulates data in a data base (delete, insert, update).
Analyses an information need and converts these into efficient SQL-instructions.
Implements the necessary integrity rules in a data base based on a data model.
Creates a relational data model using the standardization technique
Evaluates an (existing) relational data model on 1NNV, 2NV or 3NV.
B.3. Testing
Identifies to what requirements (definitions, rules and standards) data must comply.

Educational organisation (list)

Learning Activities
Lectures and / or tutorials12,00 hours
Practicum24,00 hours
Work time outside of contact hours42,00 hours

Evaluation (list)

Evaluation(s) for first exam chance
MomentForm%Remark
Academic yearSkills assessment hands off40,00Gegevensanalyse : gesloten boek examen
Academic yearSkills assessment hands on60,00SQL : gesloten boek met uitzondering van presentaties.
Evaluation(s) for re-sit exam
MomentForm%Remark
2nd examination periodSkills assessment hands off40,00Gegevensanalyse : gesloten boek examen.
2nd examination periodSkills assessment hands on60,00SQL : gesloten boek met uitzondering van presentaties.