[Informatics] POTG FileMaker Pro Solution

[Stephen Trouse]

Time for an update of the textbook then...

-----Original Message-----
From: informatics [mailto:informatics-bounces at edulists.com.au] On Behalf Of Ciotti, George W
Sent: Tuesday, 27 February 2018 6:41 PM
To: Year 12 VCE Informatics Teachers' Mailing List <informatics at edulists.com.au>
Subject: Re: [Informatics] POTG FileMaker Pro Solution

Hi Stephen,

The textbook uses this notation. Most students use the textbook, and it's on our booklist. We are also using Access. So in my mind using this notation with students provides them with a consistent approach. Whatever is used must be consistently applied no doubt. 
At this stage they are not in industry so at the very least they will understand that there is a convention and will be able to apply this knowledge currently and when they see other notation conventions. Anything else in my mind might confuse my students with what really is a minor, yet nonetheless foundational, facet of designing and developing a RDMS.

Cheers

George

Computing, Digital Technologies & Systems UHS Web & eNews publications

The University High School
www.unihigh.vic.edu.au

PH: 9347 2022


On 27/2/18, 9:46 am, "informatics on behalf of Stephen Trouse" <informatics-bounces at edulists.com.au on behalf of Stephen.Trouse at flinders.vic.edu.au> wrote:

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


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 Training.
_______________________________________________
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