Database Design

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