[Year 12 IT Apps] ITA new design. Sorry - another one.

[Allan Barnes]

Correct - not all database programs enforce referential integrity, so it can
give rise to invalid data.

 

 

 

 

Kind regards

 

Allan Barnes, CEO

Australian Institute of Education and Training

P.O. Box 171

Brunswick West 3055

Melbourne, Victoria

Ph: (03) 9387 2051

FAX: (03) 9387 3470

Mobile: 0409 428 221

 

 

 

From: itapps-bounces at edulists.com.au [mailto:itapps-bounces at edulists.com.au]
On Behalf Of Mike Brookes
Sent: Friday, 26 March 2010 3:50 PM
To: Year 12 IT Applications Teachers' Mailing List
Subject: Re: [Year 12 IT Apps] ITA new design. Sorry - another one.

 

Normalising a database is a process for making the design of tables more
efficient.

http://databases.about.com/od/specificproducts/a/normalization.htm

Referential integrity is about preventing the user entering a value in a
foreign key field which does not exist in the key field of the table being
looked up.

If Filemaker does not enforce referential integrity what does it do if it
can't link the two tables?

Mike Brookes
Chief cook and bottlewasher
Copperfield College


On 26/03/2010 3:02 PM, Mark KELLY wrote: 

Apologies for all the posts, but the new design is an interesting beast.

ITA U3O2 Key Knowledge 11 - "ways in which normalisation can ensure the
integrity of data in an RDBMS"

Assuming they mean "referential integrity", this will be an interesting
dotpoint if you're using Filemaker which does not use the concept of
referential integrity*


*Except as an awkward kludge by using a validation rule ("exists in limited
list") and defining the list to include values in a foreign key field.

-- 
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


_______________________________________________ 
http://www.edulists.com.au  <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/infotechindex.html
<http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html%20>
- Victorian Curriculum and Assessment Authority and 
http://www.vitta.org.au  <http://www.vitta.org.au> - VITTA Victorian
Information Technology Teachers Association Inc


_______________________________________________ 
http://www.edulists.com.au  <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/infotechindex.html
<http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html%20>
- Victorian Curriculum and Assessment Authority and 
http://www.vitta.org.au  <http://www.vitta.org.au> - VITTA Victorian
Information Technology Teachers Association Inc


-- 
This message has been scanned for viruses and 
dangerous content by  <http://www.mailscanner.info/> MailScanner, and is 
believed to be clean. 

 

Message protected by MailGuard: e-mail anti-virus, anti-spam and content
filtering.
http://www.mailguard.com.au/mg


Report
<https://login.mailguard.com.au/report/1zymuJ4RcQ/sVE876gSPiBVDNO7rAAIa/2.00
2>  this message as spam  
 

No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 9.0.791 / Virus Database: 271.1.1/2768 - Release Date: 03/26/10
07:50:00

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20100326/6b28642e/attachment.html