英语翻译Tasks1.\x05Design a detailed conceptual model using EER to define the information needs of the College.Your report should cover the following\x05\x05\x05\x05[40%]i.\x05State clearly the assumptions that you made in developing the diagram;

英语翻译Tasks1.\x05Design a detailed conceptual model using EER to define the information needs of the College.Your report should cover the following\x05\x05\x05\x05[40%]i.\x05State clearly the assumptions that you made in developing the diagram;
英语翻译
Tasks
1.\x05Design a detailed conceptual model using EER to define the information needs of the College.Your report should cover the following\x05\x05\x05\x05
[40%]
i.\x05State clearly the assumptions that you made in developing the diagram;
ii.\x05Identify all the real world entities.Give a candidate key and suitable attributes for each entity.Indicate clearly the multi-valued attributes.Show clearly the weak entities and determine its relationship with the owner entities;
iii.\x05Identify the Super/ subtype entity available in the given scenario.Identify the constraints on the generalization/specialization as either disjoint or overlapping;
iv.\x05Identify the relationships among the entities.Indicate clearly the cardinality of each relationship.Show the attributes for each relationship,if any.Give any additional semantic feature of the relationships such as total participation or partial participation;
v.\x05Draw a complete EER diagram.
2.\x05Use the EER from Task 1 to derive the relations.Explain and justify the types of integrity constraints that will be imposed on the proposed database.\x05
[40%]
3.\x05Use any relational database software to implement the relations.Populate the database with sample data.Provide screen dumps of the implemented structures with supporting notes.\x05\x05\x05\x05\x05\x05\x05\x05
[20%]

英语翻译Tasks1.\x05Design a detailed conceptual model using EER to define the information needs of the College.Your report should cover the following\x05\x05\x05\x05[40%]i.\x05State clearly the assumptions that you made in developing the diagram;
翻译结果内容如下：
任务
1、使用能效比定义该学院的信息需求,设计一个详细的概念模型.你的报告应当包括下列内容[40%]
①、清楚说明中发展关系图所作的假设 ；
②、为每个实体键和适当的属性给一名候选人.找出真实世界的所有实体.明确说明的多值的属性.清楚显示弱的实体,并确定及其与所有者的实体 ；
③、确定超/子类型可用在给定方案中的实体.标识作为不相交或重叠；推广/专业化的约束.
④、标识实体之间的关系.明确说明每个关系的基数.显示的属性为每个关系,如果有的话,给任何额外的语义功能的关系,例如全员参与或部分参与 .
⑤、绘制完成的能效比图.
2、从任务 1 能效比用于派生关系.解释和说明将施加的拟议的数据库的完整性约束的类型.[40%]
3、使用关系数据库的任何软件来实现关系,填充该数据库的示例数据.屏幕转储的实现结构提供支持注释.[20%]