数据库系统基础教程DatabaseSystems.ppt

* * * * * * * 1.3.3 An example of database application Well build a marketing database system for a sale company. It will manage all the following information: 1. Manage all department information in the company (such as “Shanghai sale department”, “JiangSu sale department”). Also manage every salesman information in those departments including exclusive(唯一的) employee number, ID card number, and some private information (such as name, gender, birthday and phone number). By the way one of salesmen will act as the department manager in his department. 1.3.3 An example of database application 2. Manage a group of customers: name, province(省), city, company name, phone number. 3.Manage all the product information: manufacturers (e.g. Chunlan, Hailer ), types (e.g. motorcycle, air conditioner ), specifications (e.g. MT125, RE1500 ), prices, descriptions. 4.? Manage sales order which record each deal(交易) has been done. Notes: every sales order contains an unique order No. , sign date, a corresponding customer, a salesman, and at least one kind of products. Any product in the order should have its quantity and unit price which will be used to calculate the total prices. 为某商品销售公司构作一个销售业务数据库系统，该系统至少应管理以下内容： 公司分为多个下属部门(Department)，如“江苏销售部”，“上海销售部”等。每个部门有若干销售员(Salesman)，每个销售员有唯一的员工号(如“S0025”)和身份证号，也包含姓名、性别、出生日期、电话等信息。一个销售员仅属于一个部门，且每个部门有一个销售员担任部门经理。 。 系统应管理客户信息(Customer)，包含：名称、省、市、单位名称、电话等。 系统应管理所有销售的商品(Product)：制造商(如“春兰”、“海尔”)、种类(如“摩托车”、“空调机”)、规格(如“MT125”型摩托车、“RE1500”型空调)、价格、功能及性能描述。 该系统用销售订单(Sales order)表示销售业务。每个订单有一个订单号和签订日期，且对应一个客户和一个销售员。一个订单至少销售一种产品，并可销售多种产品，且每种产品应确定其销售数量和单价，以计算销售金额。 1.3.3 An example of database application Department Salesman Customer Salesorder Product Salesitem sales for runs for as header works for unit-of contains deptid name empid idno name gender phone name prov city phone unit orderno signdate custid lineno salescost quantity type spec price desc prodid factory Entity/Relationship Model 1.3.3 An example of