How to make a good database design?

Question

I wanted to make an website that can input my personal financial record. Then i could analyze it. I have study SQL, but i still have a problem with database design. How can i make a good realtional in Database? I have read about database normalization

Answer 1

Start with creating a basic ERD (Entity Relationship Diagram), after that you translate that into a RDBM (Relational Database Model). With the right modellingtools, like visual paradigm, you can generate a DDL. This is a scrypt you run to create your tables and relations between them.

Answer 2

Thank You, i’ll try it