United States   Change   |   All Microsoft Sites

Home - SQL Server 2005

Microsoft Home  |  Servers and Tools

Express Database Schemas

Deploying SQL Server Express in Real-World Environments

This Database Schema series is designed for new database administrators and enthusiasts to quickly get started learning the basics of managing and administering SQL Server 2005 Express Edition in real-world environments. These fully-functional starter Database Schemas cover a wide-range of scenarios that are designed to help you quickly and easily deploy SQL Server 2005 Express Edition within your organization.Take advantage of these pre-built SQL Server 2005 Express Database Schemas and documentation. Each Database Schema includes SQL Server Express scripts, a sample database (.MDF) and database schema. Additionally, the Database Schemas can be easily modified and extended to suite your individual needs.

Note: These starter Database Schemas require SQL Server 2005 Express Edition, which you can download here. For other resources to help you get started, see Starter Kits and  Sample Applications.

Recommended Training Video:

A webcast tutorial is available for beginners titled Understanding a Database Schema. Play the webcast to learn how database schemas relate in a real-world database environment scenario and see a step-by-step guide on how to build a database schema. This tutorial features the Customers and Orders Database Schema listed below.

Select your starting point below

Database Schema 1: Assets Maintenance

Click to enlarge

Create and manage assets, faults, maintenance contracts, parts and staff within your organization. Database schema set includes SQL Server 2005 Express Edition scripts, a sample database (.MDF) and database schema.

Database Schema 2: Contact Management

Click to enlarge

Collect customer information that includes a detailed contact list, sales activities, sales activities outcome and contact status. Database schema set includes SQL Server 2005 Express Edition scripts, a sample database (.MDF) and database schema.

Database Schema 3: Customers and Orders

Click to enlarge

Log customer order information ranging from customer address and payment method, products purchased, order and delivery information and more. Database schema set includes SQL Server 2005 Express Edition scripts, a sample database (.MDF) and database schema. (This Database Schema is featured in the Understanding a Database Schema tutorial.)

Database Schema 4: Document Management

Click to enlarge

Track documents in your organization by user and role. Includes document structures and types, user roles and access rights, functional areas and images. Database schema set includes SQL Server 2005 Express Edition scripts, a sample database (.MDF) and database schema.

Database Schema 5: e-Commerce

Click to enlarge

Log e-Commerce orders information ranging from customers, invoices, items ordered, payment method, shipments and more. Database schema set includes SQL Server 2005 Express Edition scripts, a sample database (.MDF) and database schema.

Database Schema 6: Helpdesk

Click to enlarge

Track help desk information that includes problem history, priority levels, equipment, support staff and user assignment, and resolution. Database schema set includes SQL Server 2005 Express Edition scripts, a sample database (.MDF) and database schema.

Database Schema 7: Issue Tracking Software

Click to enlarge

Follow a software issue from initial report and assignment to real-time status and closure. Database schema set includes SQL Server 2005 Express Edition scripts, a sample database (.MDF) and database schema.

Database Schema 8: Retail Inventory Control

Click to enlarge

Collect retail inventory information, such as stock levels, supplier data, brands, item categories and more. Database schema set includes SQL Server 2005 Express Edition scripts, a sample database (.MDF) and database schema.

Database Schema 9: Not-for-Profits

Click to enlarge

Organize your Not-for-Profit with this helpful Database Schema. Log data that includes events, roles, people skills, event staff and more. Database schema set includes SQL Server 2005 Express Edition scripts, a sample database (.MDF) and database schema.

Database Schema 10: Product Catalogs

Click to enlarge

Track product catalogs data in this sample Database Schema, including catalog entry definitions, contents and structure. Database schema set includes SQL Server 2005 Express Edition scripts, a sample database (.MDF) and database schema.

Database Schemas Feedback

We'd love to develop more SQL Server 2005 Express Database Schemas, so please let us know how we're doing! What did you learn from the Database Schemas? Did they help you quickly deploy a SQL Server 2005 Express database in a real-world environment? Were you able to save time using them as a solution for a work project? Send all your comments and suggestions to ssedmf@microsoft.com. Additionally, if there's a particular Database Schema you'd like to see, be sure to tell us and we'll see what we can do!

About the Author

Barry Williams, founder and Principal Consultant with www.DatabaseAnswers.org, has been working with SQL Server since the mid-90's. Barry works as an independent consultant, trainer and writer and is a popular speaker on Enterprise Data Management at major Conferences. He can be reached at info@barryw.org.

Express Edition

Try SQL Server

Download the beta software

Buy SQL Server