Information Structures and Implications (B-KUL-G0W93B)
Aims
Students are able to model domains and data that are relevant in their field, to create and use relational databases for such data, and to perform basic combination and transformation operations on data. They can use SQL. They can recognize when SQL is not adequate, they have an overview of solutions beyond SQL, and they can perform some relevant operations without SQL. They are able to think critically about the use of data in their applications, and they are aware of their obligations as data controllers.
Previous knowledge
Knowledge as required from students admitted to the Master in Digital Humanities. Basic programming/scripting knowledge is advantageous.
Identical courses
This course is identical to the following courses:
G0W93A : Information Structures and Implications (No longer offered this academic year)
Is included in these courses of study
- Master of Digital Humanities (Leuven) 60 ects.
- Master of Sociology (Leuven) 60 ects.
Activities
4 ects. Information Structures and Implications: Lectures (B-KUL-G0W93a)
Content
- Typical forms and origins of data and questions towards them in the humanities, the social and behavioural sciences, and in applications
- Modelling data: Conceptual modelling with (E)ER
- Entities, schemas, and mappings
- Representing, querying and processing data in the relational model: SQL
- Transforming and combining data: with SQL, with other tools, with scripts
- Investigating and answering (research) questions using data
The lectures respectively exercises will focus on the theoretical/overarching respectively practical aspects of these subtopics. Details will be worked out in accordance with the participants’ prior knowledge and interests.
Course material
Handbook, copies of slides, handouts, papers.
2 ects. Information Structures and Implications: Exercises (B-KUL-G0W94a)
Content
- Typical forms and origins of data and questions towards them in the humanities, the social and behavioural sciences, and in applications
- Modelling data: Conceptual modelling with (E)ER
- Entities, schemas, and mappings
- Representing, querying and processing data in the relational model: SQL
- Transforming and combining data: with SQL, with other tools, with scripts
- Investigating and answering (research) questions using data
The lectures respectively exercises will focus on the theoretical/overarching respectively practical aspects of these subtopics. Details will be worked out in accordance with the participants’ prior knowledge and interests.
Course material
Handbook, copies of slides, handouts, papers.
Evaluation
Evaluation: Information Structures and Implications (B-KUL-G2W93b)
Explanation
The students will work through a series of homeworks to model and process data. The answers will comprise modelling, deployment, querying, simple analyses, and reporting (written and in presentations), and students’ progress on the homeworks and in the lectures and exercise sessions will be the topic of ongoing evaluation.