January 17, 2007 at 5:27 am
Hi,
Im preparing data model for an intranet app. The database will be SQL Server 2000. The structure revolves on multiple sister concerns(companies) with multiple departments having many employees. Im planning to make the app as dynamic as possible, thus the idea also includes plugging numerous tools within the framework to which these users may or maynot have access or restricted access.
When i map these entities as database tables, i get a model which requires numerous tables that are just mapping the many-to-many relationships, like between usergroups and users, users and tools, and so on. Is it possible for me to map this using a self join table ? Can the multiple relations between these entities along with their association be stored in a single table ? How will it impact the performance of my queries for example, if i need to extract the names and designations of all users in all departments in one company ?
Thanx in advance for reading this and sharing your valuable inputs !
January 17, 2007 at 7:44 am
Meeta
You will probably find it enlightening (and also maybe a bit bemusing) to read this article and the discussion that followed it:
http://www.sqlservercentral.com/columnists/dpeterson/lookuptablemadness.asp
John
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply