<Li> Set up the table relationships - Look at each table and decide how the data in one table is related to the data in other tables . Add fields to tables or create new tables to clarify the relationships, as necessary . </Li> <Li> Refine the design - Analyze the design for errors . Create tables and add a few records of sample data . Check if results come from the tables as expected . Make adjustments to the design, as needed . </Li> <Li> Apply the normalization rules - Apply the data normalization rules to see if tables are structured correctly . Make adjustments to the tables, as needed . </Li> <P> In the field of relational database design, normalization is a systematic way of ensuring that a database structure is suitable for general - purpose querying and free of certain undesirable characteristics--insertion, update, and deletion anomalies that could lead to loss of data integrity . </P>

What is the first step in database design