Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Is Creating Database tables from the Scratch a good Idea?

891779Sep 30 2011 — edited Sep 30 2011

Hi All,

I am new to this forum and I read couple of posting and I really liked everyones response.

In my development place, there was some changes(splitting up a table/entity into two or three tables/entities) in the existing data model.

I am in a situation, where I have to come with a conclusion to start developement process(I am a pl/SQL developer). There iare already some 15-20 existing tables in the database, but my lead wanted me to create all the tables from the scratch and tie them. The thing is, the already existing tables are tied by Natural keys ( like SSN and Year) but I told them I will add additional columns to the existing tables make them as Surrogate keys and use those keys to tie up to the other tables. So this will be altering the tables and updating the table columns with sequence number.

Please suggest me if my approach would take more time or start developing from the scratch would take more time?

Thanks in advance!!!!

Babu

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 28 2011

Added on Sep 30 2011

#data, #database, #general-database-discussions, #oracle, #plsql, #sql

4 comments

256 views