Design Phases(cont) The process of moving from an abstract data model to the implementation of the database proceeds in two final design phases. Logical Design- Deciding on the database schema. Database design requires that we find a good collection of relation schemas Business decision What attributes should we record in the database? Computer Science decision- What relation schemas should we have and how should the attributes be distributed among the various relation schemas? Physical Design- Deciding on the physical layout of the databaseDesign Phases(cont) ➢The process of moving from an abstract data model to the implementation of the database proceeds in two final design phases. • Logical Design – Deciding on the database schema. Database design requires that we find a “good” collection of relation schemas. • Business decision – What attributes should we record in the database? • Computer Science decision – What relation schemas should we have and how should the attributes be distributed among the various relation schemas? • Physical Design – Deciding on the physical layout of the database