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 ERD, tables, 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 Name, Descriptions, data types, character lengths.

Table Name: Resisdent’s Information

Field	Description	Type	Length
info_ID (PK)	Information ID	Int	11
name	Residents’ Name	Varchar	255
age	Residents’ Age	Int	11
gender	Residents’ Gender	Varchar	255
birthdate	Residents’ Birthdate	Date
contact_address	Residents’ Contact Address	Int	11
status	Residents’ Status	Varchar	255

Table Name: Barangay Information

Field	Description	Type	barangay
barangay_ID (PK)	Barangay ID	Int	11
barangay_name	Barangay Name	Varchar	255
city/municipality	City/Municipality	Varchar	255
province	Province	Varchar	255

Table Name: Barangay Transaction

Field	Description	Type	Length
trans_ID (PK)	Transaction ID	Int	11
trans_name	Transaction Name	Varchar	30
info_ID (FK)	Last Name	Varchar	30
barangay_ID (FK)	Address	Text

Table Name: Barangay Certification

Field	Description	Type	Length
bar_cert_ID (PK)	Barangay Certification ID	Int	11
info_ID (FK)	Information ID	Int	11
date	Date of Certification	Date

Table Name: Health Certification

Field	Description	Type	Length
health_cert_ID (PK)	Health Certification ID	Int	11
info_ID (FK)	Information ID	Int	11
health_rec_ID	Health Record ID	Int	11
date	Information ID	Time

Table Name: Health Records

Field	Description	Type	Length
health_rec_ID (PK)	Health Record ID	Int	11
info_ID (FK)	Information ID	Int	11
health_status	Health Status	Varchar	255
health_complain	Health Complain	Varchar	255
medicine_claim	Transaction Date	Varchar	255

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

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!

Barangay Information System ER Diagram | Entity Relationship Diagrams