Tables CustomerDemographics and CustomerCustomerDemo

Open
#1,497 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Assessment

Difficulty
1/5
Estimated time
Under an hour
Newbie friendliness
35/100
Issue type
Documentation
Clarity
Needs clarification
Activity status
Quiet
Tech stack
sql
Domain
databases

Research direction

Start by reading the CustomerCustomerDemo and CustomerDemographics definitions and related inserts in instnwnd.sql. Trace their keys and relationships to the customer data, then document their purpose, context in Northwind, and why the script leaves them unpopulated.

Written by the indexing model from the issue text.

Description

Hello dears,

I am working on a study project—specifically a REST API—and using the Northwind model to illustrate the concepts.
I would like to understand the CustomerCustomerDemo and CustomerDemographics tables—specifically their purpose and context within the database. After running the instnwnd.sql script (from https://github.com/microsoft/sql-server-samples/blob/master/samples/databases/northwind-pubs/instnwnd.sql) on my database, I noticed these tables remained unpopulated; I simply want to know what they are for and how they are used.

If you could help, as only this detail is missing to complete the project.

Dominant language
PowerShell
Stars
11.2k
Forks
9.1k
Avg merge
2d 7h
Merged PRs (30d)
14

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

More from microsoft/sql-server-samples

All issues in microsoft/sql-server-samples

Similar issues

More Databases issues

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.