902949 wrote:I want to second what John Watson said. You need to focus on a business and systems analysis, getting to a entity-relationship diagram with your data model at Third Normal Form. If you are at the point of undertaking the project you describe, you should already be familiar with those concepts.
HI Everyone, Am designing a National Hospital Database as part of my undergraduate project, Am making use of RHEL 4 and Oracle 11.1.0, I planned having two tables "HOSPITAL" & "PATIENT", the database is expected to have millions of records. I just need an advice on what to do, what to consider during my design, views and triggers that may be needed to enhance the functionality of the database.