Training database PUBS

Question

Dear friends,
I'm looking for a description of the tables and fields of the Pubs training database. Can you help me please?
Thank you very much,
Anna

Answer 1

Hi,

The pubs database is a sample of a publishing company, which includes books, authors, sales and stores.

It includes the tables: authors,publishers,titles,titleauthor,stores,sales,roysched,discounts,jobs,pub_info,employee

here you can see the diagram of the database:

For more information you can simply go over the scrip which create the database and all it's entities:
https://github.com/microsoft/sql-server-samples/blob/master/samples/databases/northwind-pubs/instpubs.sql

Answer 2

Hi @BIVS Databaze ,

Welcome to Microsoft Q&A!

After researched, there doesn't have much information about the tables and fields of the Pubs database in English. However, I found a documents about Pubs database analysis for SQL Server 2000. But the document is write by Chinese, I have translated for the first part(the blue part). You could use Google translation if the document are useful.

And the Entity Relationship Diagram of Pubs Database as below:

95135-pubs-database.pdf

Best regards,
Carrin

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 3

This is a script to create & populate the database Pubs.

https://github.com/microsoft/sql-server-samples/blob/master/samples/databases/northwind-pubs/instpubs.sql