[Year 12 IT Apps] Qu A 20

[Trish Cotter]

Totally agree Mark.
Any library database has a loans table that would hold records of all loans including the many
loans of any one particular book and all the loans made by any particular borrower.  once the data
is transferred to the loans table it remains there until archived so the only 'one' is the actual
number for that particular loan transaction.

In other words Loan_ID is the only field that can only appear once in the loan table. Answer is
therefore B.
-- 
Regards,
Trish Cotter
Koonung Secondary College
*******
tcotter at koonung.vic.edu.au

On Wed, November 14, 2007 1:40 pm, Mark Kelly wrote:
> If the loans table is only CURRENT loans, then a book can only appear
> once, but a borrower could still appear many times.  But if the table
> holds both current and past loans, any book or borrower could appear
> many times.
>
> I was going to talk to our librarian about it, but decided that students
> in an exam didn't have that luxury so I couldn't either  :-)
>
> Philip Pike wrote:
>> Any comments on Section A Q 20?
>>
>> I would have liked to see a 1 to 1 relationship from the book into the
>> loan table. A book can only be borrowed once.
>>
>> Comments?
>>
>>
>> Phil Pike
>> Geelong College
>>
>>
>
>
> --
> 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 95789253
> kel AT mckinnonsc.vic.edu.au
>
> Webmaster - http://www.mckinnonsc.vic.edu.au
> IT Lecture notes: http://vceit.com
> Moderator: IT Applications Mailing List
>
> You'll know when we are officially a civilised race: our schools have
> all the money they need and the Air Force has to run a chook raffle to
> buy a new bomber.
>
> _______________________________________________
> http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe
> IT Applications Mailing List kindly supported by
> http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html - Victorian Curriculum and
> Assessment Authority and
> http://www.vitta.org.au  - VITTA Victorian Information Technology Teachers Association Inc
>