Database Design The process of designing the general structure of the database: Logical Design-Deciding on the database schema. Database design requires that we find agood"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 Database System Concepts-6th Edition 1.16 @Silberschatz,Korth and SudarshanDatabase System Concepts - 6 1.16 ©Silberschatz, Korth and Sudarshan th Edition Database Design 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 The process of designing the general structure of the database: