Post reply

Question about Conceitual Database Model

  • March 23, 2024 at 7:37 pm

    #4400807

    Hi! I am creating a database for an ecommerce and among the entities there are Customer, Shopping Cart, Product, Inventory and Order. A customer adds products to a shopping cart and these products will be part of the order. But the products must be in inventory. What is the appropriate way to relate entities? Do Customer relate to Product too?

    • This topic was modified 8 months ago by  dougsan.

  • March 24, 2024 at 8:10 pm

    #4401200

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • March 24, 2024 at 11:01 pm

    #4401243

    dougsan wrote:

    I am creating a database for an ecommerce...

    Why?  In the long run, it's going to be less expensive and less worrisome to buy one, which will also take into acoount the FIFO nature of the inventory and contention between order for the same inventory, etc, etc.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply