how to modify database template?

[mgtuba]

Hello,

If I find an existing database that I can use for my inventory project, for example like microsoft's website. What is the best way to make changes to the template with tables, and still keeping the structure and design free from naming errors and what not? Does this have something to do with cascading changes and referential integrity?

Thanks.