List the names of all relationship types

Assignment Help Basic Computer Science

Reference no: EM131054164

Consider the ER diagram shown in Figure 7.21 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 (non-weak) entity types in the ER diagram.

b. Is there a weak entity type? If so, give its name, partial key, and identifying relationship.

c. What constraints do the partial key and the identifying relationship of the weak entity type specify in this diagram?

d. List the names of all relationship types, and specify the (min, max) constraint on each participation of an entity type in a relationship type. Justify your choices.

e. List concisely the user requirements that led to this ER schema design.

f. Suppose that every customer must have at least one account but is restricted to at most two loans at a time, and that a bank branch cannot have more than 1,000 loans. How does this show up on the (min, max) constraints?

Reference no: EM131054164

Questions Cloud

State clearly any additional assumptions you make : State clearly any additional assumptions you make. Under what conditions would the relationship HAS_PHONE be redundant in this example?

Write an essay about payroll calculator system : Write an essay about given topic. Topic - Payroll Calculator System

What insights about alcohol use sexual engagement : Read the three the individual ‘stories from the path' in Chapter 6 (Carol-Hannah, pp. 159; Stephanie, pp. 166; Chelsea, pp. 179). How do the experiences of these students contrast or compare with your own experiences in college thus far? What insi..

Financial structure in percentages : You can get the financial structure you have today by looking at your "Annual Report". On the right hand side of the Balance Sheet, you will see your financial structure in percentages. To determine what sort of structure you want, you can ask thr..

List the names of all relationship types : List the names of all relationship types

Write reflection paper about event investing in your future : Write a reflection paper about the event Investing in Your Future. You just talk about hows the experience and what do you think. you can do some research online, but more talk about personal feeling.

What is the amount of the firms current assets : What is the amount of the firm's current assets? What is the amount of the firm's net income? What is the amount of the firm's total equity? What is the amount of the firm's long-term debt? What is the amount of the firm's total debt? What is the amo..

Observe the investment performance : Suppose you observe the investment performance of 800 portfolio managers and rank them by investment returns during the year. Sixteen percent of all managers are truly skilled, and therefore always fall in the top half, but the others fall in the ..

How they can be represented in an er schema diagram : how they can be represented in an ER schema diagram.

User Account

All Pages