A company sells stock metal and we need an on-line ordering system. The stock comprises bars of various metals in various cross-sectional forms. The cost of a length of material depends on the weight and the material. Currently bars are sold in th e following metals:>
| Metal | Specific weight in Kg/cubic m | price per Kilo in £ |
|---|---|---|
| aluminum | 2563 | 90 |
| brass | 8394 | 45 |
| copper | 7209 | 60 |
| stainless steel | 7353 | 120 |
The metal bars have the following cross-sections, and the formula for computing their cross-sectional area are given
| Shape | area formula | |
|---|---|---|
| square bar | a*a | where a is the width of the bar |
| rectangular bar | a*b | where a is the width, b the height |
| round bar | Pi*(d*d)/4 | where d is the diameter, Pi is 3.14159 |
| hexagonal bar | 2.598*a*a | where a is the length of an edge |
| cylinder | Pi*b*(D-b)/4 | where D is the outer diameter, b the wall width |
A product is a length of a metal in a specific form - eg. 6m long bars 10mm square. A web interface is required to allow a user to place an order, comprising several items. As a first step in developing this system, develop a 3 tier system using a web browser and Oracle 9i to allow the user to choose a product and a number of units. The system will then cost the item, reporting the total weight and cost.