•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the Database Design section within the Web Development category of DaniWeb, a massive community of 375,172 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,096 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Database Design advertiser:
Views: 2608 | Replies: 5
![]() |
•
•
Join Date: Dec 2003
Location: Marin County, CA
Posts: 6,439
Reputation:
Rep Power: 18
Solved Threads: 338
Have you looked in to FileMaker Pro? It's a good balance between ease-of-use and functionality, especially if you aren't heavily in to database development
"May the Wombat of Happiness snuffle through your underbrush."
- Ancient Aborigine blessing
Please do not contact me by email or PM for help. We're all volunteers here, and only have so much free time to dedicate to our efforts.
However, if I've been working on a thread with you already, and seem to have "forgotten" your thread, please do send me a message. I try not to let things slip through the cracks, but it does happen sometimes.
- Ancient Aborigine blessing
Please do not contact me by email or PM for help. We're all volunteers here, and only have so much free time to dedicate to our efforts.
However, if I've been working on a thread with you already, and seem to have "forgotten" your thread, please do send me a message. I try not to let things slip through the cracks, but it does happen sometimes.
It sounds like you're new to the database world, but you may benefit from a data modeling tool to help you conceptualize how the database will operate, and to identify things that could use some normalization. I know some who use Visio for some rudimentary schema design, but Toad Data Modeler is free, powerful, and can target a large number of databases (like Oracle, MySQL, Access, etc).
After you create the diagram of your database, you should choose a database engine to use. If your accustomed to MS Office, then then natural progression would be to use Access. It's just fine for small databases. Another popular database that is also free is MySQL. It might be overkill, however, for something that won't be heavily utilized.
Hope that helps!
After you create the diagram of your database, you should choose a database engine to use. If your accustomed to MS Office, then then natural progression would be to use Access. It's just fine for small databases. Another popular database that is also free is MySQL. It might be overkill, however, for something that won't be heavily utilized.
Hope that helps!
/* You are not expected to understand this */
•
•
Join Date: May 2006
Location: Calpines, California
Posts: 25
Reputation:
Rep Power: 3
Solved Threads: 1
•
•
Join Date: Jan 2008
Location: Riverview, FL
Posts: 2
Reputation:
Rep Power: 0
Solved Threads: 0
Easiest to use: Filemaker, downside: not free
For free, you have several tools available. I'd suggest staying with the "name" brand databases.
Oracle Express
DB2 Express
MySQL
Postgres
MySQL is probably the easiest to get installed and get started with. It will limit you in the long run.
The other three, Oracle, DB2 and Postgres are all comparable in functionality. You'll find minimal third party support for db2 express. Oracle has massive support online but to scale up, should it ever be required, takes a lot money. Postgres is completely free, always. Lot's of third party support.
I'd say choose between Oracle and Postgres. Check with the company to see if they have any on house experience and go that way.
LewisC
For free, you have several tools available. I'd suggest staying with the "name" brand databases.
Oracle Express
DB2 Express
MySQL
Postgres
MySQL is probably the easiest to get installed and get started with. It will limit you in the long run.
The other three, Oracle, DB2 and Postgres are all comparable in functionality. You'll find minimal third party support for db2 express. Oracle has massive support online but to scale up, should it ever be required, takes a lot money. Postgres is completely free, always. Lot's of third party support.
I'd say choose between Oracle and Postgres. Check with the company to see if they have any on house experience and go that way.
LewisC
![]() |
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb Database Design Marketplace
•
•
•
•
ajax asp backup blog business business software creative daniweb database design developer development devices erp systems firefox howto illustrator india internet malware mcafee media microsoft mmorpg msdn news normalization office online open-source photoshop print project management publishing search security server software software selection spyware sql super survey technology evaluation toread tutorials vista web windows
- looking for database software for site. (Database Design)
- Having problems working wth Database software (ASP.NET)
- How to create a database during the runtime in VB6?! (Visual Basic 4 / 5 / 6)
- A database that support multiple mobile platforms (Database Design)
- NEED HELP ON TOPIC : "INTELLECTUAL PROPERTY & HR EXPERTISE DATABASE IN S/W COMPANY" (C)
Other Threads in the Database Design Forum
- Previous Thread: Database design Attendance monitoring and material management
- Next Thread: SQL Queries help



Linear Mode