内容讲义课件comp er.pptxVIP

Entity Relationship ModelOverviewDatabase design is essentially to decide the set of tables needed tostore all the data in the underlying applications;capture the relationships among data.Design steps: Requirement analysisConceptual database designLogical database designPhysical database design…Data modelingIdentify and understand the business rules that govern dataA student may register for COMP4035 (Database System Implementation) only if the student has passed COMP2016One lab session has at most 45 studentsThe percentage of ‘A’ grades must be between 10%-20%Need a tool to represent these rules in a concise but accurate manner, so that they can be unambiguously understood by information system developers and usersEntity-Relationship Diagram (ER Diagram) is such a toolRepresent rules in terms of entities and their relationshipsProposed by /wiki/Peter_ChenPeter Chen in 1976Entity and entity setAn entity is a real-world object distinguishable from other objects.A person, a pet, a CD, a … An entity has attributes.A person has a name and an address …A pet has a nickname…A CD has an author…An entity set is a set of entities that share the same attributes.A “person entity set”.A “pet entity set”.A “CD entity set”.Entity set examplesNameHKIDAddressAliceR133428(6)KowloonBobP625228(4)Hong KongCandyA252242(7)New Territories IDName1Sam2Lady3BearPetPersonaddressnameHKIDIDnameTo represent an entity setPersonPetaddressHKIDnameEach entity set has a key ? minimal set of attributes whose value uniquely identifies an entityThere could be more than one candidate keys; the one designated is the primary keyEntity set: studentsPersonageemailstudent idnameKeyAttribute typesSimple vs. compositeSingle-valued vs. multi-valuedName vs. phone-numbersDerived vs. non-derivedDate of birth: Non-derivedAge: Derivedmiddlelast-namedate-of-birthfirst-namezip-codestatecityapartment-numberstreet-namestreetstreet-numberHKIDnameaddressPersonphone-numberagemulti-valued attributederived attributeIn Class Ex