Conceptual Modelling .pptVIP

DB- Introduction  ER ModelsISSUESand ExamplesCS263 Lecture 9 ER Issues - Fan Trap Where a model represents a relationship between entity types, but the pathway between certain entity occurrences is ambiguous. ER Issues - Fan Trap Resolution We resolve the Fan Trap by restructuring the original ER model to represent the correct association between the entities concerned. Developing an ER Diagram Step 1 Identify Entities Step 2 Work out relationships Step 3 Identify Attributes Step 4 Identify optionality Step 5 Identify KEY attributes (Resolve any assumptions) Example Problem 1 A college library holds books for its members to borrow. Each book may be written by more than one author. Any one author may have written several books. If no copies of a wanted book are currently in stock, a member may make a reservation for the title until it is available. If books are not returned on time a fine is imposed and if the fine is not paid the member is barred from loaning any other books until the fine is paid. Example Problem 1 A college library holds books for its members to borrow. Each book may be written by more than one author. Any one author may have written several books. If no copies of a wanted book are currently in stock, a member may make a reservation for the title until it is available. If books are not returned on time a fine is imposed and if the fine is not paid the member is barred from loaning any other books until the fine is paid. Example Problem 1 A college library holds books for its members to borrow. Each book may be written by more than one author. Any one author may have written several books. If no copies of a wanted book are currently in stock, a member may make a reservation for the title until it is available. If books are not returned on time a fine is imposed and if the fine is not paid the member is barred from loaning any other books until the fine is paid. Example Problem 1 A college library holds books for its members to b