CHAPTER 7Physical Database Design
In most people's vocabularies, design means veneer. It's interior decorating. It's the fabric of the curtains and the sofa. But to me, nothing could be further from the meaning of design. Design is the fundamental soul of a man-made creation that ends up expressing itself in successive outer layers of the product or service.
—Apple CEO Steve Jobs, interviewed in Fortune magazine; January 24, 2000
The two stages of database design are logical and physical design. Logical database design, also referred to as data modeling, is done first. It is the process of studying the workings of a business organization, constructing a set of tables to store the business data, and understanding the constraints on the data, ...