Railway Management System (ER) Entity Relationship Diagram in DBMS
Hi there Itsourcecoders! Today I will give you ideas about the Railway Management System Entity Relationship Diagram (ERD) for 2021. This simple database will also give you deep understanding about Railway management system database project with ER Diagrams tables. This will teach you in managing Railway database project as well as the relationships of tables in Railway management system project database design. By the end of the discussion you will find the Railway Management system project Documentation ER diagram PDF and PPT files that will be helpful for your report and studies in database tables DBMS.
This Entity Relationship Diagram for the Railway Management System project with a table will also give you the idea of how to make a database design for a Railway management system with ERD, tables, and schema.
The idea presented here can be used for your Railway management 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 ER Diagram for Railway Management System Database projects 2021?
- Railway management system Description with Features
- Railway management system database tables and PDF
- Simple diagram for Railway management system
- ER Diagram for Railway Management System
Railway Management System Project ER Diagram and Database Description Report
This Railway management system database design was made based on managing Railway requirements. The system can encode both customers and medicines’ information. Railway admin can have access to the medicines status and information in terms of the number sold and remains to identify the inventories of sales and stocks. They can handle the data needed in managing railway as well as the sales of medicines and customer records.
The features included in the system ER diagram were the security and monitoring of the medicines’ information and status and customers’ order. These features were also listed and recorded in reports that served as the history of transactions done in the system.
ER Diagram For Railway Management System With Tables and Features
Time needed: 5 minutes.
Here’s the simple database design and tables for Railway management system project with ER Diagram that includes Tables, PPT, PDF, etc.
- Railway Management
Railway Management is the main feature of this system wherein the ER diagram contains the basic details needed for
managing tickets records and availability. These basic information was composed of railway records, ticket sales, counts and availabilities. This will also monitor or check about the customers’ info and purchasing or reservation status. - Customer Management
This feature plays a big role for the system because this gathers and manages the important information of the customer. These information were used to track their transaction and reservation records and other important matters regarding the system to assure that the services were given properly.
- Manage Tickets
The ticket management will be done by the admin to track the number of reserves and remaining available. This will also monitor the count of their customers as well as their revenues.
- Manage Revenues and Record Transactions
Its feature will manage and monitor the revenues and secures every transaction made by the customer. This is also the basis for their income and expenses. Through this the admin will have the records of transaction and review it for future basis.
Railway Management 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: Customer
| Field | Description | Type | Length |
| stud_ID (PK) | Customer ID | Int | 11 |
| fname | Customer First Name | Varchar | 255 |
| lname | Customer Last Name | Varchar | 255 |
| gender | Customer Gender | Int | 11 |
| age | Customer Age | Int | 11 |
| contact_add | Contact Address | Int | 11 |
| cust_email | Customer Email | Varchar | 255 |
| cust_pass | Customer Password | Varchar | 255 |
Table Name: Admin
| Field | Description | Type | Length |
| admin_ID (PK) | Admin ID | Int | 11 |
| fname | Admin First Name | Varchar | 255 |
| lname | Admin Last Name | Varchar | 255 |
| gender | Admin Gender | Int | 11 |
| age | Admin Age | Int | 11 |
| contact_add | Contact Address | Int | 11 |
| admin_email | Admin Email | Varchar | 255 |
| admin_pass | Admin Password | Varchar | 255 |
Table Name: Train Ticket
| Field | Description | Type | Length |
| ticket_ID (PK) | Ticket ID | Int | 11 |
| ticket_num | Ticket Number | Int | 11 |
| date_avail | Date Available | Date | |
| date_flight | Date of Flight | Date | |
| time_depart | Departure Time | Time | |
| time_land | Landing Time | Time | |
| destination | Destination | Varchar | 30 |
Table Name: Reservation
| Field | Description | Type | Length |
| res_ID (PK) | Reservation ID | Int | 11 |
| cust_ID (FK) | Customer ID | Int | 11 |
| admin_ID (FK) | Admin ID | Int | 11 |
| ticket_ID (FK) | Ticket ID | Int | 11 |
| date_reserve | Date Reservation | Date | |
| date_accom | Date of Accommodation | Date |
Table Name: Transaction
| Field | Description | Type | Length |
| trans_ID (PK) | Transaction ID | Int | 11 |
| trans_name | Transaction Name | Varchar | 30 |
| borrowing_ID (FK) | Subject ID | Int | 11 |
| stud_ID (FK) | Student ID | Int | 11 |
| trans_date | Date of Transaction | Date |
Table Name: Transaction Type
| Field | Description | Type | Length |
| transty_ID (PK) | Transaction Type ID | Int | 11 |
| trans_name | Transaction Type | Varchar | 30 |
Table Name: Reports
| Field | Description | Type | Length |
| report_ID (PK) | Report ID | Int | 11 |
| trans_ID (FK) | Transaction ID | Int | 11 |
| res_ID (FK) | Reservation ID | Int | 11 |
| report_date | Report Date | Date |
Entity Relationship Diagram for Railway Reservation
ER Diagram of Railway Management System shows the system entity relationships in each entity and their supposed functions in each relationship.
Sample ER Diagram for Railway Management System Project Database Report
Based on the image above, the Entity Relationship diagram for this System is the entity of the Railway management 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.
You can now have the PPT and PDF file of the Railway Management System database Project Documentation of ER Diagram for you to have your own copy and basis for your future studies in DBMS.
Conclusion
So that completes our discussion about ER Diagram project fellas, and I hope that this article about ER Diagram For Railway Management System Database tables 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 Railway Management System just leave us your comments below.
Keep us updated and Good day!
Recommended Articles From the Author
- Railway Reservation System Project in Django with Source Code
- Railway Reservation System in C++ With Source Code
- Airline Reservation System Project In C With Source Code
- Online Ticket Reservation System Use Case Diagram
- Django Projects With Source Code and Ideas for Beginners 2021
- Best Java Projects With Source Code For Beginners Free Download 2021
