90 likes | 163 Views
Introduction to Databases Day 2. SRT II Mr. Davis Fall 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.
E N D
Introduction to DatabasesDay 2 SRT II Mr. Davis Fall 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