Summary:
The main thing is to create database for any financial institutions.
OUTPUT:
- 12 slides PPT (including screen shot of, queries run and result, what the database is about, for what purpose it is being used for, dummy data processconclusion)
- write 5-7 pages, APA formatted, discussing your database, and the design steps that you took. Include the following topics:
- A description of what your database is, and what it would be used for
- Your logical database design steps
- Your physical database design steps
- Your dummy data process
- Business insights that you could extract from the database (your 5 queries)
- Conclusion
Project:
I need to create one database, this database will store the information about their clients that is their investors. There should be minimum 6 tables, including customer information, tables names are Banking and Finance, Healthcare, Mutual Funds, Hydropowers, Micro finances and Telecommunications. and it should be of 3NF. This database is for financial institution where they will use this database to help their investors in diversifying their portfolio.
If possible add 1 algorithm about risk bearing capacity of investors in the scale of 1 to 5. 1 being not at all 5 being too risky.


0 comments