There is a list of 1000000 usernames stored in a zero-based string array. The us

There is a list of 1000000 usernames stored in a zero-based string array. The usernames are in alphabetic order. The programming language you are using has no automated method for searching arrays to find matches. Language functions at your disposal are:Lbound(array) Gets the lowest index of an arrayUbound(array)Gets the highest index of an arrayRound(decimal)Rounds up or down decimal valuesStrcomp(string1 string2)Returns 0 if a match is foundReturns 1 if string2 is lower in the alphabet than string1Returns -1 if string2 is higher in the alphabet that string1What type of method would you use to search for a specific username? If you can write out some sample code.Question 2The following information is contained in a spreadsheet and is used by a computer retailer to determine the products that are in-stock at their various stores.StoreCityProductPriceQuantityVirginia Outlet #1ViennaHypertext Builder12.0030Washington Outlet #1RedmondHypertext Builder12.0030Virginia Outlet #1ViennaWindows XP Home199.0020Washington Outlet #1RedmondWindows XP Home199.0060Illinois Outlet #44ChicagoWindows XP Home199.0080Washington Outlet #1RedmondExtera Design Suite222.00130Create a database table schema that expresses the above information in a normalized fashion. Question 3There are two database tables one that stores customers and one that stores addresses. They have the following structurestCustomerCustomer_IDintPrimary KeyFirst_Namevarchar(255)Last_Namevarchar(255)Emailvarchar(255)tCustomer_AddressAddress_IDintPrimary KeyAddress1varchar(255)Address2varchar(255)Address3varchar(255)Statevarchar(4)Cityvarchar(255)Zipvarchar(16)Customer_IDintForeign Key: tCustomer.Customer_IDWrite one query that will return the following information about each customer.First Name Last NameAddress 1 Address 2 Address 3 State City ZipA customer should appear in the results even if he/she does not have an address in the database. In the event a customer has multiple addresses it is acceptable that their name shows up in the results more than once.Question 4A candy company sells candy bars and utilizes software to gauge a variety of factors related to the product. What they need is a class that:Exposes the following properties:Weight (in ounces)Price (in dollars)Fat ContentCaloriesTaste Ranking(1 to 10 1 = tastes like health food 10 = tastes awesome)Provides the following functions:A function that returns fat content per ounceA function that returns calories per ounceA function that returns price per ounceUsing Java/C#/VB/VB.NET create a class that delivers the above and demonstrate how it might be utilized in surrounding code.Bonus QuestionImplement a new class that can contain multiple instances of your candy bar class from the previous page. In this new class provide functions for calculating average price fat content and calories across multiple candy bars.