GAS BOOKING MANAGEMENT SYSTEM

The Entity relation model programmed to show the data which is interlinking within the system therefore this model is most important with all aspect. There are certain other explanations it can be considered through the online gas agency model because it shows how the different type of entities along with their attributes holding the crucial information about the actress which is helpful and providing sustainable efficacy. the system help the customer to book the cylinder online from their home now they don’t need to visit the agency manually the work can be done through online mode by the help of the system. The entities and their relative attributes are defined below:

   1. Admin:

The gas agency system is sustained after the automated process. The admin is the head entity who provides Full support to the system and makes it error free by holding all the data in a synchronized manner within the system database. Management provide more than one admin  the authority to sustain the system therefore this entity provide separate accounts each  admin person where they can control the system and the accounts of other actors who are enrolled into the system. The attributes of this entity had discussed below:

• Admin_ID: An identity number made up of 14 digits is provided to each admin account which is unique in nature and helps the admin login into account.
• Name: The name of each admin after verification is saved in this attribute which will be helpful in logging into their account.
• Contact No.: Admin is the identity which can be connected at any point of time through their contact number which is saved in this attribute.
• Email Address: The official conversation with the admin and also the sharing of documents through online mode is done with the help of the email address.
• Gender: The gender of each admin is defined in this attribute for providing equal employment opportunities to them.

      2. Employees:

The system is managed by the employees therefore it is necessary to take care of each employee. This system is helpful in providing solution to the Employees daily work while automating their work. the system also possess the accounts of each employee in which the employees can save their crucial information along with the daily work they do while handling the customers also. They can even send a brief report to the admin providing the work they have done in a particular period. The related attributes are defined below:

• Employee_ID: Each employee will be provided with an identity number which define their account as well as their information into the database.
• Name: More than one employee work in the organization there for their names which are official should be written in this attribute.
• Contact No.: The employees can be connected by the admin or the customer if they have any query regarding any problem they are facing.
• Email Address: Official email address of employees saved in this attribute for conversation and exchange of documents.
• Designation: Employees are designated on various positions according to their skill set and their experience decided by the management.

       3. Gas Agency:

The system is capable enough to provide services to more than one Gas Agency at a single time which will benefit the customer by choosing the gas agency through the system and compare the prices of the gas cylinder according to the latest rate charges and how far the gas agency from the customer house is. This will also help the gas agency and maintaining good relations with the customer because the customer can pay the price of cylinder through online mode and even provide the rating to each gas agency. They have their separate accounts in this entity in which the whole information about the gas agency is created by them. The related attributes are defined below:

• Agency_ID: Unique Identity Number is attached with each gas agency by the system to bifurcate their information.
• Agency Name: The register name of each Gas Agency which is also written in their documents is saved in this attribute.
• No: each gas agency is provided with unique registration number provided by the regulation authority of the city.

Contact No.:  The official contact number is provided in this attribute through which the customer can raise their query with the gas agency.

• Email Address: The customer can even send an email to the gas agency regarding any issue which he is facing.

       4. Cylinder:

The Gas Agencies provide gas cylinders to the consumers at a reasonable cost which is estimated by the government. in the Agencies provide cylinders in different types according to the weight and how the cylinder should be used for example commercial or domestic as per the choice of the customer it will also affect the rate of each cylinder according to the type of cylinder. The cylinders are to be made which will be safe to use by the people. This entity holds the information of each cylinder type and customer who are booking that cylinder by paying the charges through online mode. The related attributes are defined below:

• Type: The type of the cylinder like commercial or domestic defined in this attribute for clarity.
• Weight:  the cylinder is to be provided by the agency in different weights according to the choice of the customer.
• Date of Mfg: each cylinder is concerned with the date of manufacturing to provide the information to the customer.
• Cylinder_ID: Identity Number which is also known as serial number is provided and written in each cylinder which is to be delivered at the customer address.
• Amount: The charges of each customer are changes frequently as per the notice of the government which is to be showcase to the customer when he books the cylinder for use.

       5. Booking:

The cylinders are booked by the customers as per their need through the system. there are many customer who book the cylinder simultaneously at the same time therefore the system is capable enough to sustain each customers booking while making different catalogues for each booking containing the booking reference and customers detail. This entity safeguards the information of each booking while making different account for each one. The customer can view this booking but he cannot edit the information after placing the booking order for the cylinder. The related attributes of this entity are defined below:

• Booking_ID: The system generates an identity number which is attached with each booking as a reference for the customer.
• Customer_ID:  The cylinders are booked by the customer therefore while placing booking it also contains the customer ID.
• Customer Name:  This attributes gold the name of each customer to book the cylinder for their personal use.
• Cylinder No.: Each customer is provided with a certain number of cylinders in a particular year which is saved in this attribute.
• Date: This attribute holds the information of the date of booking done by the customer.
• Status: the status of booking of the cylinder done by the customer is shown through this attribute.

      6. Customer:

There are many customers who take the services of the agencies. This creates the separate account in the system and thereafter the place the order of booking a cylinder for their domestic use and also they can book cylinder for commercial purpose also. The customer can edit their personal information in the system in which we can also see the current update about the booking of a cylinder. He can pay for the price of the cylinder through the system by online mode. The customer can also raise a query regarding any issue with spaces while using the system through his account. The related attributes are defined below:

• Customer_ID: While creating the account, the system provides an identity number to each customer.
• Name: The customer feed documents while creating the account in which his official name is written in this attribute.
• Contact No.: The contact number of each customer is used in this attribute to connect him by the agency if needed.
• Email Address:  Customer also provide his email address in which he can get the Alert about the booking he has done.
• Residence:  The cylinder is to be delivered at the permanent address of the customer therefore it needs to be saved in this attribute.
• Of Cylinders: This attribute holds the information about the number of cylinder a customer has taken in a particular year.
• Payment: The system provides an opportunity to the customer so that he can pay the price of the cylinder through online mode while booking.