Database modelling

SQLServerCentral Article

Database Modeling - Relationships

  • Article

A proper relationship between two people, places or things improves the communication between them. In every real-world based application, this logic holds and a database is no different. This article discusses the different relationship types possible between database objects. The designing of these relationships between them is called modeling, and the three types of relationships […]

5 (3)

You rated this post out of 5. Change rating

2020-08-31

7,437 reads

External Article

Five Online Database Modelling Services

  • Article

To design, or redesign, a database of any complexity, the Entity-Relationship modelling tool becomes essential. The specialized tools that have dominated the industry for a long while are expensive and are installed on a workstation. Now that browser technology has progressed so rapidly, the online database modelling tools have become viable and are starting to attract the attention of database designers. Are they good enough to use now? Robert Sheldon finds out.

2016-03-11

4,547 reads

Blogs

Speaking at the 2025 PASS Data Community Summit

By

I will be back in Seattle this year attending the 2025 PASS Data Community...

The Book of Redgate: Motivation

By

Another of our values is this: Motivation isn’t about carrots and sticks. Constant oversight...

A Six Week Break

By

Today is my last day of work for six weeks. I start my sabbatical...

Read the latest Blogs

Forums

Three Times a Day

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Three Times a Day

SUM([value]) and highest record type

By Pete Bishop

Given a record mapping table: Id Initial Updated 1 1 2 2 3 4...

should i expect data types in task->export data from ssms?

By stan

Hi i recently exported a number of "to be purged resultsets " to .tsv's. ...

Visit the forum

Question of the Day

Multiple Defaults

In my SQL Server 2022 database, I run this code:

ALTER TABLE dbo.OrderHeader 
ADD ModifiedStamp DATETIME CONSTRAINT df_Created_Getdate DEFAULT GETDATE()
GO
I decide I need to add auditing to another table and run this:
ALTER TABLE dbo.Tracker
ADD Created DATETIME CONSTRAINT df_Created_Getdate DEFAULT GETDATE()
GO
What happens with these statements?

See possible answers