Jump to content

Database Examples/Pubs/Titles

From Wikiversity

Fields

[edit | edit source]
Field Name Field Type Length Index Constraint Default
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
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