Question: how to design a good relational database?
Answer: Determine the purpose of your database. ...  Find and organize the information required. ...  Divide the information into tables. ...  Turn information items into columns. ...  Specify primary keys. ...  Set up the table relationships. ...  Refine your design. ...  Apply the normalization rules.