Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

design question

design question

design question

I am currently created a database that keeps track of measurements and notes about each product that this group makes.  I have been asked to expand this database to their other products that are similar to the one that i have created so some fields may be the same.  Since each of their products are similar but vary only by chemcials used and the way they produce the product they would like a database that comes to some sort of title page and from there they can click which products inventory they would like to see.  So what theyre pretty much asking for is to have multiple databases in one file or a title page that could direct them to anyone they want.

Would it be best to make a file that just had references to the seperate databases or should i just create a new table from the same file with no relations being that each database has no relation to one another other than they have
measurements that are the same.

i.e. inner radius and outer radius.

RE: design question

The ever  going question for a multi file or a multi table application....

When I see our (brief) requirements, I would go for a multi table, with a central 'menu' table to direct the user to every single part they need/want.

On the other hand, and I don't know how the structure within the company is, nor how 'big' the datawarehouse will be, it could be interesting to go on the separation road.
Depend how they will use the database.
If it is more research/consultation, I would put all the data in a separate file and the queries in an other, and show the results in portals and reportscreens.

The multi table approach will give you the ease of use of the already existing 'mechanic' parts of the database, like scripts and search. It's a matter of copy/paste with little tweaking.
The multi file will give you the ease of change, where you separate the engine from the data.

Bottom line, it depends from the use of the database.

RE: design question

thanks for the input

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close