Forums Register Login

Design Question

+Pie Number of slices to send: Send
Sorry that this post isn't really about JDBC, but I have a database design question and we really don't have another forum for that kind of Question. (Don't kill me David).
Setting up an inventory database for Computers. Will be specifying serial numbers, hardware info, HD, RAM, etc. Everything about that PC.
Will also need to track Order info on those PC's.
My question is should I seperate the Order info (PO #, Reference #, Order Date, Cost, etc) from the PC Database into 2 tables and create a link or should the data for both order info and Hardware info be in one table? Or better yet, does it really matter?
+Pie Number of slices to send: Send
Thinking out loud here...
That could depend on the business process you're working on, volume of data, performance required, and so forth.
But thinking on normalization, you could have something like Order -> OrderItem -> Product.
OrderItem would have Order's PK + the item # as its own PK and would have a FK on Product.
Paulo
We cannot change unless we survive, but we will not survive unless we change. Evolving tiny ad:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com


reply
reply
This thread has been viewed 418 times.
Similar Threads
retrieving windows device manager info
how to install Ubuntu and Windows XP in Mac
Device control software with Java?
one or more jms queue?
Stupid Question about Operating Systems
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 28, 2024 09:48:07.