normalisation/relationship question


i'm trying save user data. ran question. town has got many streets. street has name. town has many streets. has street many towns? @ first street has 1 town. name present in many towns.

following:
town has many streets
street has 1 town
street has relationship table called streetname
streetname have n n relationship street.

insights?
 

unless there reason store street-names in separate table (like wanted find towns main street), think should consider street-name attribute of street. then, constructed query information. , database structure isn't over-complicated , looks logical.
 


Forums iPhone, iPad, and iPod Touch iOS Programming


  • iPhone
  • Mac OS & System Software
  • iPad
  • Apple Watch
  • Notebooks
  • iTunes
  • Apple ID
  • iCloud
  • Desktop Computers
  • Apple Music
  • Professional Applications
  • iPod
  • iWork
  • Apple TV
  • iLife
  • Wireless

Comments

Post a Comment

Popular posts from this blog

Sean Penn, "Chapo Guzman", and Rolling Stone

if you've spare twenty minutes or (and inclination) take @ sean penn's rambling account of meeting (then) fugitive mexican drug lord "chapo" guzman. its interesting on number of levels. not quality of sean penn's journalistic work. first observation had there remarkably little actual interviewing going on. penn's limited spanish ("hola" , "adios") played part. guzman made number of statements, claiming turned narcotics because there no other means of earning living. beyond that, nothing groundbreaking. sean penn himself of polarizing figure. guy rose fame jeff spicoli fancies himself of outlaw journalist, without writing chops of hunter s. thompson. prose of intelligent man; stylist ambitions out of reach of abilities. uses word "brume" describe aftereffects of bout of flatulence. pretentious word (i presume) not technically accurate. mentions twice expensive wristwatches sported guzman's so...
Read more

Subler - What is "Fix Audio Fallbacks"?

when remove commercials recorded tv before encoding, encounter 2 second audio lag after cut. tried subler's fix audio fallbacks in case for. didn't wanted. do?   it hint atv, nothing content editing: https://bitbucket.org/galad87/subler/issues/146/add-audio-track-fallback-to-batch-options   Forums Apple TV Apple TV and Home Theater iPhone Mac OS & System Software iPad Apple Watch Notebooks iTunes Apple ID iCloud Desktop Computers Apple Music Professional Applications iPod iWork Apple TV iLife Wireless
Read more

Fallout 4 Builds- Which ones You Prefer?

Image
i started game 2 weeks ago, knowing nothing , have decided restart i'm feeling more comfortable , thinking trying assassin/stealthed build. how guys playing f4- melee, stealth, sniper, charisma, luck, etc? interesting links, saying game's ai geared head on attacks , ill equipped stealthed players. makes me hesitant try stealthed build. i'd them @ least react me before die. nephew swears melee build. http://www.ibtimes.com/fallout-4-pe...-work-best-different-character-builds-2192331 http://www.vg247.com/2015/11/24/fallout-4-build-guide-infilitrator/ http://arstechnica.co.uk/gaming/201...ut-4-is-like-a-developer-sanctioned-god-mode/ http://www.gosunoob.com/fallout-4/best-starting-stats-builds/ http://www.idigitaltimes.com/fallou...uck-perks-are-more-important-you-think-493379 ---------------------settlement links----------------------- http://www.idigitaltimes.com/fallou...nd-tricks-object-clipping-build-limits-492715 http://ww...
Read more