Oracle High Performance Tuning for 9i and 10g

Database Schemas

Only schema entity relationship diagrams are included. There is little relevance with respect to tuning in including the schema creation scripting.

Figure A.1: Employees Schema ERD Version One

Figure A.2: Employees Schema ERD Version Two

Figure A.3: Accounts Schema ERD Denormalized Version

Inclusion of the highly Normalized version of the Accounts schema in Figure A.4 is not strictly necessary but useful to show the vast difference between an over-Normalized and a fairly well Denormalized schema entity relationship diagram as shown in Figure A.3.

Figure A.4: Accounts Schema ERD Normalized Version