Home arrow Oracle arrow Page 4 - Working With Oracle on Windows: Part 2

Working With Oracle on Windows: Part 2

Now we have installed Oracle we can now begin to familiarise ourselves with use of SQL and how to use basic Oracle expressions.

Author Info:
By: Ben Shepherd
Rating: 4 stars4 stars4 stars4 stars4 stars / 17
March 04, 2003
  1. · Working With Oracle on Windows: Part 2
  2. · Databases
  3. · Relationships
  4. · Structuring your database
  5. · Tables in Oracle
  6. · User Defined Schema Objects
  7. · Conclusion

print this article

Working With Oracle on Windows: Part 2 - Structuring your database
(Page 4 of 7 )

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.

blog comments powered by Disqus

- Oracle Purchases Taleo to Extend Cloud Compu...
- Partitioning in Oracle. What? Why? When? Who...
- Datatypes Used in Oracle 9i
- Creating a Database in Oracle 9i
- Oracle with Doctor Janusz Getta
- Working With Oracle on Windows: Part 3
- Working With Oracle on Windows: Part 2

Watch our Tech Videos 
Dev Articles Forums 
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us 
Weekly Newsletter
Developer Updates  
Free Website Content 
Contact Us 
Site Map 
Privacy Policy 

Developer Shed Affiliates


© 2003-2018 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap
Popular Web Development Topics
All Web Development Tutorials