so in a few months I am about to become Oracle Certified, and the only experience I've ever had with designing and creating 'tables' was in a DBA class in college years ago. However, I have over 10 years experience in system admin and basic database admin on HP, IBM, and SQL servers.
So here are my questions: What is the best way to practice database design?How do you determine the tables and fields that are necessary for those tables? What methods do you use to normalize the data?
I have all the experience doing backup/recovery, replication, re-indexing, performance issues, but I lack the logical knowledge of database design.