Due: 16/06/2020

Time:11.55pm

Database Business process Discussion

case study

In this case study, we will attempt to design a database that will be used by the sub-contractors when making their claims. In particular, we will look at designing a database to be used by a sub-contractor in the business of drainage of rural areas. In an attempt to make sure that the drainage of rural areas is up to standard and safe, the government gives out contracts to companies that do earthworks. These companies are responsible for cleaning the old drains and digging of new drains. In addition to this, the contractors are required to build and maintain structures, such as roads, flood (flap) gates, and sea walls. Each contract is typically divided into quarters. Each quarter lasts three months with the first quarter starting in January. The contractors will be given a set of jobs, called Bills, to do in each quarter after a contractor finishes some of the jobs he is required to make a claim. This claim would show how much work was done and the total amount spent by the contractor. The claim is printed out, and a hardcopy is submitted to the Principal Contractor. In our case, the Principal Contractor could either be a government department or a private company. To understand each claim, we need to look at the structure of a contract. Contract A contract has a number, description, division (northern, eastern, etc.), and district (Navua, Rewa, etc.). Each contract has a set of Bills. A Bill is basically the type of job. For example, gravelling of roads is one type of job, and digging of new drains is another. Therefore, we will have a Bill for Gravelling and another Bill for Digging New Drains. Each Bill has a number and a description. Furthermore, each Bill is divided into Items. For example, assume that BILL 1 is Gravelling of Roads. Under BILL 1 there could be ITEM 1 Gravelling of new road and ITEM 2 Gravelling of the existing road. Each Item has a number, description, unit of measurement [LM (linear meters for distance), M3 (Cubic Meters for volume), etc.], Rate (in Fiji dollars; this is rate per unit), and Quantity (total contract quantity that must be completed by the contractor). Each contract has its own set of Bills and Items.

Question:

Discuss the business processes explained in the case study in Detail.