Barangay Information System ER Diagram | Entity Relationship Diagrams

Barangay Information System Entity Relationship Diagram

Hi there Itsourcecoders! Today I will give you ideas about the Barangay Information System Entity Relationship Diagram (ERD) for 2021. This schema will also give you deep understanding about Barangay Information system database project ER Diagrams tables. This will teach you in managing barangay information database as well as the relationships of tables in barangay information system project database design.

This ER Diagram for Barangay Information System project with table will also give you the idea on how to make a database design for a Barangay Information system with ERDtables, and schema.

The idea presented here can be used for your Barangay Information system final year project. You can enhance the ER diagram for a system in this article to meet your desired system requirements.

What are included in this Entity Relationship Diagram for Barangay Information System Database projects 2021?

  • Barangay Information system Description with Features
  • Barangay Information system database tables
  • Schema diagram for Barangay Information system
  • Database Diagram for Barangay Information System

Barangay Information System ER Diagram Description

This Barangay Information system database was made based on barangay information management requirements. The system can encodes the residents’ information upon their residency. The admin can have access to the residents’ status as well as their transactions. They can handle the data needed in managing information and records the request made by the residents.

The features included in the system ER diagram were the security and monitoring of the barangay information status. These features were also listed and recorded in reports that served as the history of transactions done in the system.

ER Diagram For Barangay Information System With Tables : Features

Time needed: 5 minutes.

Here’s the database design for Barangay Information system with ER Diagram 2021 that includes Tables, Schema, PDF, etc.

  • Barangay Information Management

    This means that the system can handle and secure the barangay transactions including the residents’ information.

  • Residents’ Information Management

    This feature plays a big role for the system because this gathers the important information of the
    barangay residents. These information were used for determining the transactions made by the certain barangay residents.

  • Manage Barangay Transaction

    This system stores the transactions that were made in the barangay, These transactions are essential for handling barangay information because this transactions includes releasing of barangay certificates and other proof of residency in the barangay.

  • Transaction and Reports Management

    This feature will store the transactions made including their information and the reports every transactions in the corresponding timetables.

Barangay Information System Entity Relationship Diagram Tables

These tables below provide the complete database tables details such as Field NameDescriptionsdata typescharacter lengths.

Table Name: Resisdent’s Information

FieldDescriptionTypeLength
info_ID (PK)Information IDInt11
nameResidents’ NameVarchar255
ageResidents’ AgeInt11
genderResidents’ GenderVarchar255
birthdateResidents’ BirthdateDate
contact_addressResidents’ Contact AddressInt11
statusResidents’ StatusVarchar255

Table Name: Barangay Information

FieldDescriptionTypebarangay
barangay_ID (PK)Barangay IDInt11
barangay_nameBarangay NameVarchar255
city/municipalityCity/MunicipalityVarchar255
provinceProvinceVarchar255

Table Name: Barangay Transaction

FieldDescriptionTypeLength
trans_ID (PK)Transaction IDInt11
trans_nameTransaction NameVarchar30
info_ID (FK)Last NameVarchar30
barangay_ID (FK)AddressText

Table Name: Barangay Certification

FieldDescriptionTypeLength
bar_cert_ID (PK)Barangay Certification IDInt11
info_ID (FK)Information IDInt11
dateDate of CertificationDate

Table Name: Health Certification

FieldDescriptionTypeLength
health_cert_ID (PK)Health Certification IDInt11
info_ID (FK)Information IDInt11
health_rec_IDHealth Record IDInt11
dateInformation IDTime

Table Name: Health Records

FieldDescriptionTypeLength
health_rec_ID (PK)Health Record IDInt11
info_ID (FK)Information IDInt11
health_status Health StatusVarchar255
health_complainHealth ComplainVarchar255
medicine_claimTransaction DateVarchar255

Entity Relationship Diagram for Barangay Information System

ER Diagram of Barangay Information System shows the system entity relationships in each entity and their supposed functions in each relationship.

Sample ER Diagram for Barangay Information System Project

Barangay Information System ER Diagram
Barangay Information System ER Diagram

Based on the image above, the ER diagram for this System is the entity of the Barangay Information system database, which is presented by tables;

The tables are made to meet the required specification of the system and provide much more specific details of each entity within the system.

Conclusion

So that completes our discussion fellas! And I hope that this schema about ER Diagram For Barangay Information System Database Design 2021 will help you a lot.

Now let me ask you something. What have you learned through the discussion?

May this article help you with your projects in the future!

If you have inquiries or suggestions about Entity Relationship Diagram (ERD) for Barangay Information System just leave us your comments below.

Keep us updated and Good day!

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.