.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan
Asad Ali
Fauzul Azmi
Post New Web Links

Where do i place the FK in a one-to-one relationship?

Posted By:      Posted Date: September 28, 2010    Points: 0   Category :Sql Server
 

hi friends,

i have followinf relationshio betwee cars and chassis. Business rule is:

1. car must have a chassis and only ne chassis

2. a chassis must have car and a chassis only belong to a car

 

From Drop Box

 

Where do i place foreign key of relationship?

Most importantly, in general assume two entities A and B have a 1: 1 relationsip , how do i figureout where to place the foreign key?

thanks




View Complete Post


More Related Resource Links

An Entity Relationship Diagram Example

  
An Entity Relationship Diagram conveys a lot of information with a very concise notation. The important part to keep in mind is to limit what you're reading using the following technique:


Choose two entities (e.g. Company and Employee)
Pick one that you're interested in (e.g. how a single Company relates to employees)
Read the notation on the second entity (e.g. the crow's feet with the O above it next to the Employee entity).

Good way to do a Many-to-Many relationship?

  

I've used the automatic  Many-to-Many generation as described here: http://msdn.microsoft.com/en-us/library/dd742359.aspx

But that doesn't seem to allow a quantity to be attached to orders (in the example it would be courses). I have many customers and many products, I would like a customer to be able to order more than one product. Right now I get a grid of checkboxes. I would like instead a field where I could enter a number. 

Is this possible?


save the pdf onto some place

  

I am opening a pdf using reporting services. Is there a way to directly saving the pdf to desktop or some place directly without opening? 


Go Global: Make the .NET World a Friendlier Place with the Many Faces of the CultureInfo Class

  

CultureInfo is a complex .NET class whose objects are used for resource loading, formatting, parsing, casing, sorting, and other conventions that change as the language, location, or writing system is changed. It can be tricky to use correctly in every situation. Here Michael Kaplan explains some common scenarios in which you will use CultureInfo and provides information about the behavior, best practices, and consequences of a wrong decision.

Michael Kaplan

MSDN Magazine March 2005


Design: Place XML Message Design Ahead of Schema Planning to Improve Web Service Interoperability

  

Web Services are all about exchanging data in the form of XML messages. If you were about to design a database schema, you probably wouldn't let your tool do it for you. You'd hand-tool it yourself to ensure maximum efficiency. In this article, the author maintains that designing a Web Service should be no different. You should know what kind of data will be returned by Web Service requests and use the structure of that data to design the most efficient message format. Here you'll learn how to make that determination and how to build your Web Service around the message structure.

Yasser Shohoud

MSDN Magazine December 2002


Command Management: Use Design Patterns to Simplify the Relationship Between Menus and Form Elements

  

In Windows Forms applications, similar commands, such as those in a menu and their counterparts on a toolbar, are not automatically related. They don't fire the same event or run the same handler routine. Yet code that allows the same or similar user commands to fire the same code simplifies development.This article describes the principles of command management and why it's important to have functional commands that are not exclusive to any one UI element. In order to provide an MFC-like command management infrastructure, a design pattern is developed and applied as a series of C# classes.

Michael Foster and Gilberto Araya

MSDN Magazine October 2002


Where to place if statement

  

I have a design problem I could use some help determining how to code this problem.

I have a table with 3 fields, catCode, startDate and endDate. I am having trouble deciding how to query my DB based on the following...

By default a gridview will return all records that match the catCode selected from a dropdown list.

 

If the user checks a check box, only records are returned where....

startDate <= today AND endDate >= today

 

How can I apply the If condition to compare when the check box is selected? I used the wizard to build the select statment for the gridview, but I can switch that to a SP if that makes life easier.

 

Thanks for any and all help and suggestions.


Video: SharePoint 2010: In Place Records Management

  
SharePoint now has a record management feature that can be activated on any site so that you no longer need to create a separate record center site to manage your documents. (Length: 2:33)

Need RegEx for four decimal place

  
Hello All, I have total 19 digits in which i have 4 decimal place. What would be the pattern. ThanksBizTalk Beginner

Relationship between a dimension - two fact tables

  
I have 3 fact tables and about 10 dimensions. I want to relate both "Fact_Pop1" and "Fact_pop2" to Dim_AgeGroup. But Fact_pop1 has single age group and Fact_pop2 has no single age group (5 years age group). I spent about a day on this but I could't solve it.   Fact_Pop1 Age        Race_key            Gender_key      Geography_key              Pop_size 10           White                    M                                            CA                          10000    10           White                    F        

place a condition in the RAISERROR

  
i have a raiserror statement ansd i need to place a condition to not raise the error when specific records exist in the table.   BEGIN RAISERROR( 'TABLE1 records do not exist in refTABLE. Please verify with John.',16,1) END this works ***************************************************** BEGIN iif ((TABLE.TYP_ID) NOT IN (10,20,30,40)) THEN RAISERROR( 'TABLE1 records do not exist in refTABLE. Please verify with John.',16,1) END I need the correct syntax....)

