ER Diagram for a Bank Database
In a bank database, the Bank entity manages multiple Branches, each Branch has multiple Accounts, each Account is owned by a Customer, and each Customer may have a relationship with one or more Employees of the bank.
Attributes: Attributes are the characteristics or properties of entities, such as "CustomerID" or "Address."
Relationships: Relationships define how entities are connected or related to one another within the database.
Degree of Relationships: The degree of a relationship refers to how many entities are involved in that relationship; most often, it involves two entities at a time.
Connectivity of Relationships: Connectivity specifies how entities are directly linked in a relationship, like "one-to-one," "one-to-many," or "many-to-many."
Cardinality of Relationships: Cardinality indicates the number of instances or occurrences of one entity that can be associated with the other entity in the relationship, such as "1-M" or "1-1."
Comments
Post a Comment