Ch. 1: Sharing Knowledge and Success. Oracle is an Object-Relational Database (ORDBMS). RDBMS allows you to put the data in, keep the data, get it out. ORDBMS extends this capability. SQL (structured query language) is the basic language of Oracle to manipulate data.
Name tables, columns, data with users. Develop app. thesaurus to ensure consistency.
Use English words.
Don’t mix levels in naming.
Avoid codes and abbreviations.
Use meaningful keys.
Analyze and design from the tasks, not just the data. Normalization is not design.
Move tasks from users to the machine.
Don’t be seduced by development speed. Take time in analysis, design, testing, tuning.Ch. 2: Human Design