CS 200
CS 200 Spring 2014
Database Introduction
1
Lecture 06
Database Introduction
Monday, June 9, 2014

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

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

CS 200 Spring 2014
Database Introduction
Assumptions
You have used a database before
You understand basic data management
4
Monday, June 9, 2014

CS 200 Spring 2014
Database Introduction
Things to think about•What are the data objects in FileMaker?•How does the interface differ from other applications we have seen so far?•What are the efficiencies 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

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

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

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

CS 200 Spring 2014
Database Introduction
Field
Record
Table
File
9
FileMaker Terminology (1)
Monday, June 9, 2014

CS 200 Spring 2014
Database Introduction
FileMaker Terminology (2)
Layout
Report
Query
10
Monday, June 9, 2014

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

CS 200 Spring 2014
Database Introduction
Creating a Database
12
Monday, June 9, 2014

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

CS 200 Spring 2014
Database Introduction
Creating a Table within our Database
14
Monday, June 9, 2014

CS 200 Spring 2014
Database Introduction
De
fi
ning Fields
15
Monday, June 9, 2014

CS 200 Spring 2014
Database Introduction
Data Validation
16
Monday, June 9, 2014

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
