Hello, thanks for reading my post.
I have included 3 snapshots for the ER diagram and need help ensuring DB integrity and normalization. Your input is very much appreciated, here are the requirements:
There are 3 main entities: COMPANY, PRODUCT and CATEGORY:
� When the user fills in its company profile, he/she chooses to link it with up to 5 different categories, and a category can contain many companies, so there is the many to many relationship (* to *) between the entities COMPANY and CATEGORY.
� The user should be able to add many products linked to his company and one product is linked to only one company so there is the one to many relationship (1 to *) between COMPANY and PRODUCT entities.
� One product can be in many categories and one category can contain many products, so there is the many to many relationship (* to *) between the entities PRODUCT and CATEGORY.
� When the user fills in the product information, he can choose to associate that specific product to 1 up to 3 categories, after submit his company is linked to that product in the selected categories.
The snapshots are self-explanatory and wondering which one is the correct one or close to being right. I have been thinking about this for some time now and can�t figure it out just yet. I would very much appreciate a little push and guidance; this is the backbone of the app and I can�t move forward with the development until this part of the data modeling is designed correctly.
Thanks
I have included 3 snapshots for the ER diagram and need help ensuring DB integrity and normalization. Your input is very much appreciated, here are the requirements:
There are 3 main entities: COMPANY, PRODUCT and CATEGORY:
� When the user fills in its company profile, he/she chooses to link it with up to 5 different categories, and a category can contain many companies, so there is the many to many relationship (* to *) between the entities COMPANY and CATEGORY.
� The user should be able to add many products linked to his company and one product is linked to only one company so there is the one to many relationship (1 to *) between COMPANY and PRODUCT entities.
� One product can be in many categories and one category can contain many products, so there is the many to many relationship (* to *) between the entities PRODUCT and CATEGORY.
� When the user fills in the product information, he can choose to associate that specific product to 1 up to 3 categories, after submit his company is linked to that product in the selected categories.
The snapshots are self-explanatory and wondering which one is the correct one or close to being right. I have been thinking about this for some time now and can�t figure it out just yet. I would very much appreciate a little push and guidance; this is the backbone of the app and I can�t move forward with the development until this part of the data modeling is designed correctly.
Thanks
Comment