Question: Q3. How do you represent an ER Diagram? [5 points) A bank manages its customers, their accounts and the transactions (i.e., deposit and withdraw of

 Q3. How do you represent an ER Diagram? [5 points) A

Q3. How do you represent an ER Diagram? [5 points) A bank manages its customers, their accounts and the transactions (i.e., deposit and withdraw of amounts of money) performed by customers on their accounts. Each customer has an identifier Cust_No, Name, City, and a Type (possible values are P: Physical person, C: Company). Each Account is identified by Acc_No, has a Date Opened, an Actual Amount of Balance, the Date of Balance, and the currency (like SAR, USD, TND.....) Customers perform Transactions on their Accounts. A transaction is identified by a number Tr_No, has a Date, Type (Debit or Credit operation), and Amount. Assume that each person owns one or several accounts, and several transactions are performed daily concerning each account. 1. Develop (Draw) an ER (Entity Relationship) diagram as a conceptual model using the notation used in the course. Answer here

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!