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.
Database Studio, Creating and Using Database Objects: Overview
SQL Tutorial, Data Definition
SQL Reference Manual, Data Definition
Database Administration,