1 reputation
4
bio website kashit.org
location Srinagar, India
age 28
visits member for 1 year, 6 months
seen Mar 14 at 10:25

I am an open source enthusiast from Kashmir


May
17
awarded  Popular Question
Jan
10
awarded  Commentator
Jan
10
comment Relation between multiple hierarchical taxonomies linked to a single entity
Thanks for your inputs. I have edited my question to embrace another approached as suggested by another fellow. I will appreciate your suggestions on that.
Jan
10
revised Relation between multiple hierarchical taxonomies linked to a single entity
added 509 characters in body
Jan
10
comment Relation between multiple hierarchical taxonomies linked to a single entity
How do you suggest to maintain relations between taxonomy terms. The need for linking one taxonomy term to another is that it is terms which are linked to each other and not taxonomy. Taxonomy is an abstract relationship whileas taxonomy terms define the actual relation between terms of different taxonomies. How do you see it differently. Please share your thoughts.
Jan
9
asked Relation between multiple hierarchical taxonomies linked to a single entity
Jan
31
comment Billing Module (Fee) for School Management System
Thank you for your advice.
Jan
31
comment Billing Module (Fee) for School Management System
Thank you. Surely will look into LedgerSMB
Jan
17
comment Relationships in a school database
@FrustratedWithFormsDesigner - What about if i have to fetch all students with their current_data attached?
Jan
17
asked Billing Module (Fee) for School Management System
Jan
16
comment Relationships in a school database
Course is just an example. THere is whole lot of other information associated with student_current table like roll no, section, bus route, fee slab, current photo url etc. That is the reason to have independent student_current table. Revisioning is for audit purposes, as it has to be maintained for legal purposes in case of student. Changes in name, date of birth etc have to be revisioned somewhere. I was thinking of creating an archive table for student table which will store previous revisions of the student record.
Jan
16
comment Relationships in a school database
What can be better approach in this scenario. student base table is having one-to-many relationship with student_current table. At any time, I want to fetch students with their current details (here the current detail will be latest one based on date).
Jan
16
comment Relationships in a school database
Student is having some additional data that keeps on changing like the class he is studying in, additional details related to that class like his roll no, section etc. Additionally the details in student base table may be updated at any time and I want to create a new revision of the record so that the previous record is saved somewhere.
Jan
16
comment Relationships in a school database
Thanks for the answer. But it will always be one to one in case of parents, while as for gaurdian, it might be one-to-many. This approach is appropriate. Thanks for the help. I would appreciate if you can help with the updated question.
Jan
16
comment Relationships in a school database
ypercube - It is always one to one as they need to store independent relationship for a sibling, as there can be simple variation in name etc of the parent. So doesnot need to be many to many. @gulli - Thanks. Please check the updated question.
Jan
16
awarded  Editor
Jan
16
revised Relationships in a school database
added 783 characters in body
Jan
16
asked Relationships in a school database
Jan
16
awarded  Autobiographer