question

BIVSDatabaze-5379 avatar image
0 Votes"
BIVSDatabaze-5379 asked CarrinWu-MSFT commented

Training database PUBS

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

sql-server-generalsql-server-transact-sql
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @BIVSDatabaze-5379, we have not get a reply from you. Did any answers could help you? If there has an answer helped, please do "Accept Answer". If not, please let us know. By doing so, it will benefit for community members who have this similar issue. Your contribution is highly appreciated. Thank you!

0 Votes 0 ·
pituach avatar image
0 Votes"
pituach answered

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:
95055-image.png

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



image.png (29.4 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

CarrinWu-MSFT avatar image
0 Votes"
CarrinWu-MSFT answered CarrinWu-MSFT edited

Hi @BIVSDatabaze-5379,

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:
95134-pubs.png

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.



pubs.png (99.8 KiB)
pubs-database.pdf (258.4 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.