北邮-数据库系统原理(英文)-6-15摘要.ppt

Customer Product Order make contain C-number C-name discount balance address address O-number date year month day quantity of ordered P-number P-name plant quantity on hand Fig. C.1. E-R diagram of the ordering DB is shown in April 2014 Database System Concepts - Chapter6 Database Design and E-R Model * The E-R diagram in Fig. C.1 is then reduced to some relational tables, according to the methodologies mentioned in §6.9 For entity set Customer and its multi-valued attribute ship-to addresses, there are two tables customer=(C-number, c-name, discount, balance) ship-to-addresses = (C-num