By adding protected void add(Object o) {mArray.add(o);} to the ConstrainedArray class, the mArray field can be made private. Show how this would affect your IntListArray class and discuss the advantages of the change from protected to private. [5 marks] (c) The solutions in parts (a) and (b) both involve a get() method returning an Object reference. (i) Explain why this is bad practice. [1 mark] (ii) Propose an alternative solution for a constrained array of Integer or LinkedList objects (only) that addresses this issue. A grouping of regular numbers is a complete capability s : N N. The arrangement is recursive if and provided that s is processable. A limited succession of regular numbers is determined by a couple (l, x), where l N is the quantity of components, and x : [1, l] N is a capability that characterizes those components. The case 11l = 0 characterizes the invalid succession. a) In Verilog, what is the contrast between nonstop task and non-impeding task? // taken array of 1000 elements to get some significant time as small array sorting will get executed within small time interval int arr[] = { 675, 532, 903, 20, 112, 995, 277, 965, 472, 887, 485, 131, 380, 85, 494, 336, 145, 545, 204, 471, 232, 447, 882, 802, 525, 281, 564, 389, 323, 833, 445, 860, 369, 778, 784, 514, 612, 893, 257, 51, 333, 93, 283, 158, 59, 469, 144, 158, 96, 320, 481, 723, 977, 816, 413, 482, 44, 190, 851, 999, 593, 147, 211, 587, 446, 55, 964, 687 Avenue San Joaquin CA 93660 13 Road Bike Warehouse 4629 Gilbert Road Mesa AZ 85210 14 Gear Source 204 Hennepin Avenue Minneapolis MN 55412 15 Mountain Gear 32877 Bluegrass Court Louisville KE 402065. 6. SUPPLIER i. Supplier ID (Yes, No Duplicates) ii. Supplier Name iii. Street Address iv. City v. State vi. Zip code 7. Product i. Model Number (Yes, No Duplicates) ii. Product Category iii. Product Name iv. Purchase Cost v. Selling Price vi. Supplier ID (Yes, Duplicates OK) vii. Quantity on Hand viii. Reorder Level 8. CUSTOMER i. Customer ID (Yes, No Duplicates)ii. Last Name iii. First Name iv. Address v. City vi. State vii. Zip viii. Telephone 9. SALES i. Order Number (Yes, No Duplicates) ii. Customer ID (Yes, Duplicates OK) iii. Model Number (Yes, DuplicatesDate purchased 11. Draw an E-R Entity-Relationship diagram for the problem, making sure that you create the appropriate and number of relationships between the tables. Use the Relationship tool (icon in toolbar) in Access for this. All relationships must be of type 1:N.12. Construct the following 7 queries. Do not change or alter the tables or the data in the tables to construct any queries. a. a query that identifies the five most expensive bicycles, sorted in descending order of selling price. Also list the quantity on hand and the markup percentage of each bicycle. b. a query that returns all information about all customers named Smith, including home/personal data, and sales data. Remove duplicates from the list, so that if you sell more than 1 bicycle to John Smith, his name should appear only once. However if there are 2 distinct customers named John Smith, then BOTH instances should appear in the list. c. a query listing only the bicycles that are low in stock and need to be reordered. Also include supplier information for the buyer's use in reordering. d. A parameter query that will allow you to look up customers who have purchased a specific type of bicycle (road, leisure, children, etc.). The query will prompt users to input the Product Category. e. A parameter query that will let you look up the sales (customer name, model number and date sold, at a minimum) in a user-specified period of time (beginning and ending dates in day, month, year format). f. A query that returns the total number of each bike (model number) sold and the total dollar amount for each bike (model number) sold of all bikes across all dates in the database. g. A query that returns a total of the number of each bike model sold during a user-specified period of time (the beginning and ending dates to be provided by the user as in e above) and include the total sales dollar amount for each bike model sold during the same time period. 13. Successful and correct completion of items 1 through 9 will be worth approximately 91.67% of the grade for this project.