1Database design: ER diagramsINFO/COM S 230:Intermediate Web Design andProgrammingSection this Friday• First part will be given to meeting withyour final project team to talk aboutorganization and finding a client.• Second part will be given to letting youwork on Project 3 (and get help fromyour TA).• Attendance required (at least for theteam meeting).Database design• Starting today: how to go from clientrequirements to a good relational DBschema• Today and next time: Entity-Relationship (ER) diagrams• After that: NormalizationER diagramsER diagrams are a graphical means ofdisplayingrelationshipsbetweenentitysets(hence the name); both entity setsand relationships can haveattributes.Every DB text has a slightly different takeon ER diagrams; we’ll use a form from abook by Garcia-Molina, Ullman, andWidom (in the coursepack).Entity setsAnentityis an abstract object of somesort.Entity setsare a collection ofsimilar entities.E.g. Movies, StarsWe’ll draw these using rectangles.Easy PDF Creator is professional software to create PDF. If you wish to remove this line, buy it now.
has intentionally blurred sections.
Sign up to view the full version.