Entity Relation Diagram for High Frequency Investments

Running head: ENTITY RELATION DIAGRAM
Entity Relation Diagram
Name of Student-
Name of University-
Author’s Note-

1ENTITY RELATION DIAGRAM
1. Introduction
HFI (High Frequency Investments) is company in Australia which is considered as a
leading investment management company. The HFI is founded by managers and also security
analysts. In this report, the methods and procedures that are carried out are shown with an entity
relationship diagram. This report also contain the details of all the entity and attributes that are
involved in the ERD diagram of the company. The ERD shows the primary key, foreign key and
the multivalued key in the diagram. The explanation of all the entity and attributes are explained
and some assumptions are made and justification is provided for the procedures of the company.

2ENTITY RELATION DIAGRAM
2. Entity Relation Diagram of High Frequency Investments
Figure: ERD of High Frequency Investments

3ENTITY RELATION DIAGRAM
3. Assumptions
EMPLOYEE: The employee table consist of all the details of the employees who works
in HFI (Human Frequency Investments). There are mainly two types of employees who works in
HFI.
Employee_ID: There is a unique employee id for all the employees who work in HFI. All
the employees of the company have a unique identification number which is considered as the
primary key of the table EMPLOYEE.
Full Name: This denotes the full name of employee.
Address: The address of the employees are stored in the data base in this address table.
Phone_Number: The phone number is stored in this attribute. This is a multivalued
attribute because a particular employee may have more than one contact number.
Designation: An employee have some roles in the company. There are mainly two types
of designation in this company, Security analysts and Portfolio Managers. All the employees are
divided in these two categories.
Salary: The salary of all employees are mentioned in the salary attribute.
Date of Joining: The date of joining on which the employee has joined is saved in the
database in this field.
Portfolio Managers: This entity is about the employees having designation of portfolio
managers. The attributes of this entity are described in the section given below:
Manager_id: This is the primary key of this table. Each of the managers gets a unique id.
Employee_id: This attribute will act as foreign key in this entity.