The entity-relationship (ER) diagram of Student Management System is a form of flowchart that shows how “entities” within the Student Management System interact with one another. ER Diagram is the blueprint of
Additionally, the relationships between entity sets recorded in a database are depicted in the Student Management System entity-relationship diagram (ERD). Student Management System ER Diagram is composed of entities such as students, courses offered, staff, staff department, student registration, project transactions, and reports.
Student Management System ER Diagram Entities and Attributes
|Student:||stud_ID (PK), stfname, stlname, stcourse, styear, stcontact, stage, stbirthdate, and stgender|
|Courses Offered:||course_ID (PK), course_desc, units, course_remarks|
|Staff:||staff_ID (PK), fname, lname, contact, address, gender|
|Staff Department:||staff_ID (PK), course_line|
|Reports:||report_ID (PK), reports_name, student_records, transaction_reports|
|Student Registration:||registration_ID (PK), name, content, registration_date|
|Project Transactions:||transaction_ID (PK), transaction_name, stude_ID, staff_ID, transaction_date|
Student Management System ER (Entity Relationship) Diagram
This ER diagram shows the overall entities in Student Management System. The entities are represented by rectangles, while their attributes are represented by circles or ovals.
Description of Student Management System ER Diagram
Student Management System ER Diagram employs a predetermined collection of symbols such as rectangles, diamonds, ovals, and connecting lines to illustrate the relatedness of entities, relationships, and their properties. They are organized in the same way that grammar is organized, with nouns for entities and verbs for relationships.
Modeling the data stored in a database requires the use of ER Diagrams. It is the basis upon which a database is built. ER diagram helps in defining the types of data that will be stored in the student management system.
Student Management System Database Design
Here’s the illustration of Student Management System Database Design that is based on ER Diagram. This design has database tables that contain the entities, attributes, and characteristics.
The Student Management System Database design is the storage of all the data that may enter and exit the system. It organizes the data according to ER Diagram model. The developer or proponent decides what data should be saved and how the various data parts should interact. Developers will map the data to the database design using the entity-relationship diagram model.
Additionally, it generates prototypes of the proposed database system’s logical and physical designs. Independent of physical factors, the logical model focuses on data requirements and data to be stored.
Tables in Student Management System Database Design
The tables below provide the complete database design details such as Field Name, Descriptions, data types, and character lengths of the Student Management System. These roles are used to categorize every piece of data that will be fed into the system to make sure that they were thoroughly managed and secured. Each of the Database tables was used to design the back end of the Student management system.
Table Name: tblStudent
|stud_ID (PK)||Student ID Number||Int||11|
|stfname||Student First Name||Varchar||30|
|stlname||Student Last Name||Varchar||30|
|stcontact||Student Contact Number||Int||11|
|stbirthdate||Student Birth Date||Date|
Table Name: tblCourse
|course_ID (PK)||Course ID Number||Int||11|
Table Name: tblStaff
|staff_Id (PK)||Staff ID Number||Int||11|
|fname||Staff First Name||Varchar||30|
|lname||Staff Last Name||Varchar||30|
|contact||Staff Contact Number||Int||11|
Table Name: tblStaff_Department
|staff_ID (PK)||Staff ID Number||Int||11|
|course_line (FK)||Staff Course Line||Int||11|
Table Name: tblProject_Transaction
|transaction_ID (PK)||Transaction ID Number||Int||11|
|stud_ID (FK)||Student ID Number||Int||11|
|staff_ID (FK)||Staff ID Number||Int||11|
Table Name: tblStudent_Registration
|registration_ID||Registration ID Number||Int||11|
Table Name: tblStudent_Reports
|report_ID (PK)||Report ID Number||Int||11|
|student_records (FK)||Student Record||Int||11|
|transaction_reports (FK)||Transaction Record||Int||11|
How to build ER Diagram for Student Management System?
Time needed: 5 minutes.
Steps in building the ER Diagram for Student Management System.
- Step 1: Familiarize the ER Diagram (Entity Relationship Diagram)
Entity Relationship Diagram – shows the structure of data types in a project. It uses symbols to clarify its parts and relationships. Their symbols and applications must be familiarized before you build the ER Diagram.
ER Diagram Symbols:
• Fields – Fields are the parts of a table that define the entity’s characteristics. In the database that the ERD models, attributes are commonly thought of as rows.
• Keys – is a technique to categorize data qualities. It is used to organize ER diagrams and assist users in modeling their databases to ensure that they are efficient. This is also used to connect different tables in a database.
– Primary Key: identifies a single entity instance which means a unique attribute or set of attributes.
– Foreign Key: is produced when data attributes have one-many relationships with other entities.
ER Diagram Cardinalities:
The styling of a line and its termination demonstrates cardinality and ordinality.
The greatest number of times an instance of one thing can be related to instances of another entity is referred to as cardinality.
While Ordinality refers to the fewest number of times a single entity instance can be linked to another.
- Step 2: Determine the targeted users
After the symbol familiarization, you’ll need to determine your targeted users. Your targeted users will be the ones to use your project.
If your project is Student Management System then your users would be the admin, students, and staff. You may ask the users about the common activities that they do when doing tasks in the library. This information will help you in proceeding with the next step.
- Step 3: Analyze the entities and their included attributes
Analyzation is very important in creating ER diagram. It will help you understand the work of the diagram and avoid unwanted errors. The gathered information from the users is very useful in creating the diagram. You will evaluate the data and pick the useful ones.
From this, you will see the possible data that will enter and exit the system. But only include the useful data related to library management. Then you’re ready for the next step.
- Step 4: Plot the Entity Relationship Diagram
To plot the ERD you will need the entities, their attributes, and relationships. You will base the data structure from the evaluated information to have the exact Entity Relationship Diagram.
– To design the ER Diagram, you will list first all of the entities related to the Student Management System.
– Then you will place the attributes included under them. This will help you create the ER Diagram Fields.
– Do not forget the keys of the attributes. The keys will generate the potential relationships between entities.
– Finally, you have your ER Diagram Completed.
You need to know the diagrams used to design and develop the Student Management System. That is to help you create a fully-functional system with the use of ER Diagram. Creating it will help you perceive the back end of the software. This will hold all the data that’ll enter and exit the system.
- Student Management System ER Diagram
- Hotel Management System ER Diagram
- Bank Management System ER Diagram
- Online Ordering System ER Diagram
- Blood Bank Management System ER Diagram
- Student Management System UML Diagrams
- Student Management System Class Diagram
- Student Management System Sequence Diagram
- Student Management System Activity Diagram
If you have inquiries or suggestions about Student Management System ER Diagram, just leave us your comments below. We would be glad to know to concerns and suggestions and be part of your learning.
Keep us updated and Good day!