// 'MC3021','4001','6000','16'  end
// 'MC3021','6001','8000','18'  end
// 'MC3021','8001','10000','20'  end
// 'MC3021','10001','12000','22'  end
// 'MC3021','12001','50000','24'  end
// 'TC3218','0','2000','10'  end
// 'TC3218','2001','4000','12'  end
// 'TC3218','4001','6000','14'  end
// 'TC3218','6001','8000','16'  end
// 'TC3218','8001','10000','18'  end
// 'TC3218','10001','12000','20'  end
// 'TC3218','12001','14000','22'  end
// 'TC3218','14001','50000','24'  end
// 'PC8888','0','5000','10'  end
// 'PC8888','5001','10000','12'  end
// 'PC8888','10001','15000','14'  end
// 'PC8888','15001','50000','16'  end
// 'PS7777','0','5000','10'  end
// 'PS7777','5001','50000','12'  end
// 'PS3333','0','5000','10'  end
// 'PS3333','5001','10000','12'  end
// 'PS3333','10001','15000','14'  end
// 'PS3333','15001','50000','16'  end
// 'BU1111','0','4000','10'  end
// 'BU1111','4001','8000','12'  end
// 'BU1111','8001','10000','14'  end
// 'BU1111','12001','16000','16'  end
// 'BU1111','16001','20000','18'  end
// 'BU1111','20001','24000','20'  end
// 'BU1111','24001','28000','22'  end
// 'BU1111','28001','50000','24'  end
// 'MC2222','0','2000','10'  end
// 'MC2222','2001','4000','12'  end
// 'MC2222','4001','8000','14'  end
// 'MC2222','8001','12000','16'  end
// 'MC2222','12001','20000','18'  end
// 'MC2222','20001','50000','20'  end
// 'TC7777','0','5000','10'  end
// 'TC7777','5001','15000','12'  end
// 'TC7777','15001','50000','14'  end
// 'TC4203','0','2000','10'  end
// 'TC4203','2001','8000','12'  end
// 'TC4203','8001','16000','14'  end
// 'TC4203','16001','24000','16'  end
// 'TC4203','24001','32000','18'  end
// 'TC4203','32001','40000','20'  end
// 'TC4203','40001','50000','22'  end
// 'BU7832','0','5000','10'  end
// 'BU7832','5001','10000','12'  end
// 'BU7832','10001','15000','14'  end
// 'BU7832','15001','20000','16'  end
// 'BU7832','20001','25000','18'  end
// 'BU7832','25001','30000','20'  end
// 'BU7832','30001','35000','22'  end
// 'BU7832','35001','50000','24'  end
// 'PS1372','0','10000','10'  end
// 'PS1372','10001','20000','12'  end
// 'PS1372','20001','30000','14'  end
// 'PS1372','30001','40000','16'  end
// 'PS1372','40001','50000','18'  end
TABLE sales pubs dbo
<> stor_id char 4 1
<> ord_num varchar 20 12
<> ord_date datetime 16 93
<> qty smallint 2 5
<> payterms varchar 12 12
<> title_id tid 6 12
// '6380','6871','4444656','5','Net 60','BU1032'  end
// '6380','722a','4444656','3','Net 60','PS2091'  end
// '7066','A2976','4444656','50','Net 30','PC8888'  end
// '7066','QA7442.3','4444656','75','ON invoice','PS2091'  end
// '7067','D4482','4444656','10','Net 60','PS2091'  end
// '7067','P2121','4444656','40','Net 30','TC3218'  end
// '7067','P2121','4444656','20','Net 30','TC4203'  end
// '7067','P2121','4444656','20','Net 30','TC7777'  end
// '7131','N914008','4444656','20','Net 30','PS2091'  end
// '7131','N914014','4444656','25','Net 30','MC3021'  end
// '7131','P3087a','4444656','20','Net 60','PS1372'  end
// '7131','P3087a','4444656','25','Net 60','PS2106'  end
// '7131','P3087a','4444656','15','Net 60','PS3333'  end
// '7131','P3087a','4444656','25','Net 60','PS7777'  end
// '7896','QQ2299','4444656','15','Net 60','BU7832'  end
// '7896','TQ456','4444656','10','Net 60','MC2222'  end
// '7896','X999','4444656','35','ON invoice','BU2075'  end
// '8042','423LL922','4444656','15','ON invoice','MC3021'  end
// '8042','423LL930','4444656','10','ON invoice','BU1032'  end
// '8042','P723','4444656','25','Net 30','BU1111'  end
// '8042','QA879.1','4444656','30','Net 30','PC1035'  end
TABLE stores pubs dbo
<> stor_id char 4 1
<> stor_name varchar 40 12
<> stor_address varchar 40 12
<> city varchar 20 12
<> state char 2 1
<> zip char 5 1
// '6380','Eric the Read Books','788 Catamaugus Ave.','Seattle','WA','98056'  end
// '7066','Barnum's','567 Pasadena Ave.','Tustin','CA','92789'  end
// '7067','News & Brews','577 First St.','Los Gatos','CA','96745'  end
// '7131','Doc-U-Mat: Quality Laundry and Books','24-A Avogadro Way','Remulade','WA','98014'  end
// '7896','Fricative Bookshop','89 Madison St.','Fremont','CA','90019'  end
// '8042','Bookbeat','679 Carson St.','Portland','OR','89076'  end
TABLE titleauthor pubs dbo
<> au_id id 11 12
<> title_id tid 6 12
<> au_ord tinyint 1 -6
<> royaltyper int 4 4
// '172-32-1176','PS3333','4444656','100'  end
// '213-46-8915','BU1032','4444656','40'  end
// '213-46-8915','BU2075','4444656','100'  end
// '238-95-7766','PC1035','4444656','100'  end
// '267-41-2394','BU1111','4444656','40'  end
// '267-41-2394','TC7777','4444656','30'  end
// '274-80-9391','BU7832','4444656','100'  end
// '409-56-7008','BU1032','4444656','60'  end
// '427-17-2319','PC8888','4444656','50'  end
// '472-27-2349','TC7777','4444656','30'  end
// '486-29-1786','PC9999','4444656','100'  end
// '486-29-1786','PS7777','4444656','100'  end
// '648-92-1872','TC4203','4444656','100'  end
// '672-71-3249','TC7777','4444656','40'  end
// '712-45-1867','MC2222','4444656','100'  end
// '722-51-5454','MC3021','4444656','75'  end
// '724-80-9391','BU1111','4444656','60'  end
// '724-80-9391','PS1372','4444656','25'  end
// '756-30-7391','PS1372','4444656','75'  end
// '807-91-6654','TC3218','4444656','100'  end
// '846-92-7186','PC8888','4444656','50'  end
// '899-46-2035','MC3021','4444656','25'  end
// '899-46-2035','PS2091','4444656','50'  end
// '998-72-3567','PS2091','4444656','50'  end
// '998-72-3567','PS2106','4444656','100'  end
TABLE titles pubs dbo
<> title_id tid 6 12
<> title varchar 80 12
<> type char 12 1
<> pub_id char 4 1
<> price money 21 3
<> advance money 21 3
<> royalty int 4 4
<> ytd_sales int 4 4
<> notes varchar 200 12
<> pubdate datetime 16 93
// 'BU1032','The Busy Executive's Database Guide','business    ','1389','19.9900','5000.0000','10','4095','An overview of available database systems with emphasis on common business applications. Illustrated.','0'  end
// 'BU1111','Cooking with Computers: Surreptitious Balance Sheets','business    ','1389','11.9500','5000.0000','10','3876','Helpful hints on how to use your electronic resources to the best advantage.','0'  end
// 'BU2075','You Can Combat Computer Stress!','business    ','0736','2.9900','10125.0000','24','18722','The latest medical and psychological techniques for living with the electronic office. Easy-to-understand explanations.','0'  end
// 'BU7832','Straight Talk About Computers','business    ','1389','19.9900','5000.0000','10','4095','Annotated analysis of what computers can do for you: a no-hype guide for the critical user.','0'  end
// 'MC2222','Silicon Valley Gastronomic Treats','mod_cook    ','0877','19.9900','.0000','12','2032','Favorite recipes for quick, easy, and elegant meals.','0'  end
// 'MC3021','The Gourmet Microwave','mod_cook    ','0877','2.9900','15000.0000','24','22246','Traditional French gourmet recipes adapted for modern microwave cooking.','0'  end
// 'MC3026','The Psychology of Computer Cooking','UNDECIDED   ','0877','2.9900','15000.0000','24','22246','Traditional French gourmet recipes adapted for modern microwave cooking.','0'  end
// 'PC1035','But Is It User Friendly?','popular_comp','1389','22.9500','7000.0000','16','8780','A survey of software for the naive user, focusing on the 'friendliness' of each.','0'  end
// 'PC8888','Secrets of Silicon Valley','popular_comp','1389','20.0000','8000.0000','10','4095','Muckraking reporting on the world's largest computer hardware and software manufacturers.','0'  end
// 'PC9999','Net Etiquette','popular_comp','1389','20.0000','8000.0000','10','4095','A must-read for computer conferencing.','0'  end
// 'PS1372','Computer Phobic AND Non-Phobic Individuals: Behavior Variations','psychology  ','0877','21.5900','7000.0000','10','375','A must for the specialist, this book examines the difference between those who hate and fear computers and those who don't.','0'  end
// 'PS2091','Is Anger the Enemy?','psychology  ','0736','10.9500','2275.0000','12','2045','Carefully researched study of the effects of strong emotions on the body. Metabolic charts included.','0'  end
// 'PS2106','Life Without Fear','psychology  ','0736','7.0000','6000.0000','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.','0'  end
// 'PS3333','Prolonged Data Deprivation: Four Case Studies','psychology  ','0736','19.9900','2000.0000','10','4072','What happens when the data runs dry?  Searching evaluations of information-shortage effects.','0'  end
// 'PS7777','Emotional Security: A New Algorithm','psychology  ','0736','7.9900','4000.0000','10','3336','Protecting yourself and your loved ones from undue emotional stress in the modern world. Use of computer and nutritional aids emphasized.','0'  end
// 'TC3218','Onions, Leeks, and Garlic: Cooking Secrets of the Mediterranean','trad_cook   ','0877','20.9500','7000.0000','10','375','Profusely illustrated in color, this makes a wonderful gift book for a cuisine-oriented friend.','0'  end
// 'TC4203','Fifty Years in Buckingham Palace Kitchens','trad_cook   ','0877','11.9500','4000.0000','14','15096','More anecdotes from the Queen's favorite cook describing life among English royalty. Recipes, techniques, tender vignettes.','0'  end
// 'TC7777','Sushi, Anyone?','trad_cook   ','0877','14.9900','8000.0000','10','4095','Detailed instructions on how to make authentic Japanese sushi in your spare time.','0'  end