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.