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!
