Hi all,

 

I am currently building an eCommerce site for an art gallery that want to sell their items online. I am building the site using PHP and mySQL but have little experience with databases.

 

I was wondering if anyone could tell me how many databases I would likely need.

 

The online shop will sell their whole image catalog, with variations in size and print material. i.e. canvas or paper, A4-A0.

 

Ideally the site will allow user sign-up and login.

 

Does anyone have any experience doing a site like this and have any indication of how many db's I'll need?

 

Thanks in advance,

 

Jay

I would expect one database containing a handful of tables (e.g. "users", "catalogue" and "orders" spring to mind immediately). You'll probably find the number of tables increases as you think more about the database design.

Yeah one database is fine. You will not need more. Just split everything you need off into separate tables as Connetu_C says. You might want to take a look at this website as it provides some great structures for databases based on the site type you are making

http://www.databaseanswers.org/data_models/