microsoft / microsoft/sql-server-samples
Tables CustomerDemographics and CustomerCustomerDemo
Nobody has claimed this yet.
- Dominant language
- PowerShell
- Stars
- 11.2k
- Forks
- 9.1k
- Avg merge
- 2d 7h
- Merged PRs (30d)
- 14
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.
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
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.
Assessment
- Tech stack
- sql
- Domain
- databases
- Issue type
- Documentation
- Difficulty
- 1/5
- Estimated time
- Under an hour
- Activity status
- Quiet
- Clarity
- Needs clarification
- Newbie friendliness
- 35/100