20100369_廖显浩_Assignment_01.docVIP

School of Economics Business Administration Chongqing University Assignment #01 Course Name Database Principle and Application Name of Student 廖显浩 Student ID Class 信息管理与信息系统 Major 信息管理与信息系统 Instructor Dr. Yong Li Tutor Completed Time 2012 -03-11 Score Business Constrains: (1)Stillwater buys and sells one-of-a-kind antiques of all kinds (for example, furniture, jewelry, china, and clothing). (2)Some clients only sell items to Stillwater, some only buy items, and some others both sell and buy(3)When Stillwater sells an item in stock to a client, it records the actual selling price (may be different from the asking price), sales tax (tax of zero indicates a tax exempt sale), and date sold.(4)Actual price, sale tax, asking price and purchase cost must be nonnegative number. 整体思路不错，Buying_Information和Selling_Information处有点小错误，请参考标准答案改正一下，加油！