What i meant was when the third component of tables are ready and i can create tables any time what happens to relationships when i am building the third component tables? How smooth the process will be?
On Fri, Sep 02, 2005 at 05:28:11PM -0400, Hrishikesh Deshmukh wrote: > We are designing a database, the database has three major components (each > component with 4-8 tables) > two components are ready, is it possible to 'overlay' the third one later? > or > Do i have to drop all the components (along with data!!!) and then add the > third component and then build the entire DB? > What i am saying is some tables are existing, could i later add a bunch of > tables at a later date without dropping the entire database?
What exactly do you mean by "overlay"? As far as the database is concerned, you can create tables any time you want: today, tomorrow, or a year from now. Is there some specific case you're concerned about? If so then please elaborate.