1

I received this from a customer and I was asked to model this as a database.

    Key Article number  color code  description price   action price    delivery    q1  size    color
    2800104 2   pants   Gaastra    8.00     1-3 working days    baby    104 gray
    00000002groe56  2   pants   Gaastra    8.00     1-3 working days    baby    56  green
    00000002groe62  2   pants   Gaastra    8.00     1-3 working days    baby    62  green
    00000002groe68  2   pants   Gaastra    8.00     1-3 working days    baby    68  green
    00000002groe74  2   pants   Gaastra    8.00     1-3 working days    baby    74  green
    00000002groe80  2   pants   Gaastra    8.00     1-3 working days    baby    80  green
    00000002groe86  2   pants   Gaastra    88.00        1-3 working days    baby    86  green

So far I detected a Color entity type, maybe a Category entity type (either q1attribute or Color Code attribute), and a Product entity type with attributes Key, Article Number, Description, Price and Action Price, maybe Delivery as well.

I would like to hear opinions if my analysis is correct or if I am missing something.

2

I have similar data model. It is not exactly as you expect. But surely it will help you to get start.

From the CSV file, the following columns can be derived:

Key         
Article_Number  
Color_Code  
Description 
Price
Action_Price
Delivery
Category
Size
Color

For the above mentioned table, the following model can be designed. Depends on your exact requirement, you may normalize this model or denormalize. Simple Product Data Model

I hope this answer will help you.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.