Introduction to Databases

Day 2

SRT IIMr. DavisFall 2011

Objective

SWBAT….Design a normalized sales tracking database by expanding the contact database built in Day 1.

Day 2

• Build on the Customer DB

• Now we need to add sales information

• Where to start?

Order Tracking DB

• Planning– Fields to include

• How do fields relate?– Establishing relationships

Order Tracking DB

• Now we can start to ask interesting questions!

• Query design

Order Tracking DB

• What about entering the information?– Designing a data-entry form

Extras

• How do we prevent bad data from getting into tables in the first place?– Input mask– Validation rule

• Add validation rules to email, ZIP code, and state fields

Sample data

• Checking your structure can be difficult– Import existing ‘real’ data– Generate ‘dummy’ data

• For sample data– Free data generator– Customize fields, types of data –

experiment!

MS Access Assignment

• Design an experiment-tracking DB• Requirements– Tables for

• Researchers• Test performed (at least 5 different tests)• Results

– Data entry forms• New researcher• Test results

– Populate the DB with sample data– Save in H: drive, SRT II Turn-in folder; YourName_ResearchDB.accdb

• Due at the end of next class