Oracle Quick Guides Part 2 - Oracle Database Design

This is Part 2 of a series of quick learning guides for Oracle designers, developers and managers. Part 2 introduces completely new entrants to concepts of Oracle database analysis and design, database normalisation, the logical datamodel, E-R modelling and diagrams, logical to physical transformation in Oracle Designer, physical database design, de-normalization, database design for performance, and building a physical database from a server model.These guides are designed to rapidly deliver key information about Oracle to the following audience groups:- Project Managers and Team Leaders who are new to Oracle and need rapid access to strategic information about the Oracle design and development environment.- Business Analysts, Designers and Software developers who are new to Oracle and need to make first steps in gaining a detailed understanding of the design and development issues involved in Oracle.Part 2 assumes that the reader has a basic knowledge of the relational model and a basic understanding of logical and physical design concepts. The contents of Part 2 include the following subject headings:Preface and Audience1. The Analysis phase - Separating Functional and Database Design2. Introduction to Datamodelling and Database Design: Logical and Physical concepts of design3. Practical Logical Design - Data-modelling4. Practical Logical Design using Oracle Designer5. Moving from the Logical to the Physical design6. Practical Physical Design (using Oracle Designer)7. Designing a database for Performance8. Building the physical database from Designer9. Managing Changes during development10. Glossary of Terms

Malcolm Coxall is a management consultant, systems analyst, organic farmer and author, with more than 30 years experience working for many of the world's largest corporate and institutional organisations, starting in the field of dispute arbitration for the ILO. These experiences have provided him a ringside view of the management methodologies used by medium and large businesses in areas as diverse as banking, oil, defence, telecoms, insurance, manufacturing, mining, food, agriculture, aerospace, textiles, and heavy engineering. Malcolm has published articles on political science, sociology, human design, sustainable agriculture, organic food production, technology in organic farming, biodiversity, forest management, environmental protection and environmental economics. He is active in European environmental politics and was a successful private complainant in the European Court of Justice in several cases of national breaches of European environmental law. He now lives in Southern Spain from where he continues his IT and system consultancy work, writing and managing the family's organic olive farm.