i want to design a stock financial report system and fortunately i hooked in the database design part. The report is made up of different sector and under the sectors thier are companies. All sectors have some unique entry fields which makes it different from the other. for example banking sector is different from insurance sector because there are entries that differ. My problem is how to create a non-redundant database that features all the sectors and companies. the idea i thought is to make a table for every sector and i found out that with these idea i wil have some relational issues for example in each sector i will have company id as primary so in establsiing relation i will hav constraint.
Please i want sombody to help me and give me idea of how to design a non-redundant databse with respect to these subject. tnk u