Database

Scenario: In Oman, the Oman Water and Wastewater Services Company bills its clients at various rates per gallon depending on use (Gallons). The total consumption usage * 0.002 (rate per unit) is used to calculate customer bills for residential customers, while the total consumption usage 0.0035 is used to calculate customer bills for commercial customers (rate per unit). Keep in mind that when a consumer consumes more units, the charge per unit increases. of 16 The Oman Water and Wastewater Services Company has asked you to create an interactive system (NonGraphical User Interface) to calculate the water bills of its consumers. Allow the user to input the bill number, the kind of customer, and the total amount used (in gallons) on the client side. The client will then forward the type of customer and total consumption usage (in gallons). Assume that number 1 represents the residential customer, whereas number 2 represents the commercial customer. The server will choose the tariff rate to use, calculate the bill, and then transmit the bill and the tariff rate used back to the client after receiving the kind of customer and the total consumption usage (in gallons) from the client. The client must display the bill as soon as they are received, and the tariff rate applied. Implement the lava program with the option of the server connecting to a database for answering user queries. The specification of your program should be as follow. Q1: Create a database with a table with appropriate fields and properties per the scenario. Include records for at least 10 employees with attributes such as Bill Number, Customer Type, and Tariff Rate. Provide screenshot(s) of the process of creating the database including the database server role together with explanations of the steps taken to complete the task