Warning: Illegal string offset 'html' in /home/hsn/public_html/forum/cache/skin_cache/cacheid_1/skin_topic.php on line 909

Warning: Cannot modify header information - headers already sent by (output started at /home/hsn/public_html/forum/cache/skin_cache/cacheid_1/skin_topic.php:909) in /home/hsn/public_html/forum/admin/sources/classes/output/formats/html/htmlOutput.php on line 114

Warning: Cannot modify header information - headers already sent by (output started at /home/hsn/public_html/forum/cache/skin_cache/cacheid_1/skin_topic.php:909) in /home/hsn/public_html/forum/admin/sources/classes/output/formats/html/htmlOutput.php on line 127

Warning: Cannot modify header information - headers already sent by (output started at /home/hsn/public_html/forum/cache/skin_cache/cacheid_1/skin_topic.php:909) in /home/hsn/public_html/forum/admin/sources/classes/output/formats/html/htmlOutput.php on line 136

Warning: Cannot modify header information - headers already sent by (output started at /home/hsn/public_html/forum/cache/skin_cache/cacheid_1/skin_topic.php:909) in /home/hsn/public_html/forum/admin/sources/classes/output/formats/html/htmlOutput.php on line 137

Warning: Cannot modify header information - headers already sent by (output started at /home/hsn/public_html/forum/cache/skin_cache/cacheid_1/skin_topic.php:909) in /home/hsn/public_html/forum/admin/sources/classes/output/formats/html/htmlOutput.php on line 141
Questions and examples - HSN forum

Jump to content


Questions and examples


9 replies to this topic

#1 bob1

    Showing Improvement

  • Members
  • PipPip
  • 13 posts
  • Gender:Not Telling

Posted 22 May 2007 - 03:58 PM

Does anyone have any more normalisation questions as i have looked everywhere for questions but cant find any

#2 Allan_r_123

    Site Swot

  • Members
  • PipPipPipPip
  • 176 posts
  • Location:Glasgow
  • Gender:Male

Posted 22 May 2007 - 05:09 PM

Erm I have a "big bumper fun book of normalisation" haha

Have you did one on a company which supplys electric goods? If not I'll post it up for you...?

#3 bob1

    Showing Improvement

  • Members
  • PipPip
  • 13 posts
  • Gender:Not Telling

Posted 22 May 2007 - 05:56 PM

yeah sure post it up because it will be good revision.

cheers

#4 Allan_r_123

    Site Swot

  • Members
  • PipPipPipPip
  • 176 posts
  • Location:Glasgow
  • Gender:Male

Posted 22 May 2007 - 06:11 PM

Invergordon Electrical is a small company supplying electrical goods to a few shops in the local area. Customer orders are recorded on a customer order card as follows.

Customer no: 1324
Customer name: John Andrews
Address: 27 High Street, Abervalley
Telephone: 0123456780
Date: 29/05/06
Item number: 14232
Number ordered 8

Details of all items offered for sale are stored on stock cards. Each item is obtained from a single supplier. Part of a stock card is shown below.

Item number: 554321
Description: Fineline Portable DVD Player
Suppler name: Acme Artifacts
Suppler Address: Industrial Zone, Byway
Supplier telephone: 01998232234
Price: 124.99


(a) The present system can be represented in un-normalised form as:

Customer no
Customer name
Address
Telephone
Order Date
Item number
Number ordered
Description
Supplier name
Supplier address
Supplier telephoe
Price

a) (i) Using Customer n as the primary key, "transform" this un-normalised data to first normal form by removing repeating groups.
(ii) Identify all Primary and Foreign keys

b) (i) Transform this first normal form to second normal form by removing partial dependencies
(ii) Identify all Primary and Foreign keys

c) (i) Transform this second normal form to third normal form by removing non-key dependencies
(ii) (ii) Identify all Primary and Foreign keys

There is also another record of the customers details and that shown, but it was too difficult to type it all up.
Once you do it post here and let me know, and I'll post up the solution.
Hope this helps give you a bit more practice, and if so I can maybe post another one up later or something!


#5 bob1

    Showing Improvement

  • Members
  • PipPip
  • 13 posts
  • Gender:Not Telling

Posted 22 May 2007 - 06:14 PM

why dont you post the answer up so i can check my answer whenever i want.
Also, do you know what the RETE algorithm is for? I know it has something to with conflict rules or something.

#6 Allan_r_123

    Site Swot

  • Members
  • PipPipPipPip
  • 176 posts
  • Location:Glasgow
  • Gender:Male

Posted 22 May 2007 - 06:23 PM

I'll put the solutions up soon as I'm studying myself atm so dont have time to fully put them up.

What do you need to know that for? haha Just checking it's not something ive missed in this course or something? :S lol

anyway, this might help? http://en.wikipedia.org/wiki/Rete_algorithm

#7 bob1

    Showing Improvement

  • Members
  • PipPip
  • 13 posts
  • Gender:Not Telling

Posted 22 May 2007 - 06:29 PM

QUOTE(Allan_r_123 @ May 22 2007, 07:23 PM) View Post
I'll put the solutions up soon as I'm studying myself atm so dont have time to fully put them up.

What do you need to know that for? haha Just checking it's not something ive missed in this course or something? :S lol

anyway, this might help? http://en.wikipedia.org/wiki/Rete_algorithm


Well, if you look at the 2006 pastpaper, question 25 (c ii) there is a question about it so you must have missed it out.

#8 Allan_r_123

    Site Swot

  • Members
  • PipPipPipPip
  • 176 posts
  • Location:Glasgow
  • Gender:Male

Posted 22 May 2007 - 06:30 PM

Ah it's cause I'm not doing that unit tongue.gif I do Applied Multimedia! Lol didn't realise you were refferring to the optional unit tongue.gif

#9 Allan_r_123

    Site Swot

  • Members
  • PipPipPipPip
  • 176 posts
  • Location:Glasgow
  • Gender:Male

Posted 22 May 2007 - 06:32 PM

The pastpaper answers say:-
To identify the rules whose conidtions match the facts in the working memory

#10 bob1

    Showing Improvement

  • Members
  • PipPip
  • 13 posts
  • Gender:Not Telling

Posted 22 May 2007 - 08:58 PM

.





1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users