I am having trouble normalizing this spreadsheet I was given into E-R model tables. I will use Access2007 to do this, and it is a personal project, not a homework assignment. I am not a DBA and kindly ask for some assistance/suggestions. I will give the columns in csv format.
CO#(PK?), Model#(Also part of PK?), caseQuantity(Number), caseOnline(Date), casePartShortage(varChar),caseOut(Date) Comments(varChar), hardwareQuantity(Number), hardwareOnline(Date), hardwarePartShortage(varChar), hardwareOut(Date), Comments
I don't know if I have to make three seperate tables, or two tables, I am not really sure. I am asking for a suggestions as to how to normalize the given columns I have above into two or more tables and how to normalize. I am sorry if this seems like a trivial matter.
9n is just a combination of 9 variable characters, a mixture of text and numbers, it can be the primary key I'm assuming. If more info is needed, please let me know. I don't really know what other information I can provide.