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 Express, which you can download here.
Recommended Training Video:
A webcast tutorial is available for beginners titled Understanding a Database Schema. Download 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.
Select your starting point below
Database Schema 1: Assets Maintenance
Database Schema 2: Contact Management
Database Schema 3: Customers and Orders
Database Schema 4: Document Management
Database Schema 5: e-Commerce
Database Schema 6: Help Desk
Database Schema 7: Issue Tracking Software
Database Schema 8: Retail Inventory Control
Database Schema 9: Not for Profits
Database Schema 10: Product Catalogs
Database Schema 1: Assets Maintenance
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.
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.
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.)
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.
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.
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.
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.
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.
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.
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.
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.
.gif)
Database Schema 1: Assets Maintenance
