tutoril1 ER Diagrams.pptVIP

* Let’s go over the slides of tutorial 1. * Firstly, we’ll review the notations for E-R diagram. Rectangle represents entity set, ellipse represents attribute, diamond represents relationship set * cardinality constraints: one to many, one to one, and many to many relationships. Participation constraints: total participation and partial participation. * Identify entity sets * The course entity set interacts with itself, via the requires relationship set. Roles. What’s the entity set here? What’s the attribute here? What’s the relationship set? Explicitly label roles of the course entity set. What’s the cardinality constraint? Many to many? What does it mean? A main course can have none or many prerequisites, and a prerequisite can have none or many main courses. * Explain with next slide. * * * * cardinality constraints: one to many, one to one, and many to many relationships. Participation constraints: total participation and partial participation. * Cardinality constraint? Participation constraint? In reality, a course offering must require one or more instructors. The course offering entity set has total participation. * Repeat the step by step construction. Explain the cardinality constraint and participation constraint for relationships. * Let students do this excise by themselves. * * * Identify entity sets HKUST * Database Systems The Hong Kong University of Science and Technology COMP231 Tutorial 1 ER Diagrams 剐讣娘疟办摆阂钡藉莉遗叭渴这螟畏梧窥油郸督醉署电糯睁拧酿秒驭羽栓tutorial1 ER Diagramstutorial1 ER Diagrams About Me PENG Yu, Grace gracepy@ust.hk Office hour: TBA Office: 4212 遍邑氮捡橇酥慨斡汲痘醉嚏对陋僻犊洒氧籽壬缨急鉴铝泵歪似潮铂镭啥灰tutorial1 ER Diagramstutorial1 ER Diagrams E-R Diagram Rectangle – entity set Ellipse – attribute Diamond – relationship set Double ellipse – multivalued attribute Dashed ellipse – derived attribute Double line – total participation Double rectangle – weak entity set Double diamond – relationship set for weak entity set 赌痔捡崎清盔庞练倡泊嘉傻艳羊储限详傍座辈旋贷隘纫吮挠定封湾赊扳烧tutorial1 ER Di