Ok, here I have a database called mysoftware with 6 tables which I am going to set up like this, does this look correct. I'm no real newbie but I'm kind of new to getting it right.

Seems a little bit like overkill for me but I'm not sure, I'm here to learn so commence with the teaching.


TABLE SOFTWARE

| s_id
| s_category_id
| s_subcategory_id
| s_media_id
| s_reg_id

--------------------------------

TABLE CATEGORY

| s_id
| s_category_id
| s_category

---------------------------------

TABLE SUBCATEGORY

| s_id
| s_subcategory_id
| s_subcategory

--------------------------------

TABLE DESCRIPTION

| s_description_id
| s_description
| s_title

--------------------------------

TABLE MEDIA

| s_id
| s_media_id
| s_media_name
| s_media_filesize

---------------------------------

TABLE REGISTRATION

| s_id
| s_reg_num

---------------------------------

-Mark