3. Please further expand the function you implemented in (2) to allow the printing of the...

Transcribed Image Text:

3. Please further expand the function you implemented in (2) to allow the printing of the number of each unique "leaf part" in a sub-parts-structure tree as the example shown below: (20 points) P3 P6 378 P7 32 9 P5 3 P6 2 P1 P3 9 3 P5 3 P6 P2 P4 8 P7 = In this example, given the part 'P1' and its sub-parts-structure tree, there are 2*9*3+4*3*9*3 = 378 'P6' parts and 4*1*8=32 'P7' parts. Therefore, given input value 'P1', the function should print out the following (you need to create a table with the data above to test your code): 4. Implement the above two functions in PL/PGSQL. (22 points) See Appendix for PL/PGSQL tutorial. 5. Write a Java Program to simulate an interactive SQL interface like psql. It should allow the user to query and update the tables in the database. Make sure your program prints out the query result (with column headings) or the update status (e.g., the number of rows deleted/updated/inserted) (10 points) 6. (Bonus) Write a Java program to simulate a student information query interface where input can be provided for one or more of the following fields: student name, and/or student number, and/or DoB. Assume information about students are stored in a table Students(Snumber, Sname, DoB). The output should be all the qualified student records. A graphical user interface is NOT required. (8 points, no partial credits will be awarded. Hint: Dynamic SQL) 3. Please further expand the function you implemented in (2) to allow the printing of the number of each unique "leaf part" in a sub-parts-structure tree as the example shown below: (20 points) P3 P6 378 P7 32 9 P5 3 P6 2 P1 P3 9 3 P5 3 P6 P2 P4 8 P7 = In this example, given the part 'P1' and its sub-parts-structure tree, there are 2*9*3+4*3*9*3 = 378 'P6' parts and 4*1*8=32 'P7' parts. Therefore, given input value 'P1', the function should print out the following (you need to create a table with the data above to test your code): 4. Implement the above two functions in PL/PGSQL. (22 points) See Appendix for PL/PGSQL tutorial. 5. Write a Java Program to simulate an interactive SQL interface like psql. It should allow the user to query and update the tables in the database. Make sure your program prints out the query result (with column headings) or the update status (e.g., the number of rows deleted/updated/inserted) (10 points) 6. (Bonus) Write a Java program to simulate a student information query interface where input can be provided for one or more of the following fields: student name, and/or student number, and/or DoB. Assume information about students are stored in a table Students(Snumber, Sname, DoB). The output should be all the qualified student records. A graphical user interface is NOT required. (8 points, no partial credits will be awarded. Hint: Dynamic SQL)

Answer rating: 100% (QA)

To further expand the function from 2 to count the number of each unique leaf part in a subpartsstructure tree you can modify the function to store the counts of each part in a dictionary or map Heres ... View the full answer