Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  General SQL Server Forums  Database Design and Application Architecture  Database ERD and ORM Modeling Help (Check my work?

Author  Topic  nnate72 Starting Member 1 Post Posted - 2010-08-07 : 00:12:41 Hi all, I am fairly new to database relationships and entity mapping (I am writing an MVC application that I'd like to use a SQL Server 2008 DB for the model). The easiest way for me to organize my thoughts is through an ERD, if you know the diagram symbols, I'd really appreciate your help with designing my models. Again, I'm new to this and will lay out my thought process. My application is one for Greek Fraternities and Sororities. There are many GreekEntities(National) that have A Name A Website Many Chapters who EACH have A Name A Website A school that they are at who EACH have A Name Location Info Location Info Many Users who EACH have A Username password name profile picture last login date user type member OR pledge OR officer OR admin A list of 'Preferences' (Yet to be decided) A list of parameters based on the Chapter's Subscriptions Location Information AND Permanent Location Info Each set of location info consists of: Address Line 1 and 2 City, State/Province GeoCoordinates A Chapter may or may not have a chapterhouse. If a Chapter isn't subscribed to a service, the user will not have any parameters for that service. The diagram doesn't yet have all of the parameters for each subscription. Is there any way to add this sort of logic? Should I change my model? Please help. Thanks for all the help! I really, really appreciate anything you all can do to help my model. --NATE diagram at: http://www.n-access.com/dbdiagram1.jpg