numberOfPoolBalls(rows) [15pts]Pool balls are arranged in rows where the first row contains 1 pool ball and each row contains 1 more pool ball than the previous row. Thus, for example, 3 rows contain 6 total pool balls (1+2+3). With this in mind, write the function numberOfPoolBalls(rows) that takes a non-negative int value, the number of rows, and returns another int value, the number of pool balls in that number of full rows. For example, numberOfPoolBalls(3) returns 6. We will not limit our analysis to a "rack" of 15 balls. Rather, our pool table can contain an unlimited number of rows. Hint: you may want to briefly read about Triangular Numbers. Also, remember not to use loops!numberOfPoolBallRows(balls) [20pts]This problem is the inverse of the previous problem. Write the function numberOfPoolBallRows(balls) that takes a non-negative int number of pool balls, and returns the smallest int number of rows required for the given number of pool balls. Thus, numberOfPoolBallRows(6) returns 3. Note that if any balls must be in a row, then you count that row, and so numberOfPoolBallRows(7) returns 4 (since the 4th row must have a single ball in it). Hint: you may want to briefly read about Triangular Numbers, and also think about how this problem relates to the numberOfPoolBalls problem above.colorBlender(rgb1, rgb2, midpoints, n) [1 bonus pt]This problem implements a color blender, inspired by this tool. In particular, we will use it with integer RGB values (it also does hex values and RGB% values, but we will not use those modes). Note that RGB values contain 3 integers, each between 0 and 255, representing the amount of red, green, and blue respectively in the given color, where 255 is "entirely on" and 0 is "entirely off".For example, consider this case. Here, we are combining crimson (rgb(220, 20, 60)) and mint (rgb(189, 252, 201)), using 3 midpoints, to produce this palette (using our own numbering convention for the colors, starting from 0, as the tool does not number them):color0: rgb(220, 20, 60) color1: rgb(212, 78, 95) color2: rgb(205, 136, 131) color3: rgb(197, 194, 166) color4: rgb(189, 252, 201)There are 5 colors in the palette because the first color is crimson, the last color is mint, and the middle 3 colors are equally spaced between them.So we could ask: if we start with crimson and go to mint, with 3 midpoints, what is color #1? The answer then would be rgb(212, 78, 95).One last step: we need to represent these RGB values as a single integer. To do that, we'll use the first 3 digits for red, the next 3 for green, the last 3 for blue, all in base 10 (decimal, as you are accustomed to). Hence, we'll represent crimson as the integer 220020060, and mint as the integer 189252201.With all that in mind, write the function colorBlender(rgb1, rgb2, midpoints, n), which takes two integers representing colors encoded as just described, a non-negative integer number of midpoints, and a non-negative integer n, and returns the nth color in the palette that the tool creates between those two colors with that many midpoints. If n is out of range (too small or too large), return None.For example, following the case above: colorBlender(220020060, 189252201, 3, 1) returns 212078095Hints: RGB values must be ints, not floats. Also, remember to use roundHalfUp(n) instead of round(n) when calculating midpoint colors.4. findIntRootsOfCubic(a,b,c,d) [1 bonus pt]Write the function findIntRootsOfCubic(a,b,c,d) that takes the int or float coefficients a, b, c, d of a cubic equation of this form: y = ax3 + bx2 + cx + dYou are guaranteed the function has 3 real roots, and in fact that the roots are all integers. Your function should return these 3 roots in increasing order. How does a function return multiple values? Like so:return root1, root2, root3To get started, you'll want to read about Cardano's cubic formula here. Then, from that page, use this formula: x = {q + [q2 + (r-p2)3]1/2}1/3 + {q - [q2 + (r-p2)3]1/2}1/3 + pwhere:p = -b/(3a), q = p3 + (bc-3ad)/(6a2), r = c/(3a)

Follow the directions below. This assignment will count as a quiz or homework grade, and replace your lowest score. This is optional. Browse a dynamic website. While browsing it, think about what the basic table structure, column names, and other database details that involve the page. DELIVERABLE: URL and name of website.Tip: smaller e-commerce pages might be easier to define. Write out the Schema of what you think the database "underneath" the website looks like. Remember that a Schema is words, it shows the table name in all caps, the primary key in bold or underlined, and the foreign keys in italics. All other fields follow. DELIVERABLE: Schema in a TXT or DOC fileUsing this schema, create an ERD diagram showing the database. DELIVERABLE: Schema as a JPG or other image file. DO NOT SEND me the ERD file, just an image of it. Visit 5 pages/articles on the site, and then using your ERD diagram, write out what the SQL statement might be to generate that page. DELIVERABLE - URL of a page, and the SQL script for it.Please turn in deliverable for each step as a Word Document, PDF, and/or image file.

Please see attached documents for clarification on each report requirements: Complete the following steps for this assignment: 1. Create each of these reports and display them within the in the CapestraApp project Employee Information: This report was provided within the CapestraApp template. Modify it so that it has a consistent appearance with the other reports that you create. Customer Information: This report should show complete details for a specific customer. The customer is selected using a drop-down (sorted by first name). As soon as a customer is selected, complete details regarding the selected customer are displayed below the drop-down.  Order Information: This three-part report displays three tables: List of all customers. List showing details of all orders. List of all products and categories. Follow the example provided during this week to see roughly how the report might display and what code is necessary to create this report. Note that you cannot just copy and paste the example code: You should use it as a model for code that you write. Product Information: This report displays a list showing full details about all products in inventory including their names, descriptions, prices, categories, and quantities on hand. 2. While your application is running, take screen shots of each report: Do not capture your entire desktop—just capture the individual screens. Paste all screen shots into a single MS Word document. Your name should appear at the top of the MS Word document. Name your document, following this pattern: LastName_Week9.docx. 4. Create a .zip file containing your CapestraApp project. Before zipping your project, right-click the project and "clean" it. This greatly reduces the file size and speeds up the program's performance. Then close NetBeans. 5. Add the MS Word document with your screenshots to your .zip file.