1 / 9

Sales Tracking Database Design: Building on Customer Info

Learn to design a normalized sales tracking database by expanding the contact database from Day 1, adding sales information, establishing relationships, query design, data entry form, preventing bad data, and creating sample data.

amena
Télécharger la présentation

Sales Tracking Database Design: Building on Customer Info

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