[Year 12 IT Apps] NINE mark question??

Wed Nov 14 16:23:54 EST 2012

I've normalised myself with a jolly nice Chardonnay, and my solution to the
question is at http://www.vceit.com/postmortems/2012ita/ita2012.htm
I've yet to proofread it for howlers, but it's basically finished.

And the normalisation question was a pig to work on. It took me 30 minutes,
with one or two false starts, to explain it halfway clearly. And I fear
even now it's not strictly accurate.
Dog only know how even the best kids coped.

On 14 November 2012 10:35, Mark Scott <msc at luther.vic.edu.au> wrote:

> ** **
>
> ** **
>
> Peter ****
>
> ** **
>
> I would have separated the DB into three tables as part of 2NF and then
> got rid of the Total fee calculation field as 3NF****
>
> ** **
>
> And students should at least show the completed Relationship Diagram.****
>
> ** **
>
> Tricky part is explaining how each (do they mean separately?) normal form
> ensures the integrity of data.****
>
> ** **
>
> But I will wait and see what the gurus have to say (you out there Mark K?)
> ****
>
> ** **
>
> thanks****
>
> Mark Scott****
>
> Luther College****
>
> ** **
>
> *From:* itapps-bounces at edulists.com.au [mailto:
> itapps-bounces at edulists.com.au] *On Behalf Of *Peter Langham
> *Sent:* Wednesday, 14 November 2012 10:05 AM
> *To:* Year 12 IT Applications Teachers' Mailing List
> *Subject:* Re: [Year 12 IT Apps] NINE mark question??****
>
> ** **
>
> Here's my attempt at the normalisation question****
>
>  ****
>
> 1NF - No lists of data in any cell. ****
>
> Divide the data in any of the memberName, memberAddress, driverName
> fields. ****
>
> memberAddress becomes: memberAddress becomes memberAddress and
> memberPostcode****
>
> E.g. ****
>
> memberAddress : 2 Hill St****
>
> memberSuburb : Richmond****
>
> This allows for more specific queries. E.g. Filtering data by Suburb.****
>
>  ****
>
> 2NF - each non-key field must be fully dependent on the key****
>
> yearsWorked is dependent on driverName. Make a seperate table where
> driverName is the Primary Key and it is a Foreign Key in the memberName
> table.****
>
> Table 1: memberName, memberAddress, driverName (foreign key), carRate($),
> totalFee($)****
>
> Table 2: driverName (primary key), yearsWorked****
>
> This ensures data integrity as the yearsWorked data would only need to be
> updated in the one cell now instead of multiple cells.****
>
>  ****
>
> 3NF - every field in a table must relate directly to the primary key
> carRate($) is dependent on the size of the car. I'd add a foreign key
> field to table1 carSize which would become a primary key field in the third
> table.****
>
> Table 1: memberName, memberAddress, driverName (foreign key), carSize
> (foreign key) ****
>
> Table 2: driverName (primary key), yearsWorked****
>
> Table 3: carSize, carRate($)****
>
>  ****
>
> This leaves us with what I beleive should be a calculated field,
> totalFee($).****
>
> totalFee($): [yearsWorked]*[carRate($)]****
>
>  ****
>
> I may have 2NF and 3NF in the wrong order.****
>
>  ****
>
> Unfortunately, I didn't go over this in a lot of depth with my students, I
> expected that they would have the choice of which Normal Form they solved
> for, like the VCAA sample exam so we focused on 1NF more heavily than the
> other two normal forms.****
>
>  ****
>
> Peter Langham****
>
> Narre Warren South P-12****
>
>  ****
>
> On Wed, Nov 14, 2012 at 9:30 AM, Mark Scott <msc at luther.vic.edu.au> wrote:
> ****
>
>  ****
>
> Mark****
>
>  ****
>
> It will be Q9 (the Normalisation one) that will be the one most poorly
> answered.****
>
>  ****
>
> I am looking forward to seeing your solution for that one.****
>
>  ****
>
> J****
>
>  ****
>
> Mark Scott
> Luther College****
>
>  ****
>
> *Mark Scott **
> *Daily Administrator
> Luther****
>
> Plymouth Road
> Croydon Hills Victoria 3136****
>
> Luther****
>
> Telephone (03) 9724 2000
> Direct Line (03) 9724 2023 ****
>
> www.luther.vic.edu.au ****
>
> [image: Luther College] <http://www.luther.vic.edu.au/>****
>
> *Please consider the environment before printing this email.*****
>
> This email and any attachments may contain privileged and confidential
> information.
> If you are not the intended recipient you may not distribute or reproduce
> this email
> or attachments. If you have received this message in error please notify
> us by return mail.****
>
>
> ****
>
> ** **
>
> *From:* itapps-bounces at edulists.com.au [mailto:
> itapps-bounces at edulists.com.au] *On Behalf Of *Mark KELLY
> *Sent:* Wednesday, 14 November 2012 9:15 AM
> *To:* Year 12 IT Applications Teachers' Mailing List
> *Subject:* [Year 12 IT Apps] NINE mark question??****
>
>  ****
>
> I wonder what the logic was behind changing the eight mark question into a
> nine mark question.****
>
>  ****
>
> Was it something like, "Let's take the question that was most poorly
> answered last year and make it even more difficult." ?
> ****
>
>  ****
>
> --
> Mark Kelly - kel at mckinnonsc.vic.edu.au
> Manager of ICT, Reporting, IT Learning Area
> McKinnon Secondary College, McKinnon Rd, McKinnon 3204, Victoria, Australia
> Phone: +613 8520 9085, Fax +613 9578 9253
> VCE IT Lecture Notes: http://vceit.com
> Moderator: IT Applications Edulist<http://edulists.com.au/itapps/index.htm>
> Visit Diigo links for ITA <http://groups.diigo.com/group/vce-info-tech>and
> SD <http://groups.diigo.com/group/vce-sd>
> --
> My personal best for the 100 metre sprint is 11.9 metres.
>
> ****
>
>
> _______________________________________________
> http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe
> IT Applications Mailing List kindly supported by
> http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html -
> Victorian Curriculum and Assessment Authority <br>
> http://www.vitta.org.au  - VITTA Victorian Information Technology
> Teachers Association Inc <br>
> http://www.swinburne.edu.au/ict/schools - Swinburne University****
>
> ** **
>
> _______________________________________________
> http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe
> IT Applications Mailing List kindly supported by
> http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html -
> Victorian Curriculum and Assessment Authority <br>
> http://www.vitta.org.au  - VITTA Victorian Information Technology
> Teachers Association Inc <br>
> http://www.swinburne.edu.au/ict/schools - Swinburne University
>

-- 
Mark Kelly - kel at mckinnonsc.vic.edu.au
Manager of ICT, Reporting, IT Learning Area
McKinnon Secondary College, McKinnon Rd, McKinnon 3204, Victoria, Australia
Phone: +613 8520 9085, Fax +613 9578 9253
VCE IT Lecture Notes: http://vceit.com
Moderator: IT Applications Edulist <http://edulists.com.au/itapps/index.htm>
Visit Diigo links for ITA <http://groups.diigo.com/group/vce-info-tech> and
SD <http://groups.diigo.com/group/vce-sd>
--
My personal best for the 100 metre sprint is 11.9 metres.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20121114/67791260/attachment-0001.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 12076 bytes
Desc: not available
Url : http://www.edulists.com.au/pipermail/itapps/attachments/20121114/67791260/attachment-0001.png 