数据库系统概念教学课件ch7.ppt

Reduction to Relational Schemas Extended ER Features * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * Figure 7.22 Figure 7.23 Figure 7.24 Figure 7.25 Figure 7.26 Figure 7.27 Figure 7.28 Figure 7.29 * * * * * * * * * * * * * * * * * * * * * * * * Schemas Corresponding to Aggregation (Cont.) For example, to represent aggregation manages between relationship works_on and entity set manager, create a schema eval_for (s_ID, project_id, i_ID, evaluation_id) Schema proj_guide is redundant provided we