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,435 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

Build a C++ Pipeline with Docker, GitHub Actions, Azure ACR and Azure App Service

By

In today’s Software Development Life Cycle (SDLC), having a robust build pipeline is very...

Better Trigger Design: #SQLNewBlogger

By

I had someone ask me about using triggers to detect changes in their tables....

SQL Server in the Cloud – Are DBAs Still Needed?

By

Things your cloud vendor may not tell you   Here’s a common theme I...

Read the latest Blogs

Forums

Getting year part out of a string that represents a date

By blom0344

Hi, I have a requirement to fetch the year from an imported .csv  file...

Dropping a PK constraint.

By stevec883

I will have to test this next week, but will not have a chance...

SQL - Conditional merge join

By SQL Bee

I want to add a condition in the joining columns part of the merge...

Visit the forum

Question of the Day

What is Between?

I have a table of products in SQL Server 2022. There are sequential items in the table with ProductIDs of 1, 2, 3, 4, 5, 6, 7, 8, 9, 10. If I run this code, how many rows are returned?

SELECT *
FROM dbo.Products
WHERE ProductID
BETWEEN 4 AND 7;

See possible answers