Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary. Once you register for an account you will have immediate access to the forums and all past articles and commentaries.
.net android asp.net asp.net mvc azure backup bigdata book business intelligence c# community continuous delivery database denali excel gotcha how to indexing java mongodb mvc music store nancy nhibernate nosql performance powershell security silverlight sql sql advent 2012 sql friday sql server sql server 2000 sql server 2005 sql server 2008 sql server 2008 r2 sql server 2012 sql server denali ssis ssms ssrs structuremap syndicated t-sql teamcity tip unit testing vb.net visual studio 2010 windows 7
- SQLDenis (597)
- Christiaan Baes (chrissie1) (544)
- Ted Krueger (onpnt) (345)
- Jes Schultz Borland (grrlgeek) (146)
- Eli Weinstock-Herman (tarwn) (130)
- Alex Ullrich (52)
- George Mastros (gmmastros) (46)
- Koen Verbeeck (44)
- Naomi Nosonovsky (27)
- Axel Achten (axel8s) (27)
- David Forck (thirster42) (22)
- chopstik (20)
- Kevin Conan (18)
- Rob Earl (14)
- thatrickguy (12)
Over my years in (and before) IT, I've seen long projects, failed projects, confused projects, wildly successful projects, and even fun projects that ended far differently than we expected. The consistent take-away for me is that I am a big picture type of person, and that understanding that big, abstract picture cuts out a lot of wasted time sprinting down the wrong paths.
There are three types of data models: Conceptual, Logical, and Physical. The conceptual model provides a high-level view of the data, defining the general entities and entity relationships using the language of the business or organization. The logical model adds attributes to these entities, providing a technology-agnostic foundation for a database design. The physical model assigns table names, column names, and data types to the entities and attributes defined in the prior models. Defining the data model in distinct layers helps us manage the complexity of design and focus as we refine our ...