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

Groups > comp.lang.php > #13167

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

Show all headers | View raw

On 16-3-2014 21:22, richard wrote:
> I'll bet you won't.
>
> The table I have now consists of the following columns.
> songid,hits, title, author, license.
> Please explain how this data should be normalised.
> And why.
> Thank you.
>

The column 'author' should be an 'authorId'.

why?
- Because 1 author can write more than 1 song
- An author has properties to, like i.e.:
      - birtdate
      - date of death (if applicable)
      - city of birth
      - etc
      - etc
Another advantage of this is that, when you found out that you 
misspelled the name of this author, you only need to change 1 record to 
correct the songs of this author.

Another example of this might be 'license'
If i ask questions like:
When became this license valid?
And 'until when was this a valid license'?
Did the author have more than 1 license?

You might say "this is not applicable to my application"
But, in real life, one should be prepared that this will become 
applicable for your application. (Because users only start to think 
after they see the portential of your application)

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