How to draw ERD of these tables?

[mukeshrasm]

Hi

I want to draw ERD of following tables:

ProductCategory Table:
Fields:Category ID, CategoryName, Category Description


ProductSubcateg ory Table:
Fields: CategoryID, SubcategoryID, SubcategoryName , SubcategoryDesc ription.

Merchant Table:
Fields: MerchantID, MerchantName, MerchantLogo.

ProductCategory has ProductSubcateg ory.

A ProductCategory has one or many Merchants
ProductSubcateg ory has one or many Merchants
Merchants has one or many ProductCategory
Merchants has one or many SubProductCateg ory.

How will I design the ERD of the Following Description.

[ronverdonk]

Since these are relatively small number of entities, it is easy to draw them yourself.

When you are looking for a program (free or paid) to make such a design, see the wikipedia which lists all kinds of software here Wikipedia ERD

Ronald

[mukeshrasm]

Since these are relatively small number of entities, it is easy to draw them yourself.

When you are looking for a program (free or paid) to make such a design, see the wikipedia which lists all kinds of software here Wikipedia ERD

Ronald

It's ok but if you can do it for me means if you can draw the diagram then it will better form me to understand and further If I find any problem I can ask you.

so please help meeeee

[ronverdonk]

In this forum we do not make code, documents or otherwise for members who have not even tried to do it themselves.

We will help you when you yourself make the effort first. When, during that process, you run into problems or have questions about what you made, we will help.

The link I posted will give you enough information to start.

Ronald