modern database management 7th edition, chapter 3文档.pdf

Modern Database Management Modern Database Management th 7th Edition, Chapter 3 7 Edition, Chapter 3 Jeffrey A. Hoffer, Mary B. Prescott, Jeffrey A. Hoffer, Mary B. Prescott, Fred R. McFadden Fred R. McFadden Slides edited by Rasmus Pagh Slides edited by Rasmus Pagh © 2005 by Prentice Hall 1 © 2005 by Prentice Hall 1 Simpelt E-R diagram Simpelt E-R diagram Hvordan ser de tilsvarende relationer ud? Chapter 3 © 2005 by Prentice Hall © 2005 by Prentice Hall 2 2 What Should an Entity Type Be? What Should an Entity Type Be?  SHOULD BE:  SHOULD BE:  An object that will have many instances in  An object that will have many instances in the database the database  An object that will be composed of multiple  An object that will be composed of multiple attributes attributes  An object that we are trying to model  An object that we are trying to model  SHOULD NOT BE:  SHOULD NOT BE:  A user of the database system  A user of the database system  An output of the database system (e.g. a  An output of the database system (e.g. a report) report) Chapter 3 © 2005 by Prentice Hall © 2005 by Prentice Hall 3 3 Examples Examples • The actor ”Bruce Willis” should not be an entity t