Contractor Management System ER Diagram

Posted By freeproject on July 17, 2017

This ER (Entity Relationship) Diagram represents the model of Contractor Management System Entity. The entity-relationship diagram of Contractor Management System shows all the visual instrument of database tables and the relations between Company, Timesheet, Contract, Salary etc. It used structure data and to define the relationships between structured data groups of Contractor Management System functionalities. The main entities of the Contractor Management System are Contract, Company, Leave, Timesheet, Project and Salary.

Contractor Management System entities and their attributes :

  • Contract Entity : Attributes of Contract are contract_id, contract_project_id contract_name, contract_type, contract_description
  • Company Entity : Attributes of Company are company_id, company_name, comapny_type, company_description, company_address
  • Leave Entity : Attributes of Leave are leave_id, leave_employee_id, leave_type, leave_status, leave_to, leave_from, leave_description
  • Timesheet Entity : Attributes of Timesheet are timesheet_id, timesheet_project_id, timesheet_type, timesheet_description
  • Project Entity : Attributes of Project are project_id, project_company_id, project_contract_id, project_name, project_assign, project_last_date, project_type, project_description
  • Salary Entity : Attributes of Salary are salary_id, salary_employee_id, salary_amount, salary_total, salary_type, salary_description

Description of Contractor Management System Database :

  • The details of Contract is store into the Contract tables respective with all tables
  • Each entity (Salary, Leave, Project, Company, Contract) contains primary key and unique keys.
  • The entity Leave, Project has binded with Contract, Company entities with foreign key
  • There is one-to-one and one-to-many relationships available between Project, Timesheet, Salary, Contract
  • All the entities Contract, Project, Leave, Salary are normalized and reduce duplicacy of records
  • We have implemented indexing on each tables of Contractor Management System tables for fast query execution.
Contractor Management System ER Diagram
Get 6 diagrams only in 300/- or $6.99 USD.
Call or WhatsApp us on +91-8470010001 for more details.

Project Category

Related Entity Relationship Diagram (ERD)

KBC Quiz System ER Diagram

KBC Quiz System ER Diagram

This ER (Entity Relationship) Diagram represents the model of KBC Quiz System Entity. The entity-relationship diagram of KBC Quiz System shows all the visual instrument of database tables and the relations between Answers, Participants, Questions, Level etc. It used structure data and to define the...
Student Management System ER Diagram

Student Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Student Management System Entity. The entity-relationship diagram of Student Management System shows all the visual instrument of database tables and the relations between Fees, Profiles, Student, Exams etc. It used structure data and to...
Graphical Payroll System ER Diagram

Graphical Payroll System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Graphical Payroll System Entity. The entity-relationship diagram of Graphical Payroll System shows all the visual instrument of database tables and the relations between Payment, Salary Slips, Salary, Login etc. It used structure data...
Movie Library Management System ER Diagram

Movie Library Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Movie Library Management System Entity. The entity-relationship diagram of Movie Library Management System shows all the visual instrument of database tables and the relations between Movie Type, Shows, Movie Library, Login etc. It used...
Defect Tracking System ER Diagram

Defect Tracking System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Defect Tracking System Entity. The entity-relationship diagram of Defect Tracking System shows all the visual instrument of database tables and the relations between Register Bug, Project Manager, Bug, Quality etc. It used structure data...
E-Billing Management System ER Diagram

E-Billing Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of E-Billing Management System Entity. The entity-relationship diagram of E-Billing Management System shows all the visual instrument of database tables and the relations between Customer, Login, Bills, Receipts etc. It used structure data...
Blood Bank Management System ER Diagram

Blood Bank Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Blood Bank Management System Entity. The entity-relationship diagram of Blood Bank Management System shows all the visual instrument of database tables and the relations between Blood Group, Donor, Blood, Order etc. It used structure...
Car Insurance Management System ER Diagram

Car Insurance Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Car Insurance Management System Entity. The entity-relationship diagram of Car Insurance Management System shows all the visual instrument of database tables and the relations between Insurance, Booking, Car, Bill etc. It used structure...
Car Parking System ER Diagram

Car Parking System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Car Parking System Entity. The entity-relationship diagram of Car Parking System shows all the visual instrument of database tables and the relations between Parking, Parking Space, Car, Car Owner etc. It used structure data and to...
Medical Store Management System ER Diagram

Medical Store Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Medical Store Management System Entity. The entity-relationship diagram of Medical Store Management System shows all the visual instrument of database tables and the relations between Medicines, Company, Medical Shop, Sells etc. It used...