Course
Data Modeling: Case Knowledge Inc
Try this advanced data modeling case to check your modeling skills
Hours
Videos
Case
Assignments
What will you learn?
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.