Programming challenge description: ESG Issuer Data is of the form Issuer | Parent | ESG Rating A54365 | B34454 | AA B34454 | C34563 | A D45747 | B34454 | B E36547 | D45747 | AAA G34657| D45747 CCC H84464 | C34563 | BB 176474 H84464 AA C34563 | | BBB F34654 | | BB J74576| K46565 | C K46565| L54334 | 176474 | AA H84464 | L54334 BB Asumptiona that can be made 1.asked to find a min or max rating given an luer, conslder all the lesers he path from the given issuer to the utimate parent 2. Rating order AAAAAPAPM00 D0 Your assignment Come up with a Deta Structure to hold this type of data Wite anlgorthm to check if the relations above are cycle in nature. (Convert the Data Structure to a directed one assuming the direction is from the Issuer to Its parent) Find the Issuer with max rating Enput The issuer table, with respective columns t Parent esatingearated by

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
icon
Concept explainers
Question
Java
10:39
1 Search
Adobe Scan Jan 14, 2022
Programming challenge description:
ESG Issuer Data is of the form
Issuer | Parent | ESG Rating
A54365 B34454 AA
B34454 C34563 | A
D45747
B34454 B
E36547
D45747 | AAA
G34657| D45747 | CCC
H84464 | C34563 | BB
176474| H84464 AA
C34563 |
| BBB
F34654
| BB
J74576 | K46565 | C
K46565|
| cc
L54334| I76474
AA
H84464| L54334 | BB
Asumptions that can be made
1.7asked to find a min or max rating
given an lasuer, consider all the iesuers
Inhe path from the glven isuer to the
utimate parent
2. Rating order AAA AAA 8 > n0
COC CC >
Your assignment
Come up with a Deta Structure to hold
this type of deta.
Write an algorthm to check If the
relations above are cyclic in nature.
(Convert the Data Structure to .
directed one assuming the direction is
from the Issuer to its parent) Find the
Issuer with max rating
Irput
The issuer table, with respective columns:
EParent ating separated by
Share
Modify
Text actions
Save contact
More
Transcribed Image Text:10:39 1 Search Adobe Scan Jan 14, 2022 Programming challenge description: ESG Issuer Data is of the form Issuer | Parent | ESG Rating A54365 B34454 AA B34454 C34563 | A D45747 B34454 B E36547 D45747 | AAA G34657| D45747 | CCC H84464 | C34563 | BB 176474| H84464 AA C34563 | | BBB F34654 | BB J74576 | K46565 | C K46565| | cc L54334| I76474 AA H84464| L54334 | BB Asumptions that can be made 1.7asked to find a min or max rating given an lasuer, consider all the iesuers Inhe path from the glven isuer to the utimate parent 2. Rating order AAA AAA 8 > n0 COC CC > Your assignment Come up with a Deta Structure to hold this type of deta. Write an algorthm to check If the relations above are cyclic in nature. (Convert the Data Structure to . directed one assuming the direction is from the Issuer to its parent) Find the Issuer with max rating Irput The issuer table, with respective columns: EParent ating separated by Share Modify Text actions Save contact More
Test 2
Test Input B
A54365|B34454|AA
B34454 |C34563|A
D45747|B34454|B
E36547 |D45747|AAA
G34657|D45747|CCC
H84464|C34563|BB
176474|H84464|AA
C34563||BBB
F34654||BB
J74576|K46565|C
K46565||CC
L54334|176474|AA
H84464|L54334|BB
Expected Output B
cyclic
A54365
AA
Transcribed Image Text:Test 2 Test Input B A54365|B34454|AA B34454 |C34563|A D45747|B34454|B E36547 |D45747|AAA G34657|D45747|CCC H84464|C34563|BB 176474|H84464|AA C34563||BBB F34654||BB J74576|K46565|C K46565||CC L54334|176474|AA H84464|L54334|BB Expected Output B cyclic A54365 AA
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 6 steps with 5 images

Blurred answer
Knowledge Booster
Query Syntax
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education