preferred method to choose where to place if condition for query

  
I have a design problem I could use some help determining how to code this problem.   I have a table with 3 fields, catCode, startDate and endDate. I am having trouble deciding how to query my DB based on the following...   By default a gridview will return all records that match the catCode selected from a dropdown list.   If the user checks a check box, only records are returned where.... startDate <= today AND endDate >= today   How can I apply the If condition to compare when the check box is selected? I used the wizard to build the select statment for the gridview, but I can switch that to a SP if that makes life easier.   Thanks for any and all help and suggestions.  

How to return the results of a 1 to Many Relationship

  
A co-worker of mine just came back from a SQL Server Reporting Services class (we are using SQL Server 2005). In that class they were told that if they had a one to many relationship that they would have to flatten the results into one row of the resultset in order to show the 'many' portion of the relationship.  For example, my company has two tables: Jobs Notes/Memo's For each Job we can have 0 or more Notes/Memo's. According to my co-worker the Report Server must have each of the Notes/Memo's in one row of the resultset.  That we therefore have to flatten the list of Notes into Note1, Note2, Note3...etc fields.  Is this correct?  How would I handle a situation where I didn't know how many Notes there were? Thanks so much.

HTTP Error 500.19 - Internal Server Error after SharePoint 2010 In-place upgrade

  
Hello We have done an SharePoint 2010 In-Place Upgrade. After the upgrade, we can access the Central Administration page without problems. However, when accessing the standard http port 80 site, the following error appears: Error Summary HTTP Error 500.19 - Internal Server Error The requested page cannot be accessed because the related configuration data for the page is invalid.   <fieldset><legend>Detailed Error Information</legend> Module IIS Web Core Notification Unknown Handler Not yet determined Error Code 0x80070032 Config Error The configuration section 'system.web.extensions' cannot be read because it is missing a section declaration Config File \\?\C:\inetpub\wwwroot\wss\VirtualDirectories\80\web.config Requested URL http://coolsharepoint:80/ Physical Path   Logon Method Not yet determined Logon User Not yet determined </fieldset> <fieldset><legend>Config Source</legend> 534: </location> 535: <system.web.extensions> 536: <scripting> </fieldset>

In place of cluadmin in 2003 what will use in 2008

  
Dear, In place of cluadmin in 2003 what will use in 2008"SQLSERVER DBA" "INDIA"

Parent-Child relationship on a Type 2 (SCD) Dimension

  
For a Type 2 slowly changing dimension (SCD) such as Employee with a Parent-Child relationship, how do you handle the explosion of new rows when a high ranking employee has an attribute change?   It will require terminating the high ranking employee row and adding a new current row with a new surrogate key. Then every employee row below this employee will also have to be terminated and a new current row added with the new surrogate key of the parent.   This will have to be performed 1 level at a time so the subordinate rows will have the new surrogate key of their immediate parent.   For a large organization such as 20,000 employees, this will result in a dimension with hundreds of thousands rows in a relatively short time.   Is there a better way to model this?
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend