lec02-Entity Relationship精选.pdfVIP

The Entity-Relationship Model Chapter 2 9/8/2011 1 Database Design • Requirements Analysis • Data stored, operations, apps, … • Conceptual Database Design • Model high-level description of the data, constraints, ER model • Logical Database Design • Choose a DBMS and design a database schema • Schema Refinement • Physical Database Design • Application and Security Design 9/8/2011 2 ER Model Basics • Entity: Distinguishable real-world object • Described by a set of attributes; Each attribute has a domain • Entity Set : A collection of similar entities. E.g., all citizens. • All entities in an entity set have the same set of attributes. (Until we consider ISA hierarchies!) • Key : minimal set of attributes whose values uniquely identify an entity in an entity set • 1 Primary key ssn name bday • Multiple Candidate keys • Pictorially … Citizen 9/8/2011 3 ER Model Basics • Relationship : Association among two or more entities • Relationship Set : Collection of similar relationships pid addr size ssn name bday Poll Stn Citizen E l C e ssn name bday cid waddr budget c