DB Design Thoughts??

Hi,

I'm in the process of designing a DB (typical management system DB; 2
transaction tables and about 5 look-up ones )for one of the departments
in our company. The user wants this DB and thusly the client (forms,
reports..etc.) solely for his department. However, I do expect soon
after deployment that other users want similar DBs and clients,
therefore, facing problem of integrating such DBs, if company
management wants to implement it as enterprise DB. My question (may be
you could also tell me about other groups specialized in these kind of
issues), how should I create such DB? Should I create extra look-up
table for departments and have each one with its own ID and link it to
the main transaction one

MTIA,
Grawsha