I am currently desiging a billing system and i am rather concerned about data-redundancy with some of the tables.
I would like to ensure that there is no redundancy in my tables, and would like to setup proper relationships and attributes between tables.
Will asterisk pickup on relationships defines.
Can I have tables like this:
Will asterisk pickup the relationships, or do i have to design my tables breaking SQL Normalisation practices.