Database Design

Does your business need an affordable, yet powerful database? SprightlyMedia specialize in affordable database design for small business to mid-sized business. Our services are available to anyone that requires Database Design. Each Databases comes with a detailed manual, training and technical support.

Database Design can cover many areas for your business. It is an interactive communication between your business and your customers. Your information may be saved in a database for customers to view. Your information may be changing on a regular basis; therefore, by saving this information in a database, your customers will always have the latest information.

A good example of a database application is the Automated Reservation and Appointment System. This system saves all information that customers enter when they make an appointment with you. You can use this information to come up with statistics on your customers, cut down dramatically on time spent on the phone and be able to establish patterns about your customers. Effectively, you are building a foundation of information, which can help you expand your business.

We design databases that can be used for Internet applications via a web browser or in the confines of your office. We generally use one of the following relational databases:

Microsoft SQL Server

SQL Server is a robust database server ideal for larger corporate database applications. Many businesses running Microsoft Small Business Server will have this tool available to them for running office applications, Intranet applications or even their own Internet web site.

Microsoft Access

This relational database tool included with Microsoft Office but can be delivered as a run-time application to your business. It is suitable for the small business where less then 20 staff are using the system at any one time.

MySQL

This relational database is "open source", meaning that it can be used freely. It is best employed as a web based database in conjunction with Apache web servers. It is the database tool we use for our web-hosting packages.

Based on your needs, SprightlyMedia will design and maintain your database. We will review your needs carefully each step of the way.