Posts

Showing posts from November 18, 2018

Toni Potter

Toni Potter (born 1978/1979) [1] is a New Zealand actress, best known for her role on the New Zealand medical drama, Shortland Street . Contents 1 Early life 2 Shortland Street 3 Recognition 4 References 5 External links Early life Potter grew up with her sister, mother and father who was in the army in Papakura, Waiouru and Upper Hutt. [2] She spent her high school years in Christchurch where she acted with community theatre groups including outdoor Shakespeare productions and Contemporary dance groups. She moved to Auckland in 1998 to take up a place in the Bachelor of Performing Arts degree at UNITEC, majoring in acting. [2] Shortland Street Potter played Alice Piper, a senior nurse troubled by alcohol and severe bad luck with men, from 2005 to 2009. She featured in a number of major storylines, including one in 2008 in which she was captured by Joey Henderson, who was revealed as the Ferndale Strangler. He took out her appendix, but she...

Linking Two Foreign Keys to one Primary Key

Image
up vote 0 down vote favorite I have two tables, a Photographer and an Influences table. In the Influences table, a Photographer is able to influence another Photographer. Relational Schema: Here is my Diagram in SQL: Instance Example: My issue is when I try to delete Photographer Tom, since he influences Jason (as shown in Influences table), I get a error stating: The DELETE statement conflicted with the REFERENCE constraint "FK_Influences_Photographer1". The conflict occurred in database "jma59", table "dbo.Influences" If Tom was in the column EPName of the Influences table, I have no issue deleting it. I know that this is a foreign key issue but I am not sure how to handle this situation. I created two separate foreign keys that reference to the Photographer primary key. But the ...