Simplify Your Water Bill Format for Operations with airSlate SignNow

Water bill format for Operations

good day my name is Musa amidu I'm presenting on water bill generation and water supply management system database management system so without a Company Limited is the leading supply of water and water bill generation systems in Ghana the company was established in the year 1965 and is controlled by the ministry of Sanitation and Water Resources a company supplies water to all regions in Ghana and expects to be paid at the end of every month this database system is designed to have a record of the people that pay their bills and hence get access to water supply people who refuse to pay their water bills after 28 days would be disconnected from the water supply chain and would have their water restored after the pay or the adopts apart from water supply and water bill generation the company produces good drinking water for its customers moving to the operations the database should have a record of all entities and supplies water to have a record of all entities that do not have water supply but have paid for water supply asking if paid their bills that way to keep a record of people who have not paid their bills after 28 days and hence need their water to be disconnected ew should keep record of how much water an entity has used the amount to have a record of whether it's customers have received their bill after every month to have a record of all best pipes in the country somebody should keep record of illegal water Connections in the country and how much the person who's ewb should have a record of the profits made from the selling of drinking water did that be should have occurred to show locations that must have water supply and locations that will not have water supply due to some reasons so here by Enterprise rules include each consumer should receive water supply and water supply should be received by every consumer the consumer is either an illegal water connector or as a legal connector who Reports best pipes service charge is charged for every water bill and all water bills have service charged a few of our assumptions include all households have water connections meter readers deliver the water bills monthly water supply is reliable and Engineers have an idea of what type of pipes using particular areas moving on to my eer diagram strong entities here are consumer water supply water meter employee department and water bill so consumer must pay water bill those many-to-many relationship here so we had to decompose the table to get the consumer water bill a consumer purchases drinking water and drinking water is purchased by some consumers if you have a zero to many relation and a minute to one relation a consumer is either a legal connector or an illegal connector a consumer should receive water supply and water supply should be given to Consumers that was a mini mini -to-many relation here so we have to create a decomposed table called consumer water supply a water meter indicates the amount of water supply someone gets and water supply is determined by the water meter an employee must read water meters and water meters are read by employees an employee must belong to a department and the department has many employees a department generates the water bill and the service charge is foreign charging water bills here the service charge is constant because um we have one percent of the service charge for fire and then two percent for raw water and that is constant it doesn't change but here it doesn't change here but it depends on the amount of water consumer uses so if you use this 500 you need two percent of that 500 units will be charge as the service charge two like I said earlier my key attributes are water supply water meter employee Department water bill consumer then on key attributes include the service charge legal connector drinking water illegal conductor and the best pipes moving on to my logical database design speaking of water meter water meter is the table I created with meter ID as as primary key and has water units used previous reading current reading and water meter meter reader name as entities in the table water supply it's a table I created next and has connection ID as as primary key and meter ID Asus foreign key Department to Department ID access primary key employee with employee ID assist primary key and foreign key call Department ID consumer with house ID access primary key and meter ID as this foreign key we have water bill with account ID as its primary key meta ID as is foreign key as well as house ID as is foreign key the service charge with an account ID as is foreign key Liga connector with fname L name email contact and issue drinking water with pack speed use pack sold in a month the profits and the feedback illegal connector has area amounts on the fnml name and meter ID as a foreign key the best pipe has the type of pipe location manager name and manager contact and a two decomposed tables consumer water supply and consumer water bill consumer water supply has house ID and connection ID asses foreign Keys also has problem in it the um what the consumer water bill has a bill delayed and account ID house ideas as foreign keys so moving on to the actual code let's talk about the indexes the first index is was created to get details of how much a particular consumer is supposed to be and whether the consumer has paid or not the second index was created to know the location of a best pile and what type of pipe to bring in case the pipe is supposed to be replaced the next query is created to know whether the users use water supply commercially or personally and whether or not they have authorized water connections the next index talks about how after 28 days the water supply of a consumer is supposed to be cut so this is to ensure that the meter readers deliver the water bills promptly so moving on to my queries the first query displays the consumer's name check if the consumer has paid their bill and check to see if there was a build delay by the meter reader second query is to keep track of the service charge added to water bills the third query is to show the profits made from drinking water sales and the feedback they received the next query is to identify areas where illegal water connections are known for the following code is to show locations that must have water supply and locations that we don't have water supply for some reasons an example is maybe they're fixing a best pipe in that area so they have to shut down the mean water supply connection to fix the pipe antenna back on and so on the last queue is to check illegal connectors to check for illegal water connectors and the amount of money they owe thank you very much