Course

Data Modeling: Case Knowledge Inc

Try this advanced data modeling case to check your modeling skills
By following along the two 5-step scripts, we will turn a case description into a conceptual and logical model. In this case, you will come across all the approach elements applied to the teaching company.
Write your awesome label here.
Sven Vermeulen
teacher "Data Modeling Case: Knowledge Inc"

Hours

Videos

Case

Assignments

What will you learn?

In this course, we apply the approach described in the course on “A business-oriented approach to data modeling” on a teaching company called Knowledge Inc.By following along the two 5-step scripts, we will turn a case description into a conceptual and logical model. In this case, you will come across all the approach elements applied to the teaching company. In case you have not followed the course on “A business-oriented approach to data modeling”, we advise you to do that first. It will help to follow along easier in this case.

Setting the scene

This case is based on Knowledge Inc. A company that organizes courses by working as an intermediary institute for other companies. Bringing teachers from different companies together with students, Knowledge Inc. offers a diverse set of topics. They have asked us to develop a database model that will help them manage the difficult task of keeping track of students, teachers and courses.

From description to conceptual model

  • Perform Things Storming
  • Layout kernel entity types
  • Determine the relationships
  • Determine cardinalities
  • Add attribute types

From conceptual to logical

  • Resolving relationships
  • Resolving attribute types
  • Adding optionality
  • Adding Keys
  • Final Layout

Realistic

Solving a complex case is much closer to the problems you will encounter with data models in real-life, than text-book exercises.

Related Downloads

Information Model Poster

Meet the instructor
Write your awesome label here.

Sven Vermeulen

Trainer
Sven is a trainer at The Master Labs. He teaches a range of topics to businesses across Belgium. These topics include process modeling and management, agile methodologies, enterprise architecture, data modeling, data science, and more.