[Informatics] POTG FileMaker Pro Solution

Tue Feb 27 06:01:52 EST 2018

Hi all,

tblStudents or StudentsTable 
qrySales2018 or Sales2018View

Tomato tomato potato potato let's call the whole thing off.  Same diff.

Students need to understand naming their objects with clear and meaningful names - and if in doubt put the type of object embedded within the name.

In MSAccess this undoubtedly is still called query as distinct from View, but I've worked with Oracle, TOAD, SQL Server and created saved queries which are indeed called views once saved in the Schema, but I can make this mental leap because I've been well drilled in creating meaningful names - initially using MS Access, which is where many students still get their first relational database taste.

If you don't use meaningful names which most likely also include the object type within, then I can't be certain that examiners will treat you well.

For me, at least with this Study Design, I'm using tbl, qry, rpt and frm. And I'd be careful with field name prefixes also - my top students will probably be mentored to use txt/int/fl/cur/bool etc, even though I think it's overkill.

LG

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

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.