oracle database-design

Hi All, I have more than 100GB size of table in my database I want to rename the table name. Is it a good idea?

I'm working with an incompletely documented DBMS system, and I am looking for a general purpose software tool that will examine the values in…

Say that I have vendors selling various products. So, at a basic level, I will have the following tables: vendor , product , vendor_product . If…

For example, given 3 tables: gastropod snail slug and assuming we want to enforce that every row in 'gastropod' has exactly one corresponding row in…

Pause your life. Rewind. You are taken back to Day 1 of Facebook and asked to redesign their database architecture to handle the behemoth it has…

Is there a general rule of thumb for designing databases to allow the columns as nulls vs 3nf normalization? I have a table with a column that will…