List the strong entity types in the er diagram


Discussion Post: Database Systems

Part I

Create a discussion thread (with your name) and answer the following question(s):

Consider 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.

• List the strong (nonweak) entity types in the ER diagram.

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

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

• 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.

Part II

Create a discussion thread (with your name) and answer the following question(s):

Discuss the characteristics of relations that make them different from ordinary tables and files.

The response should include a reference list. Using one-inch margins, Times New Roman 12 pnt font, double-space and APA style of writing and citations.

Solution Preview :

Prepared by a verified Expert
Database Management System: List the strong entity types in the er diagram
Reference No:- TGS03123445

Now Priced at $25 (50% Discount)

Recommended (93%)

Rated (4.5/5)