Relational databases and digitalization | Computer Science homework help

Q1. Consider the given ER diagram for part of a BANK database (attached 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.

Instructions:  Your response should be 250-300 words. There must be at least one APA formatted reference (and APA in-text citation) to support the thoughts in the post as needed.  Do not use direct quotes, rather rephrase the author’s words and continue to use in-text citations.

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

Read Chapter 5 (The Relational Data Model and The Relational Database Constraints) in Textbook: Fundamentals of Database Systems by Ramez Elmasri and Shankant B. Navathe, 7th Edition, Pearson, 2016. ISBN: 10: 0-13-397077-9

Instructions:  Your response should be 250-300 words. There must be at least one APA formatted reference (and APA in-text citation) to support the thoughts in the post as needed.  Do not use direct quotes, rather rephrase the author’s words, and continue to use in-text citations.

Q3. Please review the article and define the various technologies that are emerging as noted in the article.  Note how these emerging technologies are impacting organizations and what organizations can to do to reduce the burden of digitalization.

The given article was focused on the Complexity of Information Systems Research in the Digital World.  Complexity is increasing as new technologies are emerging every day.  This complexity impacts human experiences.  Organizations are turning to digitally enabled solutions to assist with the emergence of digitalization. 

Benbya, H., Ning Nan, Tanriverdi, H., & Youngjin Yoo. (2020). Complexity and Information Systems Research in the Emerging Digital World. MIS Quarterly, 44(1), 1–17. https://eds.p.ebscohost.com/eds/detail/detail?vid=0&sid=29577b1a-19f2-4754-9978-cab695150d04%40redis&bdata=JkF1dGhUeXBlPXNoaWImc2l0ZT1lZHMtbGl2ZQ%3d%3d#AN=141995164&db=buh

The paper should meet the following requirements:

• 3 pages in length (not including title page or references)
• APA guidelines must be followed.  The paper must include a cover page, an introduction, a body with fully developed content, and a conclusion.
• A minimum of five peer-reviewed journal articles. Please be sure that journal articles are peer-reviewed and are published within the last five years.
• The writing should be clear and concise.  Headings should be used to transition thoughts.