1 / 9

Introduction to Databases Day 2

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.

amena
Download Presentation

Introduction to Databases Day 2

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Introduction to DatabasesDay 2 SRT II Mr. Davis Fall 2011

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

  3. Day 2 • Build on the Customer DB • Now we need to add sales information • Where to start?

  4. Order Tracking DB • Planning • Fields to include • How do fields relate? • Establishing relationships

  5. Order Tracking DB • Now we can start to ask interesting questions! • Query design

  6. Order Tracking DB • What about entering the information? • Designing a data-entry form

  7. 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

  8. 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!

  9. 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

More Related