This week's book giveaway is in the Agile and other Processes forum. We're giving away four copies of The Mikado Method and have Ola Ellnestam and Daniel Brolund on-line! See this thread for details.
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
posted
0
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
posted
0
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
posted
0
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
posted
0
Thanks, that was a really helpful.
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to
run our stuff on 16 servers instead of 3.
0
