Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Simple RDBMS question

 
Zip Ped
Ranch Hand
Posts: 336
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

I have 11 tables in my database and I want to know whether all my tables in the database have to be related to each other in some way or the other. I have 3 tables which I am maintaining solely for the purpose of keeping a record of all the rows which are deleted from other tables. These tables do not participate anywhere in my application and so I need to know if they have to be related to other tables in the database or they can be stand alone tables.

Thanks in advance.

Kailash
 
Chetan Parekh
Ranch Hand
Posts: 3640
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Kailash Thiyagarajan:
I have 3 tables which I am maintaining solely for the purpose of keeping a record of all the rows which are deleted from other tables.

In above scenario, you aslo need to relate them. They can�t be stand alone.
 
Zip Ped
Ranch Hand
Posts: 336
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Chetan,

Could you give me a detailed explaination? I am still not sure why I am supposed to relate them.
 
Chetan Parekh
Ranch Hand
Posts: 3640
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Kailash Thiyagarajan:
Hi Chetan,

Could you give me a detailed explaination? I am still not sure why I am supposed to relate them.


Since you are storing deleted data in those tables, you might require recovering them on later stage and also you would like to have audit of deleted data periodically. In this case you need to have them to be a member of relationship.
 
Zip Ped
Ranch Hand
Posts: 336
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks, that was a really helpful.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic