Question: Would you please solve these two eer model problems? Thank gou 1. Consider the following data requirements for a banking application A bank account has

Would you please solve these two eer model problems? Thank gou  Would you please solve these two eer model problems? Thank gou
1. Consider the following data requirements for a banking application A bank
account has an account number, an opening date and a balance. There

1. Consider the following data requirements for a banking application A bank account has an account number, an opening date and a balance. There are two types of accounts: checking and saving. An account must be at least either saving or checking, while some accounts can be both saving and checking. A saving account has an interest rate while a checking account has a minimum deposit amount. An account owner has an owner id and a start date. An owner may own several accounts, while an account can have several owners. An owner always owns at least one account, while not every account has an owner A check has a check number, which is unique only in the same checking account. A check also has a date and an amount. A check must belong to one and only one checking account while a check account may have many checks. There are two categories of owners: person and company. A person has a first name, a last name, and an SSN. A company has a name, a tax id and an address. Every company is an owner, while not every person is an owner. A bank employee has an SSN, a name (first and last) and a start date Some bank employees are account owners. interest rate Each employee-owner has a bonus Draw an EER diagram based on the requirements. (50 pts)

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!