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.