实例:数据库sales
1.客户表(Customer)
客户编号(CusNo) | 姓名(CusName) | 地址(Address) | 电话(Tel) |
C001 | 杨婷 | 北京 | 010-5328953 |
C002 | 李和平 | 上海 | 021-62359651 |
C003 | 叶新 | 成都 | 024-3222781 |
C004 | 冯辰诚 | 上海 | 021-87235965 |
2.产品表(Product)
产品编号(ProNo) | 品名(ProName) | 单价(price) | 库存数量(Stocks) |
P0001 | 液晶电视 | 5600.00 | 800 |
P0002 | 空调 | 2390.00 | 460 |
P0003 | 洗衣机 | 3700.00 | 600 |
P0004 | 电热水器 | 890.00 | 120 |
3.销售表(ProOut)
销售日期(SaleDate) | 客户编号(CusNo) | 产品编号(ProNo) | 销售数量(Quantity) |
2007-10-27 | C001 | P0001 | 3 |
2007-11-06 | C004 | P0003 | 40 |
2007-12-27 | C001 | P0003 | 5 |
2008-3-15 | C002 | P0002 | 12 |
2008-05-02 | C003 | P0002 | 21 |
2008-05-02 | C003 | P0001 | 9 |
2008-09-21 | C004 |