an applicant can pass 1 application per job information (1 to 1 relationship).a company has multiple job hiring (1 to many relationship).job information is specific to a job category (1 to 1 relationship).job information has only 1 job location (1 to 1 relationship).employee encodes multiple job category (1 to many relationship).employee encodes multiple job location (1 to many relationship).Job Portal ER Diagram – Entity Relationship After we have specified our entities, it is time now to connect or establish a relationship among the entities.
We will now draw the entities and it will be represented by a rectangle shape. In the job portal system we have the following entities Add meaningful attributes to our entities.Identify the relationship between entities and.
We will follow the 3 basic rules in creating the ER Diagram. This is usually in a form of primary key to foreign key connection. This will determine the relationships among entities. Relationship is represented by diamond shape. This will be the columns or fields of each table in the Job Portal System. The entity will be our database table of Job Portal System later on.Īttribute is represented by the oval shape. Let’s start from the symbols used in the ER Diagram.Įntity is represented by the rectangle shape. We will create and explain the process of making the entity relationship diagram of job portal system. In the development of an information system, the project always starts in a form of a blue-print in our case we will be designing the blue-print of job portal system in a form of entity relationship diagram. Application and the process of hiring are done online which benefit the both parties.
Job portal system is an online platform for job seekers and companies who are looking for applicants. 70 Best Web Based Capstone Projects in PHP and MySQL