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?
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?