Categories: MSDN / DotNet / Java / Scripts / Linux / PHP Ask - La ask - La Answer

Where to start? Small Business DB

I am fairly new to databases and need some advice in starting one for a small business. I would love to use open office "base" (much like access) as my development platform, because I sort of dread using access. I have tried the wizards for creating a single table and some fields seem appropriate, but I need more than they offer. I also have no clue if I should make two or more tables, how to join them or anything like that. The database will be for a small auto repair shop that I am currently running. My customer base is rapidly growing and it would be great to keep track of work done, schedule mainteneces, customer contact info etc.
any advice is greatly appreciated.
[681 byte] By [myke_w] at [2007-11-11 7:34:27]
# 1 Re: Where to start? Small Business DB
Yes, Open Office will work. Version 2.0 uses HSQL as its db. HSQL is a pure Java db. You can also connect to other dbs.

The problem is what you are asking really requires professional help. You will need to do some analysis and design to determine the proper database structure. It has nothing to do with the database/tool you are using. You may need to move to another tool for the frontend. Again, that takes some analysis and design.
mnuttall at 2007-11-11 23:47:50 >