
So, lets start with table Student:
This is the look of table Courses:
Check out the look of "Student Courses" table, where we can store the year of participation and grade data.
The table "Student Course" is connected with tables Student and Courses through one-to-many relation, called "Link" in Dabble DB:
In Dabble DB you can view/edit data related through many-to-many relation directly in the table "Student Course" or on student’s /on course’s side:
The Dabble DB allows building various types of reports using the data stored in related tables:
To sum up:
As long as many-to-many relation represent 2 one-to-many relations, the existing Dabble DB master-detail limitations restrict the user here as well.
If this doesn’t bother you then Dabble DB allows many-to-many relation, as well as it handles master-detail.
No comments:
Post a Comment