DocuMagic Incorporated

 

Database Design


Why use a database?

A well designed database allows the user to easily enter information while providing convenient and user-friendly tools for performing the necessary lookups and generating reports that will reflect the database contents in a usable format. Also, data can be exported from the database to other platforms making the information accessible to anyone who needs it.

A flexible database is the key to effective data storage and management. Whether it is a small database for list compilation or merges, or a large-scale data management system, having the right database design for the project will make all the difference.

What are some examples of databases?

Automation - pulling together data from a variety of sources allowing for reporting and analysis.

Contact Management - allows you to keep track of your contacts and the communication you had with them. The Database can be customized to allow for pop up reminders, ie contacting clients on a specific date.

Inventory tracking - allows you to track inventory on hand, when to order more stock, pricing and much more.

Marketing - allows you to track your clients, what you have sold them in the past, price quotations, what date they need certain products, keep details of meetings and conversations etc.

What is a relational database?

Relational databases provide the power and flexibility to incorporate and easily maintain any amount of data. Queries, stored procedures, data entry forms, and reports can be fashioned once the structure of the database has been created.

A relational database allows the data to be organized efficiently so that you access only needed information. This in turn makes your database smaller and more efficient.

What will DocuMagic provide?

DocuMagic Inc. will discuss your database goals extensively with you prior to performing any development. To ensure that the database will achieve the desired level of performance and still have room to grow, an effective design must be implemented prior to the actual development of the database itself.

Depending on the goals of the database design, it can be created in Microsoft Access or Microsoft SQL depending on how extensive the client's needs are.

 

Valid XHTML 1.0 Transitional