denormalization - Cyclic reference in a database table -


I am quite ashamed to ask this, but recently there is a situation where I have three different one another Explain to me the types of banking institutions related to

Imagine a bank table that contains details of a regulated bank or a regular bank, which operates rural branches or rural branches operated under the branches of this bank or retail bank which does not fall In this hierarchy but only with the rural branch.

Earlier, I decided to keep 4 separate tables for the barriers of the FK (i. One governing bank, In the operation of branches, rural branch and retail bank branch) one. But since I went to create a communication table, I was confused because there could be a transaction between any of these institutions (example: rural branch and retail branch, etc. among rural branches etc.) it meant that I Only record the "source"; The 'Destination' ID of the banking unit, but to keep some data, the application logic to determine which queries are included for the query. I thought it was bad.

In addition, a USER table and user can be of any of these institutions, here too 4 separate tables of banking institutions are problematic. How do I know if a user is a rural branch or retail branch or a governing bank?

Therefore, I have a single bank table (essentially because they are the same institutions, because they can work with each other). I added a parent column in the table which will be the ID of the parent organization (which I am otherwise using from FK), then in a rural branch, its original column will have an operating bank ID. Retail branches do not have a parent, so its value is taped and so on.

The problem is that now a PK / FK relationship in the bank table, a cyclical reference.

My question is: how bad is it? And can the cap be a way?

Being self-referencing relationship is not uncommon, a fall is that many RDBMSs provide you with cascading self- Do not allow deletion. Apart from this, there is no major loss in this type of hierarchical relationship. For the convenience of these types of relationships, many database solutions also support expanded functionality. See

  • on completing hierarchical questions using
  • See details of some of the queries used in context itself. Relationships In addition to this, I can suggest that you have this bank table, but keep the secondary tables for bank types as each bank will have a record in the bank table, and additional Bank type is a record in one of the other tables holding distinctive extended properties, in this way the relationships will still be centralized, users will still be able to use a single FK Can be linked to the table, but your bank table does not match the extended properties for all types of different types.


Comments

Post a Comment

Popular posts from this blog

sql - dynamically varied number of conditions in the 'where' statement using LINQ -

I am using my first project LINQ (in mvc), so maybe there's something very simple that I remember. However, a day of searching and experimenting does not work, so it works. I am trying to write a LINQ query (Linux to SQL) in which in many cases where the statement is different from an OR or an AND. We do not know how many conditions are going in the query till runtime. This search is for filter control, where the user can choose multiple criteria for filtering. Select from table where table.col = 1 or table.col = 2 or table.col = 7 .... 'Other number of conditions Before I just create the SQL query as a string, while looping over all the situations. However, it seems that there should be a good way to do this in LINQ. I tried to use Expression trees, but they had a second thought for this moment on my head, where the lambda function was to be executed inside the statement such as: values ​​for matchingRows = matchingRows for each value Where (function (row) row.c...
Read more

asp.net mvc - Dynamically Generated Ajax.BeginForm -

I have a problem with ASP.NET MVC Ajax forms. I generate many Ajax form in a table such as: & Lt; Input type = "submit" name = "activity" value = "add activity" / & gt; & Lt;%}% & gt; & Lt; / TD & gt; & Lt; / TR & gt; & Lt;%}% & gt; So far so good. When I post one of those forms, it gives a partial view in a div, and in this new partial view a new Ajax Beginnform (which is not in Genesis form) This second Ajax Beginnorf is exactly like the ones I got on the table, but when I post it, I do not get the "Ajax Post", but a normal post that sends me to a new page, I do not know whether the two Ajax forms What is the reason for the difference between, why is it the "dynamically generated" Ajax form behaves like a normal HTML form? By the way, I know that I can do it in different ways using javascript, but I would like to understand whether it can only be done using MVC helplars and Ajax lib...
Read more

Debug on symbian -

I am using trk for phone debug This works well for the Holorld project But when I start the project in phone debug mode 1) the load failed 2) TrkProtocolPlugin: to target the specified file Failure (please verify If any body understands what problem I am experiencing, then this problem helps me Pre-release If the application has the privileges assigned (with the appropriate certificate) itemprop = "text" > In your case, I will check: / li> If there is no conflict of application ID with any other application of device If there are problematic commands in the installation package (for example copy copy for non-accessible directories)
Read more