answer1.txt

来自「ssd7考试exam2,绝对有用~欢迎下载」· 文本 代码 · 共 18 行

Entities:

1.Branch: branchID(PK), branchName(AK), branchAddress;
2.Customer: customerID(PK), customerName,mailingAddress, phoneNumber, emailAddress(AK);
3.Account: accountID(PK), customerID, branchID, balance;
4.Transaction: transID(PK), transaction;

Relationships:

1.belongsTo: <Account, Branch>, M:1, TOTAL/PARTIAL;
2.manages: <Branch, Customer>, M:N, PARTIAL/TOTAL;
3.use: <Customer, Account>, 1:M, PARTIAL/TOTAL;
4.operates: <Account, Transaction>, 1:M, PARTIAL/TOTAL;

Some Assumptions:

1.Because there is only one bank in the relationship, there is no need to make it as an entity.
2.One transaction may include multiple accounts more than 2.