Uncategorised

Details
Category: Uncategorised
Hits: 4115

Database tables are similar to the sorts of tables you'll find in books, such as this:

CustomerID Name Address Email
1 Smith Ltd Manston, Yorkshire This email address is being protected from spambots. You need JavaScript enabled to view it.
2 Wigglesworth Ltd Leeds, Yorkshire This email address is being protected from spambots. You need JavaScript enabled to view it.
3 William J Seymour Azusa Street, LA, USA This email address is being protected from spambots. You need JavaScript enabled to view it.

This shows you both the table design, ie what columns it has in it, and table data.

When a database table is being designed, we would not normally expect specific data to be in it- users like to have their own data in their database! There are exceptions, such as internal-use-only data, such as some accounting codes, but they are notable by their rarity.

So, what makes for a good table design?

1. The right fields.

This might sound trivial, but making sure that your "Customers" table doesn't have details of specific orders means that your customers won't be restricted to just one order each! Similarly making sure that the customer's address is part of the Customers table and not the "Products" table would also be good!

2. The right indexes.

An index to a table is a bit like an index in a book- it allows you to find things quickly. Tables should normally have what is called a "Primary Key"- this is an index that should be unique so that no two records have the same value, so that they can be found quickly, such as by using the CustomerID. Tables can also have a large number of "Secondary Indexes" that also allow data rows (called "records") to be found quickly, such as finding all the customers with a particular surname, but normally they have less than 3.

3. The right help.

DBDesigner supports the entry of help fields as the table is being designed so that the finished program can show the user a hint if he puts the mouse cursor over a field or table.

This email address is being protected from spambots. You need JavaScript enabled to view it. on 0115 840 5500 to learn more.

Details
Category: Uncategorised
Hits: 3876

 

 

 

This web site is operated by Data Technologies Ltd to illustrate what DBDesigner can do- you can find pricing details on their site.

This email address is being protected from spambots. You need JavaScript enabled to view it. on 0115 840 5500 to learn more.

 
 

Details
Category: Uncategorised
Hits: 4211

DBDesigner was written by Data Technologies Ltd who can be contacted using these details:

Gothic House
Barker Gate
Nottingham
NG1 1JU

This email address is being protected from spambots. You need JavaScript enabled to view it. or call 0115 840 5500 to learn more.

Details
Category: Uncategorised
Hits: 4157

DBDesigner is the fastest and cheapest way to obtain bespoke business database software. See the "Making Robots..." article for an explanation.

Here are some of the core benefits of using it-
  • You can have a draft version of your software to try with in a matter of hours (or minutes for trivial applications).
  • Reduce the hours of work needed for your application by up to 70%, reducing costs.
  • Get consistent applications, with one look and feel.
  • Your design can be easily modified as we understand your needs better.
  • You can be sure you are buying what you need before you part with any money.
  • You can check the software works for your business before you spend any money.
  • You get code that is virtually bug-free.
  • You get code that runs quickly, having been extensively checked for high performance.

If you are into stories, we have expressed these advantages in Making Robots... and Shipbuilding.

DBDesigner can create code so fast that you minimise your risks. You don't need to risk a large sum of money, you don't need to risk a lengthy wait, and you don't need to risk anything like as much management time before you have a usable system. You really do need to This email address is being protected from spambots. You need JavaScript enabled to view it. on 0115 840 5500 to learn more.

  • You are here:  
  • Home
  • Uncategorised