Hey guys and gals,

I am currently working on a project that requires me to create schemas based on a website. First external, then conceptual, then internal.

The thing I am confused about is I am making external schemas for every page and then making a conceptual schema based off of it. The thing is there are duplicate exteral schemas.

One page allows users to add a comment for a product, one allows them to view their own comments they made, and one allows them to view everyone's comments for a certain product.

When creating the conceptual schema do all these duplicate tables get added separately or do they get merged into one?

Thanks for the help.