Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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 image text in transcribed
image text in transcribed
image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Spatial Databases A Tour

Authors: Shashi Shekhar, Sanjay Chawla

1st Edition

0130174807, 978-0130174802

More Books

Students also viewed these Databases questions

Question

How will these issues affect the grade levels you will teach?

Answered: 1 week ago