aspose file tools*
The moose likes General Computing and the fly likes Simple RDBMS  question Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Engineering » General Computing
Bookmark "Simple RDBMS  question" Watch "Simple RDBMS  question" New topic
Author

Simple RDBMS question

Zip Ped
Ranch Hand

Joined: Jul 26, 2005
Posts: 336
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

Joined: Sep 16, 2004
Posts: 3636
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.


My blood is tested +ve for Java.
Zip Ped
Ranch Hand

Joined: Jul 26, 2005
Posts: 336
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

Joined: Sep 16, 2004
Posts: 3636
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

Joined: Jul 26, 2005
Posts: 336
Thanks, that was a really helpful.
 
 
subject: Simple RDBMS question