Within the first two years, Brian made himself the leader of the group and was, uniquely, writer/producer/arranger/musician and lead vocalist of the band. It was clear from the very early years that Brian was the one destined to take The Beach Boys into the spotlight.
A logical design is a conceptual, abstract design. You do not deal with the physical implementation details yet; you deal only with defining the types of information that you need. The process of logical design involves arranging data into a series of logical relationships called entities and attributes. An entity represents a chunk of information. In relational databases, an entity often maps to a table. An attribute is a component of an entity and helps define the uniqueness of the entity.
During the physical design process, you convert the data gathered during the logical design phase into a description of the physical database, including tables and constraints. Physical design decisions, such as the type of index or partitioning have a large impact on query performance. See Chapter 6, Indexes for further information regarding indexes. See Chapter 5, Parallelism and Partitioning for further information regarding partitioning. Logical models use fully normalized entities.