Modeling explicit 1 to 2 relationship in database -


If I want to have 1 to 2 relationships, then I am curious, what is the best way to make this model? That will change from 1 to 2. There will be a subject related to a pair, so there is a pair object in which there will always be subject 1 and subject 2. Is this a bad form for the topic1 and topic2 in the pair object? I realized that a join table will work properly, but one topic can be related to more than 1 pair and if I already have a pair object, then it would be easy to break the topic 1, then search for an inserted table Need to do? Or it's just bad data modeling

If you know that there will be only 1 to 2 topics in a pair And you are in fact ... really sure that it will never change, so you can do it like this.

It is being said, this is a bad design for some reasons. Generally, if you have fields of the same unit type (i.e., thing1, thing 2, etc.) then this should actually be broken into another table. As a field, listing entities are extremely difficult to change business rules within the database. If for some reason you need to add or delete any of these fields in the future, it becomes very difficult, this is not a big problem in your case, but you do not have 100% definitely do some schema of the future. You can.

Above this, those who have such fields as fields make your application developer's life potentially difficult to achieve the number of subjects of a pair, to develop that developer in these two areas Check all the time. A simple SELECT ... JOIN statement is very simple and it is not very expensive, especially if you have correctly indexed the column.

I will suggest two tables, one for another pair for the subject. You can apply your maximum of 2 topics with your simple subject and check the barrier like this:

/ * Returns the number of topics for a given pair * / Create function valid authenticator (pairID int) return int like return (SELECT COUNT (*) subject to WHERE pairID = @pairID); End; / * Adds that there are no more than 2 topics in the join table * / add optional table topic; insert chk_SubjectCount check (dbo.ValidateSubjectCount (pairID) & lt; = 2);

-

Comments

Post a Comment

Popular posts from this blog

sqlite3 - UPDATE a table from the SELECT of another one -

I have the first table article where some data is missing. In the table, articles_tmp I have a part of the missing data. So I want to update the articles. Where the path path is data in articles_tmp.path where the path is not zero . With SQLite , it does not work: update article SET path = (SELECT at.path FROM Articles_tmp as AS, WHERE at.article_id = a.id and a.asp, the text is in the form and not on. It has been transmitted) where the path is null MS Access Along with, it works fine: Update Articles Join the Inner Articles at articles_tmp articles.id = articles_tmp.id SETP articles.path = articles_tmp.path Can anyone help? Sin CE SQL Server Syntax, which I provided, was not working, here this solution With whom I have come. A little modification of your original query, but with my "correlation" suggestion added. There is a SQL Bella for this: Here is the code: update article SET path = (SELECT path from articles_tmp AS T WHERE t.id
Read more

c# - Showing a SelectedItem's Property -

So I have enabled a rightclick option for my DataGrid. I want to display the only chosen property but it is not behaving like what I would like it to display my name and additional. Public category Paymentinfo {public int PaymentNo {get; Set; } Public string date {get; Set; } Public Double Pay {get; Set; } Public Double Principle {get; Set; } Public Double Interest {get; Set; } Public Double Balance {Received; Set; }} Private Zero MenuItem_OnClick (Object Sender, RoutedEventArgs e) {MessageBox.Show (AmortGrid.SelectedItem.ToString ()); } I'm trying to apply it without using a View Module! If I place a breakpoint where the messagebox and the recipient place it on selected ITEM, then this property will display the payment. A date-payment-principle-interest-balance is the only value that needs payment. Was hoping that it would be something like this MessageBox.Show (AmortGrid.SelectedItem.PaymentNo.ToString ()); When you call ToString () So you get the class typ
Read more

javascript - Render HTML after each iteration in loop -

I'm trying to gradually increase the font size of text on a web page. The code works in my place, although the new HTML / CSS does not render after every iteration of the loop and when all this is done, then display only the text of 100 px size. To see the text as if it is slowly zooming, I need to do this JavaScript is down because it is being used from a different file here is what I have ... < Pre> & lt; P class = "game-title" style = "font-size: 50px" & gt; Test & lt; / P & gt; Function sleep (milliseconds) {var start = new date (). GetTime (); For (var i = 0; i & lt; 1e7; i ++) {if ((new date). GetTime () - start) & gt; Milliseconds {break; CSS ('font-size', 'parseInt ($ (' game-title '). CSS (' font-size ')) + 1 + "pixels"); } While (parasont ($ ('# text'). Css ('font-size')) & lt; = 100) {sleep (1000); IncreaseSize (); Using CSS: Use of jQuery (sample):
Read more