Computer Store Database Design

[weemien23]

Hi,

I want to build a online shop that sells computer and also sells other products in the future aswell.
I'm having trouble designing the database. At this moment I have productCategory and product as tables. But every product has is own dataspecification eg printer and cpu. A cpu have speed, fsb, cache..ect while a printer doesn't need all that.
Must I create a table for every different category or is there a better way of modeling this??
Any comments is appreciated.
Thanks in advance...

WM

 

[JeremyNYC]

WM,

Is this for a class?

JW

---
Jeremy Wallace
METRIX Project Coordinator
Fund for the City of New York

 

[weemien23]

No,

This is for a MySQL database. I need some tips about this isue

WM

 

[markphsd]

Weemien23

You are in the wrong forum. You'll have a hard time getting answers in here for that.

Check out the MySQL forum and the Microsoft Access tables and relationships forum.

Also, Do searches for Relational Database Design.

Mark P.

http://www.cafecartel.com

Providing Low Cost Powerful Point of Sale Solutions.

 

[JeremyNYC]

Yeah, definitely head over there for specifics. For general stuff on how to build a relational database, check out the article hosted on my old website at

http://www.abcdataworks.com,

in the Developers' section there's an article on database design.

But if you're really going to be running a store based on this database, and you're asking questions that are this basic, I would say that you'd be best off paying a consultant to do this work.

Jeremy

PS: I'm no longer a consultant, and am not, in any case, qualified to do this in MySql, so no, I'm not fishing for work.

---
Jeremy Wallace
METRIX Project Coordinator
Fund for the City of New York