Hi guys, I don't know where place this question... But I'm posting it anyway coz I'm in a real hurry... Well... I'm a doing an inventory system - like application... It functions a little different though... Now I categorize my items as Hardware/Software/References. You get the picture? This is an inventory system for an IT department. I need to design my database as such, if it's
a hardware, I capture the following information...
�Item Description
�Manufacturer
�Model
�Serial No.
�Remarks
�Month / Day Purchased / Acquired
�Year Purchased / Acquired
�Date / Time Created
�Created By
�Date / Time Modified
�Modified By
and if it's software...
�Item Description (required) (ex. Microsoft Visual Studio 2005)
�Publisher (required) (ex. Microsoft, IBM,�, Other publisher)
�Media Type (CD, DVD, Diskette, etc.) (required)
�Quantity (required)
�Remarks (optional)
�Month / Day Purchased / Acquired (optional)
�Year Purchased / Acquired (required)
�Date / Time Created
�Created By
and finally... If it's a reference material...
�Item Description (required) (ex. Oracle DBA Survival Guide)
�Publisher (optional)
�ISBN No. (optional)
�Type (required) (ex. Book, magazine, VCD, DVD, audio tape)
�Remarks (optional)
�Month / Day Purchased / Acquired (optional)
�Year Purchased / Acquired (required)
�Date / Time Created (required)
�Created By (required)
I have the following list of tables so far that relates to my problem...
items_tbl
items_list_tbl
item_type_tbl
departments_tbl
users_tbl
so far... The Hardware, Software and Reference entities are in a single table... I'm thinking if I should have them in separate tables... But that would rathe turn to be hard to maintain... If you need to see the screenshot of my database relationship (in ms access), just tell me... Thanks!