# Database design

**URL:** <https://forum.kirupa.com/t/database-design/215856>\
**Category:** programming\
**Created:** [February 11, 2007, 12:28pm UTC](https://forum.kirupa.com/t/database-design/215856 "2007-02-11T12:28:28Z")\
**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:** [February 11, 2007, 12:28pm UTC](https://forum.kirupa.com/t/database-design/215856/1 "2007-02-11T12:28:28Z")

</div>

Hello all.

I’m designing a Relational Database for a jewellery designer.

This is what i’ve got so far.

(Sorry no diagrams yet i’m still thinking about the correct way)

cms\_item

```auto

item_id
item_ref
item_materials
item_dscpn
item_image_url

```

cms\_type

```auto

type_id
type_name

```

(entered data for cms\_type)  
1 Necklace  
2 Bracelet  
3 Earring  
4 Ring  
5 Charms  
6 Brooch

cms\_item\_type(joining table for cms \_item and cms\_type)

```auto

item_id
type_id

```

Ok so, so far that makes sense to me.

Now comes a part that i can’t seem to work out with my non logical brain.

I need to put some of the items into sets

So a set might have in it(only one of each item can be included in the set)  
1 necklace  
1 bracelet  
1 earings

What would be the best way to join the sets up in the database?

Would it be adding another field into cms\_items that you add a number into thats unique to the group set.

for example if you have a necklace and its in a set with an earing they would both have a set number say 1

Or would it be having a table that you would have all the items ids in?