Database design refers to the activities that focus on the design of the database structure that will be used to store
and manage end-user data. A database that meets all user requirements does not just happen; its structure must be
designed carefully. In fact, database design is such a crucial aspect of working with databases that most of this book
is dedicated to the development of good database design techniques. Even a good DBMS will perform poorly with a
badly designed database.
Proper database design requires the designer to identify precisely the database’s expected use. Designing a
transactional database emphasizes accurate and consistent data and operational speed. Designing a data warehouse
database emphasizes the use of historical and aggregated data. Designing a database to be used in a centralized,