Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Design Question

 
Gregg Bolinger
Ranch Hand
Posts: 15304
6
Chrome IntelliJ IDE Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?
 
Paulo Salgado
Ranch Hand
Posts: 98
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic