[Year 12 IT Apps] IT Apps Exam, Short Answer, Question 7A

[Savage, John L]

No I don't think you're wrong, it's a lot of busy work for a few marks. I felt the same way about this question. The kids would have needed to evaluate the possible combinations to produce an answer that would need less rows to save writing time.

From: itapps-bounces at edulists.com.au [mailto:itapps-bounces at edulists.com.au] On Behalf Of Vear, Gary D
Sent: Friday, 7 November 2014 3:59 PM
To: Year 12 IT Applications Teachers' Mailing List
Subject: [Year 12 IT Apps] IT Apps Exam, Short Answer, Question 7A


Hi all,



Not sure I like this question at all. Normalising to 1NF sounds simple enough, particularly when students are required to use just one set of sample records, but this seems like it requires a lot for 3 marks:



Choosing the first record (fancy_cat), here's what I think would be required for full marks:


userName

fullName

interestGroup

contactList

fancy_cat

Francine Ulas

love_planes

paperclip55

fancy_cat

Francine Ulas

love_planes

panic_disco

fancy_cat

Francine Ulas

love_planes

starwarsfan

fancy_cat

Francine Ulas

love_planes

melanie_franks

fancy_cat

Francine Ulas

love_planes

WalterEllison27

fancy_cat

Francine Ulas

classOf2104

paperclip56

fancy_cat

Francine Ulas

classOf2105

panic_disco

fancy_cat

Francine Ulas

classOf2106

starwarsfan

fancy_cat

Francine Ulas

classOf2107

melanie_franks

fancy_cat

Francine Ulas

classOf2108

WalterEllison28

fancy_cat

Francine Ulas

cooking_rox

paperclip57

fancy_cat

Francine Ulas

cooking_rox

panic_disco

fancy_cat

Francine Ulas

cooking_rox

starwarsfan

fancy_cat

Francine Ulas

cooking_rox

melanie_franks

fancy_cat

Francine Ulas

cooking_rox

WalterEllison29




That's 15 individual records students would have to write out, unless I'm mistaken. Will students be penalised if they do the sensible thing and normalise this data to 2NF by creating separate tables?



I thought I understood normalising to 1NF, but perhaps I'm wrong. The addition of that 4th field (contactList) has seemingly made this a big challenge (15 lines of writing) for just 3 marks.



I'd appreciate feedback/corrections from others on this question, since it has me somewhat confused.



Cheers,

Gary

Important - This email and any attachments may be confidential. If received in error, please contact us and delete all copies. Before opening or using attachments check them for viruses and defects. Regardless of any loss, damage or consequence, whether caused by the negligence of the sender or not, resulting directly or indirectly from the use of any attached files our liability is limited to resupplying any affected attachments. Any representations or opinions expressed are those of the individual sender, and not necessarily those of the Department of Education and Early Childhood Development.

Important - This email and any attachments may be confidential. If received in error, please contact us and delete all copies. Before opening or using attachments check them for viruses and defects. Regardless of any loss, damage or consequence, whether caused by the negligence of the sender or not, resulting directly or indirectly from the use of any attached files our liability is limited to resupplying any affected attachments. Any representations or opinions expressed are those of the individual sender, and not necessarily those of the Department of Education and Early Childhood Development.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20141109/8502a8ac/attachment-0001.html