Database design is the conversion of your logical data model into database objects. It includes the definition of tables, keys and indexes. The database design has a strong influence on operational system performance.
Creating and Using Database Objects: Overview
SQL Reference Manual,
Analyzing Database Performance