# Database Examples/Pubs/Titles
## Fields

| Field Name | Field Type | Length | Index | Constraint |
| title_id | Text | 6 | Primary Key | Not Null |
| title | Text | 80 | Yes | Not Null |
| type | Text | 12 | | |
| pub_id | Integer | 2 | Yes | Foreign Key |
| price | Decimal | | | >=0 |
| advance | Decimal | | | >=0 |
| royalty | Decimal | | | >=0 |
| ytd_sales | Decimal | | | >=0 |
| notes | Text | 200 | | |
| pubdate | Date | | | Not Null |

## 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.00 | 10.00 | 4095.00 | An overview of available database systems with emphasis on common business applications. Illustrated. | 6/12/2021 |
| BU1111 | Cooking with Computers: Surreptitious Balance Sheets | business | 1389 | 11.95 | 5000.00 | 10.00 | 3876.00 | Helpful hints on how to use your electronic resources to the best advantage. | 6/9/2021 |
| BU2075 | You Can Combat Computer Stress! | business | 736 | 2.99 | 10125.00 | 24.00 | 18722.00 | The latest medical and psychological techniques for living with the electronic office. Easy-to-understand explanations. | 6/30/2021 |
| BU7832 | Straight Talk About Computers | business | 1389 | 19.99 | 5000.00 | 10.00 | 4095.00 | Annotated analysis of what computers can do for you: a no-hype guide for the critical user. | 6/22/2021 |
| MC2222 | Silicon Valley Gastronomic Treats | mod_cook | 877 | 19.00 | 0.00 | 12.00 | 2032.00 | Favorite recipes for quick, easy, and elegant meals. | 6/9/2021 |
| MC3021 | The Gourmet Microwave | mod_cook | 877 | 2.99 | 15000.00 | 24.00 | 22246.00 | Traditional French gourmet recipes adapted for modern microwave cooking. | 6/18/2021 |
| MC3026 | The Psychology of Computer Cooking | UNDECIDED | 877 | | | | | | 1/15/2022 |
| PC1035 | But Is It User Friendly? | popular_comp | 1389 | 22.95 | 7000.00 | 16.00 | 8780.00 | A survey of software for the naive user, focusing on the 'friendliness' of each. | 6/30/2021 |
| PC8888 | Secrets of Silicon Valley | popular_comp | 1389 | 20.00 | 8000.00 | 10.00 | 4095.00 | Muckraking reporting on the world's largest computer hardware and software manufacturers. | 6/12/2024 |
| PC9999 | Net Etiquette | popular_comp | 1389 | | | | | A must-read for computer conferencing. | 1/15/2022 |
| PS1372 | Computer Phobic AND Non-Phobic Individuals: Behavior Variations | psychology | 877 | 21.59 | 7000.00 | 10.00 | 375.00 | A must for the specialist, this book examines the difference between those who hate and fear computers and those who don't. | 10/21/2021 |
| PS2091 | Is Anger the Enemy? | psychology | 736 | 10.95 | 2275.00 | 12 | 2045.00 | Carefully researched study of the effects of strong emotions on the body. Metabolic charts included. | 6/15/2021 |
| PS2106 | Life Without Fear | psychology | 736 | 7.00 | 6000.00 | 10.00 | 111.00 | New exercise, meditation, and nutritional techniques that can reduce the shock of daily interactions. Popular audience. Sample menus included, exercise video available separately. | 10/5/2021 |
| PS3333 | Prolonged Data Deprivation: Four Case Studies | psychology | 736 | 19.99 | 2000.00 | 10.00 | 4072.00 | What happens when the data runs dry? Searching evaluations of information-shortage effects. | 6/12/2021 |
| PS7777 | Emotional Security: A New Algorithm | psychology | 736 | 7.99 | 4000.00 | 10.00 | 3336.00 | Protecting yourself and your loved ones from undue emotional stress in the modern world. Use of computer and nutritional aids emphasized. | 6/12/2021 |
| TC3218 | Onions, Leeks, and Garlic: Cooking Secrets of the Mediterranean | trad_cook | 877 | 20.95 | 7000.00 | 10.00 | 375.00 | Profusely illustrated in color, this makes a wonderful gift book for a cuisine-oriented friend. | 10/21/2021 |
| TC4203 | Fifty Years in Buckingham Palace Kitchens | trad_cook | 877 | 11.95 | 4000.00 | 14.00 | 15096.00 | More anecdotes from the Queen's favorite cook describing life among English royalty. Recipes, techniques, tender vignettes. | 6/12/2021 |
| TC7777 | Sushi, Anyone? | trad_cook | 877 | 14.99 | 8000.00 | 10.00 | 4095.00 | Detailed instructions on how to make authentic Japanese sushi in your spare time. | 6/12/2021 |