1. A BANK_ACCOUNT is being managed by a BANK_CLIENT; A BANK_CLIENT manages only one BANK_ACCOUNT. (one is to one relationship)

2. A TELLER entertains one or up to 100 BANK_CLIENTs; Each BANK_CLIENTs are being entertained by a TELLER. (one is to many relationship)

3. One or many BANK_CLIENTs can request for one or up to 3 TRANSACTIONs; Each TRANSACTIONs can be requested by each BANK_CLIENTs. (many is to many relationship)
INSTRUCTIONS:
1. Create a whole Conceptual model using an ERD for the above Business Rule.

2. Apply the Chen’s Notation for the given business rule.

3. Define necessary ATTRIBUTES for each entity.

A. Research on the actual attributes needed or being used in the Industry

B. Define the necessary Primary Key and Foreign Key for each entity.

4. Define the complete RELATIONSHIP that will relate each entity, including the name, connectivity and cardinality.
EXAMPLE:
The above given example is incomplete. Make sure to write a completed diagram. 

Transcribed Image Text:

AcctName Password LastSignedOn SbscrbrName SbscrbrAddress SbscrbrEMail SbscrbrPhone AcctCreated On CreepName HitPoints Mana Attack m LastPlayed Account Created On n RanInto Creep 1 Has IDNum Modifier IsType CharName Level ExpPoints Type n Carrying Character n MaxHitPoints Carrying Item Instantiation CurrHitPoints IDNum Creep Instantiation MaxMana CurrMana Contains IsType WhenCreated n RegionName Region Item Precipitation ItemName Climate Foliage Contains Playersin Item Type Item Damage AcctName Password LastSignedOn SbscrbrName SbscrbrAddress SbscrbrEMail SbscrbrPhone AcctCreated On CreepName HitPoints Mana Attack m LastPlayed Account Created On n RanInto Creep 1 Has IDNum Modifier IsType CharName Level ExpPoints Type n Carrying Character n MaxHitPoints Carrying Item Instantiation CurrHitPoints IDNum Creep Instantiation MaxMana CurrMana Contains IsType WhenCreated n RegionName Region Item Precipitation ItemName Climate Foliage Contains Playersin Item Type Item Damage AcctName Password LastSignedOn SbscrbrName SbscrbrAddress SbscrbrEMail SbscrbrPhone AcctCreated On CreepName HitPoints Mana Attack m LastPlayed Account Created On n RanInto Creep 1 Has IDNum Modifier IsType CharName Level ExpPoints Type n Carrying Character n MaxHitPoints Carrying Item Instantiation CurrHitPoints IDNum Creep Instantiation MaxMana CurrMana Contains IsType WhenCreated n RegionName Region Item Precipitation ItemName Climate Foliage Contains Playersin Item Type Item Damage AcctName Password LastSignedOn SbscrbrName SbscrbrAddress SbscrbrEMail SbscrbrPhone AcctCreated On CreepName HitPoints Mana Attack m LastPlayed Account Created On n RanInto Creep 1 Has IDNum Modifier IsType CharName Level ExpPoints Type n Carrying Character n MaxHitPoints Carrying Item Instantiation CurrHitPoints IDNum Creep Instantiation MaxMana CurrMana Contains IsType WhenCreated n RegionName Region Item Precipitation ItemName Climate Foliage Contains Playersin Item Type Item Damage

Answer rating: 100% (QA)

To create a conceptual ERD using Chens Notation for the provided business rules well follow these st... View the full answer