Information-Level Design Form User View 1: 1. Represent the user view as a collection of tables. o Determine the entities involved and create a separate table for each type of entity. o Determine the primary key for each table. o Determine the properties for each entity. o Determine relationships between the entities. 2. Normalize the tables. 3. Identify all keys. 4. Merge the result into the design. (Cumulative design after one user view.) User View 2: 1. Represent the user view as a collection of tables. a. Determine the entities involved and create a separate table for each type of entity. b. Determine the primary key for each table. c. Determine the properties for each entity. d. Determine relationships between the entities. 2. Normalize the tables. 3. Identify all keys. 4. Merge the result into the design. (Cumulative design after two user views.)