Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.php > #13188

Re: Mr. Stuckle and Mr. Miller - explain normalisation with an example

Show all headers | View raw

noreply@example.com says...

> >> The table I have now consists of the following columns.
> >> songid,hits, title, author, license.
> >> Please explain how this data should be normalised.
> > 
> > Why do you have BOTH the songid and the (presumably song) title, when it 
> > would be prefereable to have a "Songs" table separate to the one 
> > recording the (presumably web-click) "hits"?
> > 
> > Is it feasible for a song (for a particular author/artist) to be the 
> > subject of more than one "license", e.g. released on different 
> > compilation ablums through different companies?
> > 
> > GM
> 
> Yes it can be.
> There have been a few cases of same titles by different authors.
> One that cames to mind is "Little Sister" sung by Elvis and another totally
> different as sung by Connie Stevens.
> It is the author who signs with a licensing agent, not the artist.

And you have both the songid and the title in the table for ... ??

GM

Back to comp.lang.php | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Mr. Stuckle and Mr. Miller - explain normalisation with an example richard <noreply@example.com> - 2014-03-16 16:22 -0400
  Re: Mr. Stuckle and Mr. Miller - explain normalisation with an example Luuk <luuk@invalid.lan> - 2014-03-16 21:54 +0100
    Re: Mr. Stuckle and Mr. Miller - explain normalisation with an example richard <noreply@example.com> - 2014-03-16 19:20 -0400
      Re: Mr. Stuckle and Mr. Miller - explain normalisation with an example Scott Johnson <noonehome@chalupasworld.com> - 2014-03-16 17:05 -0700
        Re: Mr. Stuckle and Mr. Miller - explain normalisation with an example richard <noreply@example.com> - 2014-03-16 21:43 -0400
          Re: Mr. Stuckle and Mr. Miller - explain normalisation with an example Denis McMahon <denismfmcmahon@gmail.com> - 2014-03-17 04:17 +0000
  Re: Mr. Stuckle and Mr. Miller - explain normalisation with an example Luuk <luuk@invalid.lan> - 2014-03-16 21:56 +0100
  Re: Mr. Stuckle and Mr. Miller - explain normalisation with an example Lew Pitcher <lew.pitcher@digitalfreehold.ca> - 2014-03-16 17:29 -0400
    Re: Mr. Stuckle and Mr. Miller - explain normalisation with an example Scott Johnson <noonehome@chalupasworld.com> - 2014-03-16 17:12 -0700
      Re: Mr. Stuckle and Mr. Miller - explain normalisation with an example Lew Pitcher <lew.pitcher@digitalfreehold.ca> - 2014-03-16 21:14 -0400
        Re: Mr. Stuckle and Mr. Miller - explain normalisation with an example Scott Johnson <noonehome@chalupasworld.com> - 2014-03-16 19:47 -0700
        Re: Mr. Stuckle and Mr. Miller - explain normalisation with an example Jerry Stuckle <jstucklex@attglobal.net> - 2014-03-16 22:54 -0400
        Re: Mr. Stuckle and Mr. Miller - explain normalisation with an example Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2014-03-25 15:28 +0100
      Re: Mr. Stuckle and Mr. Miller - explain normalisation with an example Derek Turner <frderek@cesmail.net> - 2014-03-17 09:37 +0000
  Re: Mr. Stuckle and Mr. Miller - explain normalisation with an example Doug Miller <doug_at_milmac_dot_com@example.com> - 2014-03-16 21:34 +0000
  Re: Mr. Stuckle and Mr. Miller - explain normalisation with an example Jerry Stuckle <jstucklex@attglobal.net> - 2014-03-16 18:02 -0400
    Re: Mr. Stuckle and Mr. Miller - explain normalisation with an example richard <noreply@example.com> - 2014-03-16 19:09 -0400
      Re: Mr. Stuckle and Mr. Miller - explain normalisation with an example Jerry Stuckle <jstucklex@attglobal.net> - 2014-03-16 21:13 -0400
  Re: Mr. Stuckle and Mr. Miller - explain normalisation with an example Geoff Muldoon <geoff.muldoon@trap.gmail.com> - 2014-03-17 10:55 +1100
    Re: Mr. Stuckle and Mr. Miller - explain normalisation with an example richard <noreply@example.com> - 2014-03-16 20:13 -0400
      Re: Mr. Stuckle and Mr. Miller - explain normalisation with an example Geoff Muldoon <geoff.muldoon@trap.gmail.com> - 2014-03-17 14:54 +1100
  Re: Mr. Stuckle and Mr. Miller - explain normalisation with an example Gabe <usenet@moojuice.net> - 2014-03-17 13:56 +0000

csiph-web