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 data model, 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 Audience
The Analysis phase - Separating Functional and Database Design
Introduction to Data modelling and Database Design: Logical and Physical concepts of design