Page 250 - DCAP405_SOFTWARE_ENGINEERING
P. 250

Unit 14: Data Modeling




                                                                                                Notes
                          Figure 14.5(a): ER diagram for the entity: AccountHolder
                          (Name, Address, DateOfBirth, DateOfOpeningAccount)




















                                Figure 14.5(b): ER diagram for the entity:
                               Account(AccountNumber, OpeningBalance)












          The ER diagram for the relationship “Owns” between these two entities is shown in the
          figure 14.6.
                             Figure 14.6: ER diagram the relationship “Owns”



















          Self Assessment

          Fill in the blanks:

          1.   E-R diagrams are very useful tools to develop and describe the …………………… of a
               database.
          2.   A relationship that exists between two entities is called ……………………… relationship.







                                           LOVELY PROFESSIONAL UNIVERSITY                                   243
   245   246   247   248   249   250   251   252   253   254   255