Resources

• Computer Based Training on Microsoft® Visio®
  • What's New in Microsoft® Office Visio® 2007 (Revision B)
  • Microsoft® Office Visio® Professional 2007: Level 1
  • Microsoft® Office Visio® Professional 2007: Level 2
• Microsoft Visio Courses
• Microsoft Visio Help
• North Carolina Health Info has a great ER diagram of their database.
• Sample UML Company Diagram (in MS Visio format): EER Diagram

• Computer Based Training on Access 2007
  • Microsoft® Office Access™ 2007: New Features
  • Microsoft® Office Access™ 2007: Level 1
  • Microsoft® Office Access™ 2007: Level 2
  • Microsoft® Office Access™ 2007: Level 3
  • Microsoft® Office Access™ 2007: Level 4

  • SQL Fundamentals of Querying Part 1.
  • SQL Fundamentals of Querying Part 2.
  • SQL Fundamentals of Querying Part 3.
  Microsoft Access 2007 Courses
• Microsoft Access 2007 Help
• MacDonald, M. (2006). Access 2007: The Missing Manual Sebastopol, CA: O'Reilly Media Inc. Available at Safari books as an ebook through the UNC license.
  Other reference books are also available: search on "database" or "SQL", for example.
• An SQL tutorial
• A relational schema for the company database (in MS Visio format).

Archiving Software
7-Zip open source utility.

Hints for Homework

• Homework submission guidelines
• DB Checklist: This is a checklist you can use as you are creating your databases to help you determine if you have completed all the steps.
• Steps for Converting an ER Diagram into a Relational Database Schema: These are the same steps as those given in the text, but without the formal notation and including examples from the Company database.
• Guidelines for homework containing models.