Question: how to design relational database step by step?
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.