(Solved) : Information Level Design Form User View 1 1 Represent User View Collection Tables O Determ Q31155370 . . . .

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