uml课件Lect13-RESTAURANT SYSTEM-DB Design.pptVIP

Lecture 13. Database Design:  Restaurant Example /dbdesign/dbdesign.php?page=intro.html 内容提要： Relation scheme UML Association Inheritance and subclasses Aggregation Persistent Data Storage (Mark Priestley: 6.3) 6. Object-relational Mapping(ORM) Relation scheme 关系型模型的 模式(schema) In the relational model, a schema is defined as a set of attributes, and an assignment rule that associates each attribute with a set of legal values. Customers Scheme = { cFirstname, cLastname, cPhone, cStreet, cZipCode }. Relation scheme 根据关系模式，建立表格 Table structure （表格结构） When we actually build the database, each relation schema becomes the structure for one table. CREATE TABLE customers ( cfirstname VARCHAR(20) NOT NULL, clastname VARCHAR(20) NOT NULL, cphone VARCHAR(20) NOT NULL, cstreet VARCHAR(50), czipcode VARCHAR(5) ); UML Association 考虑将类之间的关系映射为数据库表格之间的关系 The UML association is the way that two classes are functionally connected to each other. The Customer class can be mapped into a table as below. UML Association 怎样在数据库中表示两个类之间的关联呢? Relation schema diagram To represent the association in the database, we need to record which customer placed each order. by copying the PK attributes of the Customer into the Orders schema (the copied attributes are called a foreign key (FK)) UML Association UML Association 父模式与子模式 Since we can’t have an order without a customer, we call Customers the parent and Orders the child scheme in this association. The “one” side of an association is always the parent, and provides the PK attributes to be copied. The “many” side of an association is always the child, into which the FK attributes are copied. UML Association 外键是否一定成为与之关联的子关系的主键的一部分呢?