Discussion 3
Man123Consider the ER diagram shown in Figure 3.22 for part of a BANK database (also below for reference). Each bank can have multiple branches, and each branch can have multiple accounts and loans.
(a) List the strong (nonweak) entity types in the ER diagram.
(b) Is there a weak entity type? If so, give its name, its partial key, and its 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.
- a year ago
- 10
other Questions(10)
- Fin 571 assignent seven math questions
- ENG 315 Assignment 2.3- Tonisk Only
- Uniform Crime Report
- week 2 dq 1 and 2- xoon only
- MGMT 303 Final Exam
- 1Q. What was the legal issue in the case? What did the Supreme Court decide?2Q. What things must be shown in order to achieve class certification in a class action law suit? What did the court say was lacking in the case?
- Accounting Tax Multiple Choice
- Marketing "For SKYESSAYS "
- Helpd Needed 0116151800
- Paper 1