Over deze cursus
After this course, students will be able to
- understand the basics of conceptual data modeling in the Entity Relationship model and UML, and translating a natural language specification of a conceptual model into a relational database schema;
- understand the relational database model;
- understand and create advanced SQL and Datalog queries for retrieving relevant data, potentially spanning multiple database tables and involving recursion and aggregation of data;
- will acquire the ability to design, based on a problem description in a variety of application domains, a database suited to solve this problem; and,
- will be able to quickly master and make practical use of contemporary frameworks and technologies for relational data management.
Leerresultaten
The focus of the course is on practical problem-solving in an application domain. Students will gain practical experience developing the ability to design effective databases based on a solid understanding of the underlying principles. By design, hands-on practical assignment(s) using contemporary frameworks and technologies are a central component of the course. The following topics will be covered:
- Data modeling: conceptual modeling in the ER model and UML; logical data modeling in the relational database model; optimization of logical models, basics of normalization.
- Querying databases: SQL basic queries, aggregation; Datalog basic queries, recursion.
Veronderstelde voorkennis
Je moet voldoen aan de volgende eisen
- Ingeschreven voor een andere opleiding dan
- HBO-TOP Applied Physics, Schakelprogramma, Voltijd
- Geen van onderstaande cursussen mag zijn behaald
- Datamodelling and databases (2ID50)
Link naar meer informatie
- StudiepuntenECTS 5
- Niveaubachelor
- Email contactpersoon
Als er nog iets onduidelijk is, kijk even naar de FAQ van TU Eindhoven.
Aanbod
Dit aanbod is voor studenten van Wageningen University