_DatabaseIntro_1up - CS 200 Lecture 06 Database Introduction CS 200 Spring 2014 Monday June 9 2014 1 Database Introduction Miscellaneous Notes

_DatabaseIntro_1up - CS 200 Lecture 06 Database...

This preview shows page 1 - 18 out of 79 pages.

CS 200 CS 200 Spring 2014 Database Introduction 1 Lecture 06 Database Introduction Monday, June 9, 2014
Image of page 1
CS 200 Spring 2014 Database Introduction Abbreviations aka also known as DBMS DataBase Management System mutatis mutantis with the necessary changes having been made 2 Miscellaneous Notes Monday, June 9, 2014
Image of page 2
CS 200 Spring 2014 Database Introduction Please read and highlight BEFORE lab Assignment 5 This week’s lecture slides Reading Database Design (learn.uwaterloo.ca) Adapted from Access Database Design and Programming by Steven Roman Today Database basics and Design Creation of a database Reports and Queries Relationships Please ask questions! 3 Administrivia Monday, June 9, 2014
Image of page 3
CS 200 Spring 2014 Database Introduction Assumptions You have used a database before You understand basic data management 4 Monday, June 9, 2014
Image of page 4
CS 200 Spring 2014 Database Introduction Things to think aboutWhat are the data objects in FileMaker?How does the interface differ from other applications we have seen so far?What are the eciencies and deficiencies of the interface?What are different databases you use?How are the databases you are part of used?Is the way data is displayed important? 5 Monday, June 9, 2014
Image of page 5
CS 200 Spring 2014 Database Introduction This is your fi rst pass at FileMaker by the end of this section you will be able to: design a simple database create queries and reports understand database terminology and create relationships with a database Our objectives are to introduce you to database fundamentals Expose you to an application speci fi c to database – FileMaker 6 Databases–FileMaker Monday, June 9, 2014
Image of page 6
CS 200 Spring 2014 Database Introduction A collection of related data Data consists of information on a speci fi c topic 7 What is a Database? Monday, June 9, 2014
Image of page 7
CS 200 Spring 2014 Database Introduction Use of DatabasesWhat databases are you a part of?What are some of the benefits of belonging to a database?What are some of the drawbacks?Why/when do I use a database? 8 Monday, June 9, 2014
Image of page 8
CS 200 Spring 2014 Database Introduction Field Record Table File 9 FileMaker Terminology (1) Monday, June 9, 2014
Image of page 9
CS 200 Spring 2014 Database Introduction FileMaker Terminology (2) Layout Report Query 10 Monday, June 9, 2014
Image of page 10
CS 200 Spring 2014 Database Introduction Creation of a TableConsider the following example:You would like to create a database with all of the Albums you have downloaded onto your iPod.What info would be relevant to have in a table?What types of fields will each of these be? 11 Monday, June 9, 2014
Image of page 11
CS 200 Spring 2014 Database Introduction Creating a Database 12 Monday, June 9, 2014
Image of page 12
CS 200 Spring 2014 Database Introduction Creating A Database Creation of a new database is similar to other applications File: New Database 13 Monday, June 9, 2014
Image of page 13
CS 200 Spring 2014 Database Introduction Creating a Table within our Database 14 Monday, June 9, 2014
Image of page 14
CS 200 Spring 2014 Database Introduction De fi ning Fields 15 Monday, June 9, 2014
Image of page 15
CS 200 Spring 2014 Database Introduction Data Validation 16 Monday, June 9, 2014
Image of page 16
CS 200 Spring 2014 Database Introduction You can’t mistype something that’s entered for you! 17 Data Validation in FileMaker (1) Monday, June 9, 2014
Image of page 17
Image of page 18

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture