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 Audience
1. The Analysis phase - Separating Functional and Database Design
2. Introduction to Datamodelling and Database Design: Logical and Physical concepts of design
3. Practical Logical Design - Data-modelling
4. Practical Logical Design using Oracle Designer
5. Moving from the Logical to the Physical design
6. Practical Physical Design (using Oracle Designer)
7. Designing a database for Performance
8. Building the physical database from Designer
9. Managing Changes during development
10. Glossary of Terms
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
1. The Analysis phase - Separating Functional and Database Design
2. Introduction to Datamodelling and Database Design: Logical and Physical concepts of design
3. Practical Logical Design - Data-modelling
4. Practical Logical Design using Oracle Designer
5. Moving from the Logical to the Physical design
6. Practical Physical Design (using Oracle Designer)
7. Designing a database for Performance
8. Building the physical database from Designer
9. Managing Changes during development
10. Glossary of Terms
