[Year 12 IT Apps] Qu A 20

[Robert Hind]

I have used this example for a relational database in the past. One book can 
be borrowed many times over its "life" in the library, and one borrower can 
borrow many books. So the logical answer is B.

Robert Hind (Semi-retired)
Ex Traralgon and Ashwood

----- Original Message ----- 
From: "Philip Pike" <philip.pike at geelongcollege.vic.edu.au>
To: <itapps at edulists.com.au>
Sent: Wednesday, November 14, 2007 1:01 PM
Subject: Re: [Year 12 IT Apps] Qu A 20


> 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
>
>
> -- 
> ################################################################################
> This e-mail and any attached files are confidential and intended solely 
> for the person to whom it is addressed.  If you have received this e-mail 
> in error then please notify the sender immediately.  The contents 
> represent the views or opinions of the author only and are not necessarily 
> made on behalf of the School.  The recipient should check this e-mail and 
> any attachments for the presence of viruses; the School does not accept 
> liability for any damage caused by a transmitted virus.
> ################################################################################
>
> Message  protected by MailGuard: e-mail anti-virus, anti-spam and content 
> filtering.
> http://www.mailguard.com.au/tt
>
>
> _______________________________________________
> 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
>
>