State of The Art CMS System - Hosted In-house.
Database Design
Computer Division now can help automate your small office with a database. We have built many different types from Recruitment systems to Qualification Systems, from single user to 20 users. We now are embarking on web based systems that allow many hundreds of people to access and use the systems.
Database - Relational database
Database refers to a file that is used to store information in a format that is easily retrieved and manipulated.
The most common database files are made up of tables, fields and records. These are referred to as a relational database.
Relational Database
Let's look at the components of a relational database file:
A field is a single piece of data.
A Record is a collection of fields.
A Table is a collection of records.
A File is the database in its entirety, ie all tables, records and fields.
A simple example of this type of database would be a bookshop's stock system which used 1 table.
The table will include a record for each book, the record may be split into five fields, title, author, genre, isbn and stock status.
With the data organised in this way it makes it easier to locate any one piece of information, for instance you could search the author fields of all records to find all books by your favourite author and at the same time see which books were in stock.
So how could a simple field, record, table and file help you?
Very simply, your documents you deal with in a day to day basis could be stored , your work flow or the things you do systematically could be kept working in proper procedure, thats before we hit the British Standards (ISO 9000 ring a bell?).
How about a simple document control system, ever thrown away a dispatch note ? Then wished you had it when stock went missing? Well with a scanned record in table it would be there even if you dispose of the paperwork.
Why not put in place a full blown system that help you and your company work more efficiently.
