Skip to content Skip to sidebar Skip to footer
Showing posts with the label Data Modeling
Should These Be 3 Sql Tables Or One?

Should These Be 3 Sql Tables Or One?

Post a Comment
This is a new question which arose out of this question Due to answers, the nature of the question … Read more Should These Be 3 Sql Tables Or One?
Slowly Changing Dimension - What Is Pure Type 6 Implementation

Slowly Changing Dimension - What Is Pure Type 6 Implementation

Post a Comment
I am trying to understand pure type 6 SCD implementation from WIKI which says mainly three points … Read more Slowly Changing Dimension - What Is Pure Type 6 Implementation
Implementing Unique Across Linked Tables In Mysql

Implementing Unique Across Linked Tables In Mysql

Post a Comment
a USER is a PERSON and a PERSON has a COMPANY - user -> person is one-to-one, person -> compa… Read more Implementing Unique Across Linked Tables In Mysql
Database Modelling Remove Bridge Table

Database Modelling Remove Bridge Table

Post a Comment
I have designed a database with some outside help and I am thinking about a major change to the dat… Read more Database Modelling Remove Bridge Table
Do You Like A "lookup" Table In Your Data Models?

Do You Like A "lookup" Table In Your Data Models?

Post a Comment
Do you like a 'Lookup' table in your data models? In designing a new data model, we can eit… Read more Do You Like A "lookup" Table In Your Data Models?
Database Model To Manage Documents

Database Model To Manage Documents

Post a Comment
I need to build a tables related to manage documents such as jpg,doc,msg,pdf using a sql server 200… Read more Database Model To Manage Documents
Generally, Are String (or Varchar) Fields Used As Join Fields?

Generally, Are String (or Varchar) Fields Used As Join Fields?

Post a Comment
We have two tables. The first contains a name (varchar) field. The second contains a field that re… Read more Generally, Are String (or Varchar) Fields Used As Join Fields?
Sql - Should I Use A Junction Table Or Not?

Sql - Should I Use A Junction Table Or Not?

Post a Comment
I am creating a new SQL Server 2008 database. I have two two tables that are related. The first ta… Read more Sql - Should I Use A Junction Table Or Not?