_FileMaker2_1up - CS 200 Lecture 09 FileMaker vs SQL Reports CS 200 Spring 2014 Monday July 7 14 1 FileMaker vs SQL Reports Miscellaneous Notes

_FileMaker2_1up - CS 200 Lecture 09 FileMaker vs SQL...

This preview shows page 1 - 9 out of 51 pages.

CS 200 CS 200 Spring 2014 FileMaker vs SQL + Reports 1 Lecture 09 FileMaker vs SQL & Reports Monday, July 7, 14
Image of page 1
FileMaker vs SQL + Reports CS 200 Spring 2014 Abbreviations aka also known as DBMS DataBase Management System mutatis mutantis with the necessary changes having been made 2 Miscellaneous Notes Monday, July 7, 14
Image of page 2
FileMaker vs SQL + Reports CS 200 Spring 2014 Please read and highlight BEFORE lab Assignment 9 This week’s lecture slides Reading Database Design (on learn.uwaterloo.ca) Adapted from Access Database Design and Programming by Steven Roman Today SQL vs FileMaker Reports in FileMaker Read and Reason Pearl Please ask questions! 3 Administrivia Monday, July 7, 14
Image of page 3
FileMaker vs SQL + Reports CS 200 Spring 2014 This is your second pass at FileMaker The fi rst time around, you got a rough idea of what it does This time round we’ll fi ll in some important details evaluate its power & exibility Our strategy SQL as an application model for FileMaker so we’ll “compare and contrast...” the two Recall the Albums and Songs database Arrows go FROM a foreign key TO a corresponding primary key (they DO NOT have to go between fi elds with the same name!) 4 Albums Album_ID Title Group Medium Category Price Purchase Date Copyright Label Sample Songs Song_ID Side Track Title Mins Secs Album_ID Databases–FileMaker Monday, July 7, 14
Image of page 4
FileMaker vs SQL + Reports CS 200 Spring 2014 In SQL: select Title, Artist, Price from Albums In FileMaker: make a new layout choose, position, label and format fi elds enter browse mode In each vs the other ... what’s di ff erent? what’s better? what’s worse? what’s easier? what’s harder? what can’t be done? 5 Simple One-Table Queries (1) Monday, July 7, 14
Image of page 5
FileMaker vs SQL + Reports CS 200 Spring 2014 In SQL: select Title, Artist from Albums where Price < 10.00 In FileMaker: make another new layout choose, position, label, & format fi elds enter fi nd mode & type the condition (“ query by example ”) then perform the fi nd In each vs the other ... what’s di ff erent? better? worse? easier? harder? can’t be done? 6 Simple One-Table Queries (2) Monday, July 7, 14
Image of page 6
FileMaker vs SQL + Reports CS 200 Spring 2014 How about...selectTitle, Artist from Albumswhere (Price < 14.00) and (Artist = ‘Mozart’) ?vOne-Table Queries (and)Hmm ... what’s the “Omit” check box do?(Read and Remember...)T 7 Monday, July 7, 14
Image of page 7
FileMaker vs SQL + Reports CS 200 Spring 2014
Image of page 8
Image of page 9

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture