The titles table stores information about books put out by bookbiz publishers. There are 18 books. The title_id, type and pub_id columns are fixed-length character datatype. The title and notes columns are variable-length datatype. The price and advance columns hold money values (decimal datatypes for systems that do not support a currency datatype). There is a unique index on title_id and a nonunique one on title.
title_id not null titleidind | Title not null titleind | type null | pub_id null | price null | advance null | ytd_sales null | contract not null | notes null | pubdate null |
========== | =========== | ============ | ====== | ====== | ======== | ========= | ======== | =============== | ======= |
PC1035 | But Is It User Friendly? | popular_comp | 1389 | 42.95 | 7000.00 | 8780 | 1 | A survey of software for the naive user, focusing on the 'friendliness' of each. | Jun 30 1998 12:00 am |
BU1032 | The Busy Executive's Database Guide | business | 1389 | 29.99 | 5000.00 | 4095 | 1 | An overview of available database systems with emphasis on common business applications. Illustrated. | Jun 12 1998 12:00 am |
BU1111 | Cooking with Computers: Surreptitious Balance Sheets | business | 1389 | 21.95 | 5000.00 | 3876 | 1 | Helpful hints on how to use your electronic resources to the best advantage. | Jun 09 1998 12:00 am |
BU2075 | You Can Combat Computer Stress! | business | 0736 | 12.99 | 10125.00 | 18722 | 1 | The latest medical and psychological techniques for living with the electronic office. Easy-to-understand explanations. | Jun 30 1998 12:00 am |
BU7832 | Straight Talk About Computers | business | 1389 | 29.99 | 5000.00 | 4095 | 1 | Annotated analysis of what computers can do for you: a no-hype guide for the critical user. | Jun 22 1998 12:00 am |
MC2222 | Silicon Valley Gastronomic Treats | mod_cook | 0877 | 29.99 | 0.00 | 2032 | 1 | Favorite recipes for quick, easy, and elegant meals tried and tested by people who never have time to eat, let alone cook. | Jun 09 1998 12:00 am |
MC3021 | The Gourmet Microwave | mod_cook | 0877 | 12.99 | 15000.00 | 22246 | 1 | Traditional French gourmet recipes adapted for modern microwave cooking. | Jun 18 1998 12:00 am |
MC3026 | The Psychology of Computer Cooking | (NULL) | 0877 | (NULL) | (NULL) | (NULL) | 0 | (NULL) | (NULL) |
PC1035 | But Is It User Friendly? | popular_comp | 1389 | 42.95 | 7000.00 | 8780 | 1 | A survey of software for the naive user, focusing on the 'friendliness' of each. | Jun 30 1998 12:00 am |
PC8888 | Secrets of Silicon Valley | popular_comp | 1389 | 40.00 | 8000.00 | 4095 | 1 | Muckraking reporting on the world's largest computer hardware and software manufacturers. | Jun 12 1998 12:00 am |
PC9999 | Net Etiquette | popular_comp | 1389 | (NULL) | (NULL) | (NULL) | 0 | A must-read for computer conferencing debutantes! | (NULL) |
PS1372 | Computer Phobic and Non-Phobic Individuals: Behavior Variations | psychology | 0736 | 41.59 | 7000.00 | 375 | 1 | A must for the specialist, this book examines the difference between those who hate and fear computers and those who think they are swell. | Oct 21 1998 12:00 am |
PS2091 | Is Anger the Enemy? | psychology | 0736 | 21.95 | 2275.00 | 2045 | 1 | Carefully researched study of the effects of strong emotions on the body. Metabolic charts included. | Jun 15 1998 12:00 am |
PS2106 | Life Without Fear | psychology | 0736 | 17.00 | 6000.00 | 111 | 1 | New exercise, meditation, and nutritional techniques that can reduce the shock of daily interactions. Popular audience. Sample menus included, exercise video available separately. | Oct 05 1998 12:00 am |
PS3333 | Prolonged Data Deprivation: Four Case Studies | psychology | 0736 | 29.99 | 2000.00 | 4072 | 1 | What happens when the data runs dry? Searching evaluations of information-shortage effects. | Jun 12 1998 12:00 am |
PS7777 | Emotional Security: A New Algorithm | psychology | 0736 | 17.99 | 4000.00 | 3336 | 1 | Protecting yourself and your loved ones from undue emotional stress in the modern world. Use of computer and nutritional aids emphasized | Jun 12 1998 12:00 am |
TC3218 | Onions, Leeks, and Garlic: Cooking Secrets of the Mediterranean | trad_cook | 0877 | 40.95 | 7000.00 | 375 | 1 | Profusely illustrated in color, this makes a wonderful gift book for a cuisine-oriented friend. | Oct 21 1998 12:00 am |
TC4203 | Fifty Years in Buckingham Palace Kitchens | trad_cook | 0877 | 21.95 | 4000.00 | 15096 | 1 | More anecdotes from the Queen's favorite cook describing life among English royalty. Recipes, techniques, tender vignettes. | Jun 12 1998 12:00 am |
TC7777 | Sushi, Anyone? | trad_cook | 0877 | 29.99 | 8000.00 | 4095 | 1 | Detailed instructions on improving your position in life by learning how to make authentic Japanese sushi in your spare time. 5-10% increase in number of friends per recipe reported from beta test | Jun 12 1998 12:00 am |
18.119.14.235