Question: Construct a schema diagram for the bank database of Figure 2.18. Figure 2.18 branch(branch_name, branch_city, assets) customer (ID, customer_name, customer_street, customer_city) loan (loan_number, branch_name, amount)

Construct a schema diagram for the bank database of Figure 2.18.

Figure 2.18

branch(branch_name, branch_city, assets) customer (ID, customer_name, customer_street, customer_city) loan (loan_number, branch_name, amount)

branch(branch_name, branch_city, assets) customer (ID, customer_name, customer_street, customer_city) loan (loan_number, branch_name, amount) borrower (ID, loan_number) account (account number, branch_name, balance) depositor (ID, account_number)

Step by Step Solution

★★★★★

3.40 Rating (163 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

ID loan loannumber branchname amount borro... 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

Students Have Also Explored These Related Database System Concepts Questions!

Write an assertion for the bank database to ensure that the assets value for the Perryridge branch is equal to the sum of all the amounts lent by the Perryridge branch.

Figure 9.8 shows an ER schema for a database that may be used to keep track of transport ships and their locations for maritime authorities. Map this schema into a relational schema, and specify all...

Consider the bank database of Figure 2.18. Give an expression in the relational algebra for each of the following queries: a. Find each loan number with a loan amount greater than $10000. b. Find the...

Considering the schema below, provide the Relational Algebra for each of the following queries: Branch: ( branchName , branchCity, assets ) Customer: ( ID , customerName, customerStreet, customerCity...

Show me the steps to solve Database Schema: branch ( branch _ name, branch _ city, assets ) customer ( cust _ ID , customer _ name, customer _ street, customer _ city ) loan ( loan _ number, branch _...

Database Schema: branch ( branch_name , branch_city, assets ) customer ( cust_ID , customer_name, customer_street, customer_city ) loan ( loan_number , branch_name, amount ) borrower ( cust_ID ,...

Database Schema: branch ( branch _ name, branch _ city, assets ) customer ( cust _ ID , customer _ name, customer _ street, customer _ city ) loan ( loan _ number, branch _ name, amount ) borrower (...

Database Schema: branch ( branch_name , branch_city, assets ) customer ( cust_ID , customer_name, customer_street, customer_city ) loan ( loan_number , branch_name, amount ) borrower ( cust_ID ,...

This is Database relational algebra problem: 10. Find customer-ids who are both depositors as well as borrowers, not necessarily at the same branch Task-2: Consider the following schema of...

What is meant by the term contribution margin per unit of scarce resource?

What are the general steps for managing each work package within a specific project?

9 315 = 3 5 7252 = 2 3 7660 = 2 3 5 11 Use these facts to find the highest common factor of a 315 and 252 b 315 and 660 c 252 and 660

The writer Pearl S. Buck said that It is good to know our universe. What is new is only new to us. Explain what she might have meant by this and include sustainability in your answer.

Using the bank example, write relational-algebra queries to find the accounts held by more than two customers in the following ways: a. Using an aggregate function. b. Without using any aggregate...

Consider the relational database of Figure. Give a relational-algebra expression for each of the following queries: a. Find the company with the most employees. b. Find the company with the smallest...

List two reasons why we may choose to define a view.

Question 21 (3 points) Rishyendramoney's new project requires a net investment of $450,000. It has a profitability index of 1.25 based on the firm's 12 percent cost of capital. Determine the net...

16. In developing an appraisal of a site that has been contaminated, it is common to develop a highest and best use for the property. It is also to develop an appraisal for the property using an) to...

Normal probability distribution Assuming that the rates of return associated with a given asset investment are normally distributed; that the expected return, r, is 16.2%; and that the coefficient of...