This content has been marked as final. Show 2 replies
Will admit I am a bit confused at what you are asking for, if you require a template logical model which provides a thorough list of entities and attributes for various industries I highly recommend referencing the following books:
The Data Model Resource Book: A Library of Universal Data Models for All Enterprises: Vol 1 and Vol 2
From what I can see you will only need to reference Vol 1.
You can purchase them from Amazon.
Hope that helps.
Thanks for your reply Yusef.
I am actually creating an ERD for authenticating the user when he logs into the database. So I will need a set of tables to identify if user exis and password is correct.
After this some tables will exist for checking his department, his group. On the basis of his group he will be able to access only relevant parts of application. Its like a role or a privelege thing.
Please tell me if the database tables that I have identified are correct ? Please ask questions so I may get to the best solution please.