[Year 12 IT Apps] NINE mark question??

[Mark KELLY]

I'd be surprised if any of us covered normalisation to the extent that the
question required.
A full discussion of all 3 normal forms - worth 6 marks?

Tell 'em they're dreamin'



On 14 November 2012 10:05, Peter Langham <peterlangham1983 at gmail.com> wrote:

> 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/7034d1b2/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/7034d1b2/attachment-0001.png