[Year 12 IT Apps] IARTV October test

[Mark Kelly]

Ah, right!  Thanks for your experiment.

So it's an Microsoft Access situation to have enforced referential 
integrity. (Do other RDBMS do this too?)

This is the problem with ITA.  We all tend to specialise in a particular 
make and model of software, and we tend to assume everyone else uses the 
same make and model...  including the examiners.

It's a dangerous parochialism - and the examiners must be extra-cautious 
when drafting software questions so they are not make/model prejudiced.


Lumsden, Richard G wrote:
> See attch
> 
> 
> 
> -----Original Message-----
> From: itapps-bounces at edulists.com.au
> [mailto:itapps-bounces at edulists.com.au] On Behalf Of Mark Kelly
> Sent: Thursday, 3 September 2009 3:22 PM
> To: Year 12 IT Applications Teachers' Mailing List
> Subject: Re: [Year 12 IT Apps] IARTV October test
> 
> Oops.  Hit SEND too soon.  The second last para should read:
> 
> e.g. a person can only be allocated to a location that exists in the
> location table.  This can be done by forcing employees' locations be
> selected from a drop-down list whose contents are populated
> automatically with values from the locations list.  You can also set up
> a validation rule stating that the value in the location field must
> exist in a limited list.
> 
> 
> Mark Kelly wrote:
>> Hi all.
>>
>> Anyone else using the CSE's IARTV October test for ITA?
>>
>> I'm having issues with one of its database questions (4c):
>>
>> "A one-to-many relationship is established between the Employees Table
> 
>> and the Locations table.
>>
>> Explain why setting this relationship would prevent a row in the
>> location table being deleted if some employees were still allocated to
> 
>> that location."
>>
>> The suggested answer is "Setting a relationship will prevent deletion
> of
>> any row that is used as a key in an existing relationship -
> referential
>> integrity."
>>
>> This is just not true, at least in Filemaker.  You certainly can
> delete
>> a record in a related table when local records still reference it. Do
>> other databases behave differently?
>>
>> Secondly, as I understand it, referential integrity (at least in
>> Filemaker) is not automatically created when a relationship is set up.
> 
>> It's a deliberate strategy to ensure that values can only selected
> from
>> an existing list of options.
>>
>> e.g. a person can only be allocated to a location that exists in the
>> location table.  This can be done by forcing employees' locations be
>> selected from a drop-down list whose contents are populated
>> automatically with values from the locations list.  You can also set
> up
>> a validation rule stating that the value in the location
>>
>> Again, do other databases have referential integrity enforced by the
>> RDBMS - and how do they do it?
>>
> 
> 
> --
> Mark Kelly
> Manager - Information Systems
> McKinnon Secondary College
> McKinnon Rd McKinnon 3204, Victoria, Australia
> Direct line / Voicemail: 8520 9085
> School Phone +613 8520 9000
> School Fax +613 9578 9253
> kel at mckinnonsc.vic.edu.au
> 
> Webmaster - http://www.mckinnonsc.vic.edu.au
> IT Lecture notes: http://vceit.com
> Moderator: IT Applications Mailing List
> 
> RealMenDon'tNeedSpacebars.
> 
> _______________________________________________
> 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 and
> http://www.vitta.org.au  - VITTA Victorian Information Technology
> Teachers Association Inc
> 
> 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.
> _______________________________________________
> 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 and
> http://www.vitta.org.au  - VITTA Victorian Information Technology Teachers Association Inc

-- 
Mark Kelly
Manager - Information Systems
McKinnon Secondary College
kel AT mckinnonsc.vic.edu.au
McKinnon Rd, McKinnon 3204, Victoria, Australia
Direct line / Voicemail: 8520 9085 Fax +613 9578 9253

Webmaster - http://www.mckinnonsc.vic.edu.au
IT Lecture notes: http://vceit.com
Moderator: IT Applications Mailing List

Why do people mis-spell 'grammar' and mispronounce 'pronuniciation'?