Chapter 9. Creating the Tables


Now that the server is running, the database has been created, and users have been defined, we can go ahead and create our tables. As you saw in Chapters 4 and 5, a lot of work went into determining the business needs and translating them into a solid table design. After all the coffee cups were cleared away and the final diagrams were drawn on the whiteboard, we ended up with ten tables. Remember that there is a real dependency among the tables because of the referential integrity constraints that we built into them.

This means that certain core tables are the foundation for the entire system. These are the question, answer, and test tables (QUESTIONS, ANSWERS, and TEST_ID); the question and test descriptor tables (QUESTIONS_TYPE_DESC and TEST_TYPE_DESC); the AUTHORS table; and the table linking questions and test (TEST_QUESTIONS_LINK). These tables must be defined first, and the order in which you create them is important, as you will see.



Guerrilla Oracle
Guerrilla Oracle: The Succinct Windows Perspective
ISBN: 0201750775
EAN: 2147483647
Year: 2003
Pages: 84

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net