Question: is my answer correct?? BANk (code, Name, Addr) BANK_BRANCH(Addr, Branch_ho, code) Account (type, Acc_no, Balance, code, Brand Customer (Phone, Ssu, name, Addr) LOAN(Loan_no, Amount, Type,

is my answer correct??

BANk (code, Name, Addr) BANK_BRANCH(Addr, Branch_ho, code) Account (type, Acc_no, Balance, code, Brand Customer (Phone, Ssu, name, Addr) LOAN(Loan_no, Amount, Type, Brachnsicode) AC( ACC-no, SSN) LC (Loan_ho, Ssu) Convert the following ERD to a relational database schema. (NOTE: Use your hand writing to solve this homework)

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!

(d) (8pts) Use ACCOUNT as the superclass and apply specialization to create two subclasses: CHECK_ACCOUNT and CD_ACCOUNT. Use the notation in Lecture 4 to draw a EER diagram to display this...

Consider the ER diagram shown in Figure 3.22 for part of a BANK database. Each bank can have multiple branches, and each branch can have multiple accounts and loans. a. List the strong (nonweak)...

Apply appropriate rules to map the following ER schema to a relational schema. BANK Code Name Addr Phone BRANCHES ACCTS Acct_no Ssn N ACCOUNT M A_C N Balance N Name CUSTOMER Type BANK BRANCH Addr...

Map the following BANK ER schema into a relational schema. Specify all primary keys and foreign keys. Briefly discuss how you apply the mapping algorithm step by step to this problem. N BANK BRANCHES...

Use this ER diagram for this and the following questions. It is found in your textbook on page 99. N BANK BRANCHES BANK_BRANCH Code Name Addr Addr Branch_no ACCTS LOANS IN N. Acct_no Balance Loan no...

Q.1.Consider the ER diagram shown below for part of a BANK database. Map the ER diagram into a RELATIONAL SCHEMA. Specify all primary keys and foreign keys. Q.2.Use the relational schema shown below...

Entities and relationships with attributes 1. (10 marks) Given the ER diagram of the BANK database of Figure 3.22, answer the following questions with this diagram. Figure 3.22 An ER diagram for a...

can you please help me with C, D, E, F Thank you BANK BRANCHES BANK-BRANCH Code Name) ( Addr Adddr Barone ACCTS LOANS Balance Amount ACCOUNTType LOAN Type A-C L-C SSN Name Phone) CUSTOMER Addr 5 (a)...

1. Visit the ERDPlus web site and create your personal account. 2. Try to create the following ER diagrams N BANK BRANCHES BANK_BRANCH Code Name Addr Addr Branch no ACCTS LOANS N N Acct_no Balance...

4 . Map the following BANK ER diagram into a relational database schema ( in table representations ) . Specify all primary keys and foreign keys. BANK BRANCHES BANK _ BRANCH Bank _ Nama Addis Cosa...

Pr(A U B) = Pr(A) + Pr()Pr(B) = Pr(B) + Pr()Pr(A).

What could the negative industry growth rate for potato chips mean? Multiple Choice The product may be entering the decline stage of the product life cycle. The product may be entering the maturity...

Tamarisk Inc. reports the following incomes ( losses ) for both book and tax purposes: \ table [ [ Year , \ table [ [ Accounting Income / ] , [ ( Loss ) ] ] , \ table [ [ Tax ] , [ Rate ] ] ] , [ 2 0...

Cash is King! Good cash management is an essential job of the financial manager! You own a small auto sales business called King Kars. You stock up on inventory in February, April, June, and...

2. How do the various histories of the United States influence our communication with people from other countries?

5. When can contact between members of two cultures improve their attitudes toward each other and facilitate communication between them?

b. Are there any historical incidents of discrimination? If so, describe them.