[Informatics] POTG FileMaker Pro Solution

[Stephen Trouse]

On a side note, I would be steering away from Hungarian notation for variables and database entities ("tblStudents").  This nomenclature has not really been used since around 2002.  The modern "object" way to describe them, which emphasises its business use, is:  "What is does" - "What it is", e.g. for a button: CreateUserButton.  In tables, they are assumed to be tables so "TABLE" in the name is not required.  If you have a view (yes, it's not called a query), it can be identified as EnrolledStudentView.
The "tbl" nomenclature is a leftover from Access database design and not common in industry now.
Hope this helps.



-----Original Message-----
From: informatics [mailto:informatics-bounces at edulists.com.au] On Behalf Of Alan Stafford
Sent: Thursday, 22 February 2018 11:31 AM
To: Year 12 VCE Informatics Teachers' Mailing List <informatics at edulists.com.au>
Subject: [Informatics] POTG FileMaker Pro Solution

Hi All
A little specific for this distribution list, sorry if so..
We are looking towards 301 SAC1 Outcome 1 in a couple of weeks and we have been working upon POTG.
I am seeking a POTG FileMaker Pro set of Tables (fields inc).
I am specifically interested as to whether one should develop:
tblCustomer
tblPizzaType
tblPizzaSize
and how to establish the
tblPizzaOrders  with the calculated fields probably as Foreign Keys

Thank you in advance
Alan Stafford
Informatics and Computing
OACC
________________________________

OVERNEWTON ANGLICAN COMMUNITY COLLEGE
T +61 3 9334 0000 W www.overnewton.vic.edu.au<http://www.overnewton.vic.edu.au>

KEILOR CAMPUS 2-50 Overnewton Road Keilor, Victoria, 3036 | F +61 3 9336 1835 TAYLORS LAKES CAMPUS 39 - 57 Robertsons Road Taylors Lakes, Victoria, 3038 | F +61 3 9390 5144

A dual campus, coeducational Prep to Year 12 school. Delivering consistently high academic results in Melbourne's North West for over 30 years.
2018 College Theme | " I wonder ..."

Consider the environment before choosing to print this email.
_______________________________________________
http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe VCE Informatics 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