The process of designing the general structure of the database:-
Logical Design – decide on the database schema. Database design necessitates that we find a “good” assortment of relation schemas.
Business decision – What attributes should we evidence in the database?
Computer Science decision – What relation schemas should we have and how should the attributes be disseminated between the various relation schemas?
Physical Design – Deciding on the physical layout of the database
