Over deze cursus
This course covers database design and the use of databases in applications, with a focus on applications in the life sciences. Topics include the relational model, database design principles, the structured query language (SQL), including temporal and spatial queries. Data lifecycle topics and contemporary issues for data scientists and practitioners are also introduced, i.e. big data, FAIR principles, data governance, licensing, and privacy.
The course includes extensive practical work in the design, construction, and use of databases in the students' field of study. Practical work involves MySQL and PowerBI. Students tend to value these hands-on database design and building skills as the most valuable part of the course.
Leerresultaten
Demonstrate a managerial perspective on an organization's memory
Explain key concepts of data modelling and databases (i.e. entities, relationships, primary and foreign keys)
Interpret data model diagrams using different notations (E-R diagrams)
Compile Database queries with SQL: including joins, subqueries, arithmetic, logical and spatial operations
Analyse a realistic information system problem and propose a data design solution
Design and implement a Database for a problem in their field of study
Debate some of the contemporary challenges in data management, such as FAIR principles, security, big data, privacy, licensing
Toetsing
- Written test with closed questions (40%)
- Assignment report (50%) team project report
- Assignment oral presentation (10%) presentation team project
Voorkennis
At ease with computers and basic mathematics.
Bronnen
- The book for the course is: Richard T. Watson. Data Management, Databases and Organizations. 6th ed. (e-book). The course's Brightspace offers support material.
Aanvullende informatie
- Neem contact op met een coordinator
- Niveaubachelor
- Instructievormop de campus
Startdata
1 sep 2025
tot 26 okt 2025
9 mrt 2026
tot 3 mei 2026