Jump to content

Design of a database for a price list


Go to solution Solved by mac_gyver,

Recommended Posts

Hello everyone,
at the beginning - I'M LEARNING - maybe I'll ask questions wrong - so I'm asking for your understanding.

I need to create a price list - or, in fact, several price lists in one application based on the sheet provided by the boss.

It looks something like this:
one sheet, several dozen workbooks, various table formats.

Could someone guide me on how to design the base to achieve a similar effect?

tabela1.PNG

tabela2.PNG

Link to comment
https://forums.phpfreaks.com/topic/320427-design-of-a-database-for-a-price-list/
Share on other sites

  • Solution

i/we don't understand abbreviations like tpu, pu, n, n 2, r, r 2 that would give meaning to the posted information. can you provide some context, in English, for the two examples you have posted? are these different categories of items?

ultimately,  your task boils down to database normalization. you can search on the web to find out what this means.

to start with, you need an item table that holds the unique information about the items, one row per item. at a minimum, this table would have columns for - id (autoincrement primary index), and name.  this will establish the item ids that will get used when storing data related to the items.

if these various wookbooks are for different categories of items, you also need a category table that holds the unique information about the categories, one row per category. at a minimum, this table would have columns for - id (autoincrement primary index), and name.  this will establish the category ids that will get used when storing data related to the categories. if this is the case, the above item table would also have a category_id column that will hold the corresponding category id for each item.

since i/we don't know if pricing is per category, per item, or per list of items. i.e. what the extent and scope of the data is, i cannot offer any specific suggestions beyond the above.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.