FUDforum: comp.lang.php » Mr. Stuckle and Mr. Miller - explain normalisation with an example

Home » Imported messages » comp.lang.php » Mr. Stuckle and Mr. Miller - explain normalisation with an example

Show: Today's Messages :: Polls :: Message Navigator

Re: Mr. Stuckle and Mr. Miller - explain normalisation with an example [message #185287 is a reply to message #185275]

Sun, 16 March 2014 23:55

Geoff Muldoon
Messages: 19
Registered: July 2011

Karma:

Junior Member

noreply(at)example(dot)com says...
>
> 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.

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

Report message to a moderator

[Message index]

		Mr. Stuckle and Mr. Miller - explain normalisation with an example By: Mr Oldies on Sun, 16 March 2014 20:22
		Re: Mr. Stuckle and Mr. Miller - explain normalisation with an example By: Luuk on Sun, 16 March 2014 20:56
		Re: Mr. Stuckle and Mr. Miller - explain normalisation with an example By: Luuk on Sun, 16 March 2014 20:54
		Re: Mr. Stuckle and Mr. Miller - explain normalisation with an example By: Mr Oldies on Sun, 16 March 2014 23:20
		Re: Mr. Stuckle and Mr. Miller - explain normalisation with an example By: Scott Johnson on Mon, 17 March 2014 00:05
		Re: Mr. Stuckle and Mr. Miller - explain normalisation with an example By: Mr Oldies on Mon, 17 March 2014 01:43
		Re: Mr. Stuckle and Mr. Miller - explain normalisation with an example By: Denis McMahon on Mon, 17 March 2014 04:17
		Re: Mr. Stuckle and Mr. Miller - explain normalisation with an example By: Lew Pitcher on Sun, 16 March 2014 21:29
		Re: Mr. Stuckle and Mr. Miller - explain normalisation with an example By: Scott Johnson on Mon, 17 March 2014 00:12
		Re: Mr. Stuckle and Mr. Miller - explain normalisation with an example By: Lew Pitcher on Mon, 17 March 2014 01:14
		Re: Mr. Stuckle and Mr. Miller - explain normalisation with an example By: Scott Johnson on Mon, 17 March 2014 02:47
		Re: Mr. Stuckle and Mr. Miller - explain normalisation with an example By: Jerry Stuckle on Mon, 17 March 2014 02:54
		Re: Mr. Stuckle and Mr. Miller - explain normalisation with an example By: Derek Turner on Mon, 17 March 2014 09:37
		Re: Mr. Stuckle and Mr. Miller - explain normalisation with an example By: Thomas 'PointedEars' on Tue, 25 March 2014 14:28
		Re: Mr. Stuckle and Mr. Miller - explain normalisation with an example By: Doug Miller on Sun, 16 March 2014 21:34
		Re: Mr. Stuckle and Mr. Miller - explain normalisation with an example By: Jerry Stuckle on Sun, 16 March 2014 22:02
		Re: Mr. Stuckle and Mr. Miller - explain normalisation with an example By: Mr Oldies on Sun, 16 March 2014 23:09
		Re: Mr. Stuckle and Mr. Miller - explain normalisation with an example By: Jerry Stuckle on Mon, 17 March 2014 01:13
		Re: Mr. Stuckle and Mr. Miller - explain normalisation with an example By: Geoff Muldoon on Sun, 16 March 2014 23:55
		Re: Mr. Stuckle and Mr. Miller - explain normalisation with an example By: Mr Oldies on Mon, 17 March 2014 00:13
		Re: Mr. Stuckle and Mr. Miller - explain normalisation with an example By: Geoff Muldoon on Mon, 17 March 2014 03:54
		Re: Mr. Stuckle and Mr. Miller - explain normalisation with an example By: Gabriel on Mon, 17 March 2014 13:56

Previous Topic:	[CM] Interesting look at PHP vs hack
Next Topic:	simple link won't show

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Nov 25 22:16:45 GMT 2024

Total time taken to generate the page: 0.05411 seconds