Datamodel Templates

If you are developing Data models for your organization, You can refer to readily available data models presented in database answers site. 900+ datamodels. Covers real time scenarios.

Another good read, Using SSMS for Data Modelling

Couple of Interesting Data Models 

• Shoppers Recommendations
• Retail management
• Data Model for Airline Reservations 
• Data Model for Product Catalogs
• Order Tracking

Happy Learning!!

Database Development Model

Back to basics


We have three phases involved in Database Application Development

• Conceptual Data Model- Identifying Entities-Attributes, Outcode of this Phase ER Diagram, Identify Relationships
• Logical Phase - Normalize, Identify Rules, Map ER Diagram to Tables
• Physical Data Model - Tables, Constraints, Triggers, Relationships

For Physical Database Design the following are in scope - High Availability, Paritioning Strategy, Archival and Audting

Database Design Methodologies for Microsoft SQL Server
The phases of database design
Jim Gray - A talk with THE SQL Guru and Architect
Jim Gray - Part II of talking about Database Design
Database Design Process
Data Design
Advanced Performance Tuning – 1 :: Importance of data-types
Advanced Performance Tuning – 2 :: Which side of the operator
Advanced Performance Tuning – 3 :: Designing for better performance
Advanced Performance Tuning – 4 :: Designing for better performance contd…



Happy Learning!!!