Question: Consider the BANK ER schema of Figure 7.21, and suppose that it is necessary to keep track of different types of ACCOUNTS (SAVINGS_ACCTS, CHECKING_ACCTS, ...)

Consider the BANK ER schema of Figure 7.21, and suppose that it is necessary to keep track of different types of ACCOUNTS (SAVINGS_ACCTS, CHECKING_ACCTS,
...) and LOANS (CAR_LOANS, HOME_LOANS, ...). Suppose that it is also desirable to keep track of each account's TRANSACTIONs (deposits, withdrawals, checks, ...) and each loan's PAYMENTs; both of these include the amount, date, time, ... Modify the BANK schema, using ER and EER concepts of specialization and generalization. State any assumptions you make about the additional requirements.

Step by Step Solution

★★★★★

3.28 Rating (160 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

ACCOUNT SAVING CHECKING LOA... View full answer

Question Has Been Solved by an Expert!

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

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

888-CS-DB (2314).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!

Map the BANK ER schema of Exercise 7.23 (shown in Figure 7.21) into a relational schema. Specify all primary keys and foreign keys. Repeat for the AIRLINE schema (Figure 7.20) of Exercise 7.19 and...

Consider the COMPANY ER schema of Figure 7.2. Think of what operations are needed for the entity types/classes in the schema. Do not consider constructor and destructor operations.

Consider the block diagram in Figure P3.21. (a) Verify that the transfer function is (b) Show that a state variable model is given by G(s) = Y(s, h,sta + ais + a 0 ao a y=[1 LE 0]x. Co FIGURE P3.21...

Consider the BANK ER schema in Figure 3.21, and suppose that it is necessary to keep track of different types of ACCOUNTS (SAVINGS_ACCTS, CHECKING_ACCTS, ) and LOANS (CAR_LOANS, HOME_LOANS, )....

Consider the BANK ER schema of Figure below and suppose that it is necessary to keep track of different types of ACCOUNTS (SAVINGS_ACCTS, CHECKING_ACCTS,...) and LOANS (CAR_LOANS, HOME_LOANS, ...)....

(EER) Extended - Entity - Relationship 1) (30 points) Consider the BANK ER diagram in Figure 1 and suppose that it is necessary to keep track of different types of ACCOUNTS (SAVINGS ACCTS,...

Consider the BANK ER schema of following figure, and suppose that it is necessary to keep track of different types of ACCOUNTS ( SAVINGS _ ACCTS, CHECKING _ ACCTS,.. ) and LOANS ( CAR _ LOANS, HOME _...

Bank Database Schema and Requirements Consider the following Bank ER Schema, and suppose that it is necessary to keep track of different types of ACCOUNTS ( SAVINGS _ ACCTS, CHECKING _ ACCTS, . . . )...

Refer to the information in QS 17-2. Use that information for Tide Corporation to determine the 2012 and 2013 common- size percents for cost of goods sold using net sales as the base. In QS 17-2, Use...

As of December 31, 2012, SPK Inc reported the following information on its balance sheet: Accounts receivable 900,000 Provision for doubtful accounts 54,000 (credit) During 2013, the company had the...

Laid-off workers who become entrepreneurs because they cannot find meaningful employment with another company are known as entrepreneurs by necessity. The Wall Street Journal reported that these...

A stock is now at $60. In a year its price will either be $75 or $45. (a) Assuming that the interest rate is r D 0:05 find the price of a put .60 S1/C. (b) How much stock 0 do we need to sell to...

What are the typical record-at-a-time operations for accessing a file? Which of these depend on the current file record?

What is the difference between a file organization and an access method?

Discuss the techniques for allocating file blocks on disk.

Jeff is under contract with ISU to teach Business Law classes. Another college in the area knows Jeff is under contract, however they approach jeff and offer him more money to breach the contract...

16 A 20-year, $1,000 par value bond has a 7% annual payment coupon. The bond currenthy sells for $880. If the yield to maturity remains at the current rate, what will the price be 10 years from now?...

Probability Distribution Question A die is rolled 2 times. Let x be the number of fours that occur. Represent the probability distribution function with a table and a graph. I don't know how to...