I'm creating an ASP.NET website for selling furniture and I am confused about creating my database

335 Views Asked by At

My Asp template

I'm creating my first ASP.NET website for selling furniture and I am confused about creating my database. I want to sell products for many categories like bedrooms, and every user can add products to cart; here is my master page template

1

There are 1 best solutions below

0
Siyavash Hamdi On

I introduce you a simple database design for the issue using 4 proposed tables in the following:

  1. Persons; to keep your users info in it.
  2. ProductCategories; to keep the product groups in it as mentioned like bedroom.
  3. Products; to keep the all products with their categories.
  4. Carts; actually this is not mandatory, you can manage this by cookies.

Note: This proposal is very very basic and simple, so it can be extended by your needs.


Here is the mentioned tables with their fields(in the minimum) as graphical interface in the Microsoft SQL Server design: Proposed furniture database, very simple design.