URL study guide
https://tue.osiris-student.nl/onderwijscatalogus/extern/cursus?cursuscode=2ID50&collegejaar=2025&taal=enDescription
Entity-Relationship Model (and equivalent UML constructs)Designing E-R diagrams for business situations
The Relational Database model
Constraints and Decompositions
Query languages: translation from natural language to
query languages and back; equivalence of query languages.
Objectives
This course teaches students to design (the data structures of)information systems. With "design" we mean that the students
learn to translate a natural language description of an organization’s
information needs into a data model, expressed in the
entity relationship model. Students must be capable of translating
that model into a relational database structure. They must be
able to optimize this structure by means of constraints and
decomposition algorithms.
Students also must become fluent in query languages, in order
to express natural language questions in query languages,
and in order to express formal queries in natural language.
Students additionally acquire social awareness of the role of conceptual modeling in social and technical systems and can effectively apply this awareness in the design of conceptual models.