Working With Oracle on Windows: Part 2

When creating a database, you should ask yourself, “What is your database designed to do?” At this stage, do some brainstorming. Think about what the problem is and the entities that will be required to solve it. After that see how the entities relate to one another and draw up a model to see what is going on.

UML (i.e. Unified Modelling Language) found at http://www.uml.org , is a method that many companies use to design their database structure. It is a very useful tool. Another site to visit is found at http://www.gj.thorpe.btinternet.co.uk/planning.html where Graham Thorpe discussion a way a planning you database structure.

Once there is a database design that is believed to be efficient and well-constructed, you begin to create the tables.