i want to design the database for finance consulting firm which is a part of my project. i have to create min 5 tables. i have thought of 4 tables. 1.Agents 2. Clients. 3. Firm_details 4. Finance_Plans.
i am not able to think of other tables. Can you all please me in designing database tables.
Moreover these tables and their attributes should be in normalised form.
So can you give the attributes as well on which i can perform complex queries.
Eg. age can be the attribute on which i can perform aggregate functions.
Thanks in advance.
Please refer file for my project details.