![]() ![]() (Assume loan can be jointly held by many Customers). One Customer can have more than one Accounts and also One Account can be held by one or more Customers, so the relationship between Account and Customers is many to many relationship. One Branch can have many Loans but one Loan can not belong to many Branches, so the relationship between Branch and Loan is one to many relationship. One Branch can have many Accounts but one Account can not belong to many Branches, so the relationship between Branch and Account is one to many relationship. ![]() One Bank can have many Branches but one Branch can not belong to many Banks, so the relationship between Bank and Branch is one to many relationship. Loan Entity : Attributes of Loan Entity are Loan_id, Loan_Type and Amount.Account Entity : Attributes of Account Entity are Account_number, Account_Type and Balance.Īccount_number is Primary Key for Account Entity.Branch Entity : Attributes of Branch Entity are Branch_id, Name and Address.īranch_id is Primary Key for Branch Entity.Customer Entity : Attributes of Customer Entity are Customer_id, Name, Phone Number and Address.Ĭustomer_id is Primary Key for Customer Entity.Bank Entity : Attributes of Bank Entity are Bank Name, Code and Address.It allows us to understand the relationships between entities. This bank ER diagram illustrates key information about bank, including entities such as branches, customers, accounts, and loans. Commonly asked DBMS interview questions.Introduction of DBMS (Database Management System) | Set 1.SQL query to find second highest salary?.SQL | Join (Inner, Left, Right and Full Joins).Unified Modeling Language (UML) | Sequence Diagrams.Unified Modeling Language (UML) | Class Diagrams.Introduction of Relational Model and Codd Rules in DBMS.Generalization, Specialization and Aggregation in ER Model.Conceptual Model of the Unified Modeling Language (UML).Unified Modeling Language (UML) | An Introduction.Unified Modeling Language (UML) | Object Diagrams.Unified Modeling Language (UML) | Activity Diagrams. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |