BUILDING MATERIAL MANAGEMENT SYSTEM

The building material management system allows the user to keep a track of the raw material which is used to build a house. The system is capable enough to provide information about the raw material and the blueprint to be used while building a house irrespective of the size and area. This model represents how the data should flow in the system while maintaining the other entities and attributes related to the material management system. This system is maintained by the admin, who is solely responsible for the smooth running of this system without any error. The entities and their attributes are defined below:

1. Admin:

Admin is the head identity, who is the administrator of the whole system. He has the access to manage the accounts of every user who are entitled in the system. If the workload increases, the management itself provides the admin power to more than one person. This entity separates the account of each admin so that they can do their work more regularly. The admin can edit or delete the accounts of other users from his account because of the power provided to him by the management. The related attributes are defined below:

• Admin_ID: The head entity is attest with Identity Number provided by the system in random format.
• Name: The name of each admin need to be saved in the attribute, if there are more than one admin authorized by the management.
• Contact No.: The head entities contact number should be saved in the attribute to connect him whenever needed.
• Email Address:  In order to have an official conversation with the admin, email address need to be written down in this attribute.
• Shift: More than one admin work in a system therefore this attribute contains the shift in which a particular admin work.

   2. Godown:

The raw material used to build a house like cement, sand and bricks are to be stored in godowns of the owners.  the system manage the details of each godown along with the quantity of the material available in a particular godown so that the system can alert the admin to purchase more raw material for stock if he finds out any shortage in the godown. The godowns are available based on the different size and locality to store more units of the raw material. The related attributes are defined below:

• Godown_ID: Each Godown of the owner attested with an identity number provided by the system for bifurcation.
• Name: The name of each godown is saved in this attribute as per the name written in the documents.
• Size: The size of every Godown need to be measured and saved in the attribute to check the available stock and the shortage.
• Sand: This attribute holds the information about the amount of sand available in particular godown.
• Cement: The pile of cement is calculated and saved in this attribute to see if there is any shortage of cement or not.
• Bricks:  The number of bricks along with per unit price is saved in this attribute to give an idea to the customer.

   3. Transporter:

The customer books for raw material from the Godown with the help of the system there after this request will be send to the Transporter who is responsible for the transport of the raw material to the address of the customer. This entity holds the detail of each Transporter who is attached with the system. Every Transporter create an account in the system through which we will get the information about how many quantities he need to carry in his vehicle and at what address he needs to go. He is in charge of the safely delivery of raw material at the residence of the customer. The related attributes are defined below:

• Transporter_ID: There are so many Transporters who are attached to the system, therefore the system provides an Identity Number to each Transporter to separate their details.
• Name: Every Transporter official name should be saved in this attribute according to the document and the license he has provided to the company.
• Contact No.: The contact number of transporter is saved in this attribute to connect him by the management whenever they get a new booking by the customer.
• Time of Loading: It is very important to have information about the time of loading of the raw material so that in order to inform the customer also.
• Vehicle No.: The authorized vehicle number of each vehicle used by the Transporter need to be saved along with the details of the Transporter.
• Vehicle Size: The vehicle which is used by the Transporter need to be thoroughly checked and calculated its size.

   4. Cement:

The important aspect of the raw material is cement. It comes in various types and of various brands which can be purchased by the customer as per his choice. The cement racks are managed by the admin in the godown and delivered to the customer by the Transporter according to the booking done by the customer. This entity that’s the detail about the available of the cement racks and how many racks are shortages is going through in each godown. The system will give an alert to the admin whenever the shortage of lower than the limit set by the management. The attributes related to this entity are defined below:

• Cement_ID: An Identity Number is attached with the pile of the cement available in the godown by the management.
• Brand: This attributes provide the information about the type of brand which is in demand by the customer.
• Price: The Per unit price of the cement rack is saved in this attribute to give an idea to the customer whenever he books cement racks.
• Mfg / Exp Date:  It is necessary to save the information about the manufacturing and the expiry date of the cement to get the values of cement racks.

   5. Bricks:

The bricks are used to make the basic structure of building therefore it is an important aspect to be considered by the customer and he always book bricks more than needed for safety purpose. This entity holds the information about the available bricks in the godown in order to keep safe from the shortage if it happens during the peak season. The system send alert to the admin if there is any shortage of brick in the godown. It is also helpful for wrong use of the bricks and keeps track of the same. The related attributes are defined below:

• Brick_ID: The system attaches an identity with the bricks for more safety purpose for the management.
• Brand: The bricks come in various brand therefore it is necessary to save the detail of each brand from which the management has ordered the bricks.
• Price: The price of each unit of brick suggested by the trader from whom the bricks are purchased by the owner of the godowns.
• Size: The brick come in various sizes according to the need of customer therefore it is necessary to save the information about each brick type.

    6. Sand:

It is also necessary to hold the detail about the amount of sand available in the godown as it is very important compound to be used for building houses, because this sand is to be used with cement and bricks to build a house. These entities provide information about the availability of site and the shortage if there is any in the godown. The management will call the trader to provide more sand. The customer book sand depending upon the size of truck which is needed to him. The related attributes are defined below:

• Sand_ID: The sand is purchased from different traders therefore the quality of sand is different and the system attest an Identity Number to each sand purchased  from the traders.
• Price: It is necessary to hold the detail about the price at which the owner has purchased sand from different traders according to the type of the sand and quality.
• Availability: This attribute holds the information about the stock of sand available in the godown to be booked by the customer for building his house.

    7. Customer:

The most important aspect of the system is the customer who books the raw material from the owner with the help of the system. This entity holds information about the customer account which they have created in the system through which they can book the raw material and also pay the price. This entity holds different account of the customer two separate there information and Secure their account along with showing them the booked history and they can also track raw material which will be transported by the Transporter. The related attributes are defined below:

• Customer_ID: The system update on Identity Number with each customer to separate their account and its information.
• Name: Each customer name should be saved in this attitude for verification purposes.
• Contact No.: Customer contact number is saved in this attribute to connect them by the Transporter for delivery of raw material.
• Email Address: Management provide information to the customer on the email address provided by the customer.
• Residence: It is necessary to provide exact address of the customer so that the Transporter reaches at the residence of the customer.
• Payment:  System provides an opportunity to the customer to pay the price through the system.
• Booking Details: Attribute also hold the information about the booking done by the customer of various raw materials.