Question: what are the key 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.