Ecommerce database structure

I am building an online gift shop and need help deciding how to relate the shopping cart table to the orders table without alitteration.
Customers are not required to log in in order to add items to the shopping baske, but are required to log in or create an account in order to checkout.
here is the information:

ORDERS
-----------
orderid
customerid
orderitems
subtotal
shipmethod
shipcosts
ordertotal
orderdate
ordertrackingNo

SHOPPINGCART
------------------
cartid
customerid
product
quantity

Any suggestions on improvement would be greatly appreciated.

Thanks in advance
dotinfinitiAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
dportasConnect With a Mentor Commented:
>> dotinfiniti: I am building an online gift shop
Obvious question: Why? There is an enormous number of pre-packaged solutions available to meet most requirements.

If you want to do this properly then I suggest you seek out the services of an experienced database designer. It's impossible for us to know your requirements just based on two lists of attributes.
0
 
Jinesh KamdarConnect With a Mentor Commented:
I think the logical thing would be store the basket items in the SHOPPINGCART table until the user selects to check-out (not sure how to and if u want to keep the cart persistent thru multiple sessions). Once the user logs in and finalises the order, move the items to the ORDERS and ORDERLINES tables, which would hold the order details and delete them from the SHOPPINGCART table.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.