IT APPLICATIONS TO ELECTRIC POWER

1. IT APPLICATIONS TO ELECTRIC POWER PROJECT GUIDE : DR NDR SARMA GROUP - 10 PROJECT MEMBERS ABHISHEK DIXIT, ANUBHAV AGARWAL, E. GIRISH, SANDEEP CHANDNA

2. PROJECT • TITLE : DATABASE FOR ELECTRICAL DISTRIBUTION NETWORK • The system will store all the required information related to a Distribution system. • Through this system, we can track the distribution of electricity till the consumer level.

3. WORK DONE • DATABASE DESIGN • Design of relation schemas, • GRAPHICAL USER INTERFACE • Interface for Administrator • View the information • Modify the information • Interface for General User • View the information

4. Menu Form

5. Authentication Form

6. Administrator Form

7. User Form

8. View Data Form

9. Modify Data Form

10. Modify Data Form

11. Example of Schemas • create table substation ( substation_id varchar(10) not null, type varchar(20), location varchar(20), primary key(substation_id) ); • create table pole ( pole_id varchar(10) not null, address varchar(20), transformer_id varchar(10), primary key(pole_id), foreign key(transformer_id) references transformer );

12. Database Snapshot

13. FUTURE WORK • To provide a facility where the user can view detailed information related to each of the components. • A module for checking the validity of data for all the fields to aid data modification.

14. Work Distribution • Database design • Abhishek Dixit • E. Girish • Graphical User Interface design • Anubhav Agarwal • Sandeep Chandna • Implementation • Complete Team

15. THANK YOU 