Question: what are the steps in database design?
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.