# Database design (Advice)

**URL:** <https://forum.kirupa.com/t/database-design-advice/221435>\
**Category:** Uncategorized\
**Created:** [April 4, 2007, 10:37am UTC](https://forum.kirupa.com/t/database-design-advice/221435 "2007-04-04T10:37:22Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [April 4, 2007, 10:37am UTC](https://forum.kirupa.com/t/database-design-advice/221435/1 "2007-04-04T10:37:22Z")

</div>

Hello all

I was wondering if any of you great people could help me with my database design.

link to image below  
[http://www.our-atelier.co.uk/uploads/database\_design.jpg](http://www.our-atelier.co.uk/uploads/database_design.jpg)

All advice would be greatly accepted as i’m still a complete novice at this.

points to remember

1. each item can have more then one upholstery choice  
2 each item can belong to more then one product listing (eg a item can be a table and a chair)

2. each item can have more then one frame option ( note each frame can have different colour options confused on this so advice on that would be great)

Hope this makes sense.

Thanks in advance.

🙂