Oracle Quick Guides: Part 2 - Oracle Database Design

by Malcolm Coxall

Overview

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

Product Details

BN ID:	2940044534681
Publisher:	Malcolm Coxall
Publication date:	05/13/2013
Series:	Oracle Quick Guides , #2
Sold by:	Smashwords
Format:	eBook
File size:	474 KB
Age Range:	18 Years

About the Author

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.