Free Spirit Software
Free Spirit Software

Database Creation and Maintenance

Windows Desktop Applications

Website Design and Development

Systems Integration

01430 448240

46 Meadow Lane

Newport

Brough

East Yorkshire

HU15 2QN

enquiries@freespiritsoftware.co.uk

Professional Web Development, Windows Development, Database Development and Systems Analysis.


What is a Database


What is a Database As defined by Wikipedia

A database is an organized collection of data.

The data is typically organized to model relevant aspects of reality (for example, the availability of rooms in hotels), in a way that supports processes requiring this information (for example, finding a hotel with vacancies).


Database management systems (DBMSs) are specially designed applications that interact with the user, other applications, and the database itself to capture and analyze data.

A general-purpose database management system (DBMS) is a software system designed to allow the definition, creation, querying, update, and administration of databases.

Well-known DBMSs include MySQL, PostgreSQL, SQLite, Microsoft SQL Server, Microsoft Access, Oracle, Sybase, dBASE, FoxPro, and IBM DB2.


A database is not generally portable across different DBMS, but different DBMSs can inter-operate by using standards such as SQL and ODBC or JDBC to allow a single application to work with more than one database.



As defined by us

A database is a location where information is kept in an accurate and ordered fashion.

This makes the information easy to keep and also easy to report or gather information upon.

Typical items held in a database are:
  • Customer Accounts & Invoice Records
  • Warehouse Stock Information
  • Customer and Supplier Orders
  • Courier Charges ....and much more

Professional Web Development, Windows Development, Database Development and Systems Analysis.


Where a Database Comes In


If you have a lot of information that is kept on spreadsheets by different people and departments then you could likely use a database.

If you find it difficult to get the information that you need to make business decisions or can't easily find such information as stock levels or customer purchase history then you likely need a database.

If you have stacks of paper or manually filed information which takes a long time to find and keep up to date then you likely need a database.

Professional Web Development, Windows Development, Database Development and Systems Analysis.


The Databases We Use


There are numerous database systems in existence but we prefer to work with three main known ones.

What we offer for each of these systems is the design and creation of the database which will hold your information the way you want it to be held.

We ensure that your information is easy to record, easy to access and stays accurate at all times, as well as being backed up and kept safe.







SQL Server

SQL Server is a corporate relational database package which usually sits on a network server.

SQL Server is of greatest use when you wish for multiple users to access the same set of information concurrently.

It is also invaluable when dealing with large sets of data, for instance, keeping records of customers, suppliers, stock items, orders, deliveries, budgets, production planning all of which could add up to around 20,000 records per month or more.

It is robust, secure, versatile and trouble free.



MySQL

MySQL is a database structure package which is useful for enabling you to have a database sat behind your website.

It is free and is often supplied as part of your website hosting package.

The Flags of the Commonwealth quiz that you may have taken on this site makes use of a MySQL database to hold the questions, answers and your success rates.

It also holds your email address and name should you join our mailing list.



Microsoft Access

Access often comes as part of Microsoft Office (Excel, Word, PowerPoint, Access) and offers a simple to use database creation package.

It is very good for smaller amounts of information and can be quickly and easily deployed on several machines.

Professional Web Development, Windows Development, Database Development and Systems Analysis.


Your Guarantee


If you are considering development then the easiest way to understand whether we match your needs is to try us out.

What we offer (as well as full references on request) is a try us and see option.

Get in touch, by email or telephone and lets talk, we'll see what your database needs are and if we feel that we can help then we will carry out a mini proof process.

This process will involve you providing full details of what your requirement is and for us to respond with a mini solution to reassure you that the work we do will be carried out efficiently and correctly.


You really have nothing to lose and everything to gain.

Our development rates are clearly laid out on this site and for agreed work often a fixed rate will be agreed so that you have no surprises with additional fees or escalating costs.

So, call us Today on 01430 448240 for a chat and we can see where we go from there
Free Spirit Software , 46 Meadow Lane, Newport, HU15 2QN, East Yorkshire. 01430448240. 53.760731,-0.704737.