Results 1 to 5 of 5

Thread: Retail Shop DB

  1. #1
    Join Date
    Feb 2004
    Posts
    9

    Unhappy Unanswered: Retail Shop DB

    Please can some body help me in designing a retail shop database, I am absolutely stuck. ANy ideas or examples will be so helpful many thanks

  2. #2
    Join Date
    Nov 2002
    Location
    Belgium
    Posts
    243

    Re: Retail Shop DB

    Originally posted by Shan007
    Please can some body help me in designing a retail shop database, I am absolutely stuck. ANy ideas or examples will be so helpful many thanks
    Can you be more specific:
    What's the meaning of it all?
    Do already have a start?
    Are there some errors?

    If you will give more details I will try to give you a helping hand.

  3. #3
    Join Date
    Jan 2004
    Posts
    492

    Re: Retail Shop DB

    Originally posted by artemide
    Can you be more specific:
    What's the meaning of it all?
    Do already have a start?
    Are there some errors?

    If you will give more details I will try to give you a helping hand.

    You must have some idea of what you want...

    I assume you will need several tables which have:

    customers - Would contain all of your customer info
    products - Would contain all of your product info
    transactions - Would be the intersection table containing transaction info (customer and product id's as keys)

    Those are the base tables you could not be without - You will most likely want some more tables. As the previous post stated you need to come up with some ideas b/c no one is going to build it for you.

  4. #4
    Join Date
    Jun 2003
    Location
    USA
    Posts
    1,032
    The free downloadable sample invoices database at www.bullschmidt.com/access hopefully might give you some ideas...
    J. Paul Schmidt, Freelance Web and Database Developer
    www.Bullschmidt.com
    Access Database Sample, Web Database Sample, ASP Design Tips

  5. #5
    Join Date
    Feb 2004
    Posts
    9

    Re: Retail Shop DB

    Originally posted by artemide
    Can you be more specific:
    What's the meaning of it all?
    Do already have a start?
    Are there some errors?

    If you will give more details I will try to give you a helping hand.
    Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •