Databases > pubs > Tables > titles

pubs

titles

Created: Modified:

Columns

  • title_id
    [tid] NOT NULL
    //
    USER-DEFINED DATA TYPE
    [varchar](6) NOT NULL
  • title
    [varchar](80) NOT NULL
  • type
    [char](12) NOT NULL DEFAULT ('UNDECIDED')
  • pub_id
    [char](4) NULL
  • price
    [money] NULL
  • advance
    [money] NULL
  • royalty
    [int] NULL
  • ytd_sales
    [int] NULL
  • notes
    [varchar](200) NULL
  • pubdate
    [datetime] NOT NULL DEFAULT (getdate())

Indexes

  • UPKCL_titleidind
    UNIQUE CLUSTERED
    title_id
  • titleind
    NONCLUSTERED
    title

Foreign Keys

  • FK__titles__pub_id__2E1BDC42
    publishers
    pub_id ⥱ pub_id

Sample Data

title_id
title
type
pub_id
price
advance
royalty
ytd_sales
notes
pubdate
BU1032
The Busy Executive's Database Guide
business
1389
19.99
5000
10
4095
An overview of available database systems with emphasis on common business applications. Illustrated.
BU1111
Cooking with Computers: Surreptitious Balance Sheets
business
1389
11.95
5000
10
3876
Helpful hints on how to use your electronic resources to the best advantage.
BU2075
You Can Combat Computer Stress!
business
0736
2.99
10125
24
18722
The latest medical and psychological techniques for living with the electronic office. Easy-to-understand explanations.
BU7832
Straight Talk About Computers
business
1389
19.99
5000
10
4095
Annotated analysis of what computers can do for you: a no-hype guide for the critical user.
MC2222
Silicon Valley Gastronomic Treats
mod_cook
0877
19.99
NULL
12
2032
Favorite recipes for quick, easy, and elegant meals.
MC3021
The Gourmet Microwave
mod_cook
0877
2.99
15000
24
22246
Traditional French gourmet recipes adapted for modern microwave cooking.
MC3026
The Psychology of Computer Cooking
UNDECIDED
0877
NULL
NULL
NULL
NULL
NULL
PC1035
But Is It User Friendly?
popular_comp
1389
22.95
7000
16
8780
A survey of software for the naive user, focusing on the 'friendliness' of each.
PC8888
Secrets of Silicon Valley
popular_comp
1389
20
8000
10
4095
Muckraking reporting on the world's largest computer hardware and software manufacturers.
PC9999
Net Etiquette
popular_comp
1389
NULL
NULL
NULL
NULL
A must-read for computer conferencing.
PS1372
Computer Phobic AND Non-Phobic Individuals: Behavior Variations
psychology
0877
21.59
7000
10
375
A must for the specialist, this book examines the difference between those who hate and fear computers and those who don't.
PS2091
Is Anger the Enemy?
psychology
0736
10.95
2275
12
2045
Carefully researched study of the effects of strong emotions on the body. Metabolic charts included.
PS2106
Life Without Fear
psychology
0736
7
6000
10
111
New exercise, meditation, and nutritional techniques that can reduce the shock of daily interactions. Popular audience. Sample menus included, exercise video available separately.
PS3333
Prolonged Data Deprivation: Four Case Studies
psychology
0736
19.99
2000
10
4072
What happens when the data runs dry? Searching evaluations of information-shortage effects.
PS7777
Emotional Security: A New Algorithm
psychology
0736
7.99
4000
10
3336
Protecting yourself and your loved ones from undue emotional stress in the modern world. Use of computer and nutritional aids emphasized.
TC3218
Onions, Leeks, and Garlic: Cooking Secrets of the Mediterranean
trad_cook
0877
20.95
7000
10
375
Profusely illustrated in color, this makes a wonderful gift book for a cuisine-oriented friend.
TC4203
Fifty Years in Buckingham Palace Kitchens
trad_cook
0877
11.95
4000
14
15096
More anecdotes from the Queen's favorite cook describing life among English royalty. Recipes, techniques, tender vignettes.
TC7777
Sushi, Anyone?
trad_cook
0877
14.99
8000
10
4095
Detailed instructions on how to make authentic Japanese sushi in your spare time.