Solved

Ecommerce database structure

Posted on 2007-11-28
4
1,328 Views
Last Modified: 2008-09-13
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
0
Comment
Question by:dotinfiniti
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 22

Accepted Solution

by:
dportas earned 125 total points
ID: 20369401
>> 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
 
LVL 18

Assisted Solution

by:Jinesh Kamdar
Jinesh Kamdar earned 125 total points
ID: 20372434
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

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Q&A with Course Creator, Mark Lassoff, on the importance of HTML5 in the career of a modern-day developer.
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question