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 sons -
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

Help please Strange logs

#4 i'm not sure ask, or go...is normal keychain storage logs? com.apple.iadidrecords apple persistent state encryption call history user data key com.apple.ids: devicehbi ids: identity-rsa-private-key itunes iad password safari extensions list safari webcrypto master key didn't create of these. normal?   me again... also, apparently certified apple employee? certificate id , everything. can log in apple certification registry keychain storage password , have account id?????? may hub? apple using. not losing it. don't think @ least.   Forums Macs macOS macOS iPhone Mac OS & System Software iPad Apple Watch Notebooks iTunes Apple ID iCloud Desktop Computers Apple Music Professional Ap
Read more