Contact Management System ER Diagram

Subscribe our YouTube channel for latest project videos and tutorials Click Here

Posted By freeproject on July 17, 2017

This ER (Entity Relationship) Diagram represents the model of Contact Management System Entity. The entity-relationship diagram of Contact Management System shows all the visual instrument of database tables and the relations between Peoples, Address, Contacts, Phone Numbers etc. It used structure data and to define the relationships between structured data groups of Contact Management System functionalities. The main entities of the Contact Management System are Contacts, Peoples, Mobiles, Address, Reminders and Phone Numbers.

Contact Management System entities and their attributes :

  • Contacts Entity : Attributes of Contacts are contact_id, contact_people_id, contact_type, contact_description
  • Peoples Entity : Attributes of Peoples are people_id, people_name, people_mobile, people_email, people_username, people_password, people_address
  • Mobiles Entity : Attributes of Mobiles are mobile_id, mobile_people_id, mobile_number, mobile_type, mobile_description
  • Address Entity : Attributes of Address are address_id, address_people_id, address_place, address_type, address_description
  • Reminders Entity : Attributes of Reminders are reminder_id, reminder_people_id, reminder_place, reminder_type, reminder_description
  • Phone Numbers Entity : Attributes of Phone Numbers are phone_id, phone_people_id, phone_number, phone_type, phone_description

Description of Contact Management System Database :

  • The details of Contacts is store into the Contacts tables respective with all tables
  • Each entity (Phone Numbers, Mobiles, Reminders, Peoples, Contacts) contains primary key and unique keys.
  • The entity Mobiles, Reminders has binded with Contacts, Peoples entities with foreign key
  • There is one-to-one and one-to-many relationships available between Reminders, Address, Phone Numbers, Contacts
  • All the entities Contacts, Reminders, Mobiles, Phone Numbers are normalized and reduce duplicacy of records
  • We have implemented indexing on each tables of Contact Management System tables for fast query execution.
Contact 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)

Login System ER Diagram

Login System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Login System Entity. The entity-relationship diagram of Login System shows all the visual instrument of database tables and the relations between Password, Programmer, Username, Permission etc. It used structure data and to define the...
Student Feeback System ER Diagram

Student Feeback System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Student Feeback System Entity. The entity-relationship diagram of Student Feeback System shows all the visual instrument of database tables and the relations between Feedback, Faculty, Student, Subject etc. It used structure data and to...
Campus Recruitment System ER Diagram

Campus Recruitment System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Campus Recruitment System Entity. The entity-relationship diagram of Campus Recruitment System shows all the visual instrument of database tables and the relations between College, Job, Student, Qualification etc. It used structure data...
Mobile Store System ER Diagram

Mobile Store System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Mobile Store System Entity. The entity-relationship diagram of Mobile Store System shows all the visual instrument of database tables and the relations between Customers, Sells, Mobile, Stock etc. It used structure data and to define the...
Payroll Management System ER Diagram

Payroll Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Payroll Management System Entity. The entity-relationship diagram of Payroll Management System shows all the visual instrument of database tables and the relations between Salary, Appraisals, Payroll, Payments etc. It used structure data...
News Portal System ER Diagram

News Portal System ER Diagram

This ER (Entity Relationship) Diagram represents the model of News Portal System Entity. The entity-relationship diagram of News Portal System shows all the visual instrument of database tables and the relations between Contents, Advertisement, News, News Tupe etc. It used structure data and to...
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...
Finance Management System ER Diagram

Finance Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Finance Management System Entity. The entity-relationship diagram of Finance Management System shows all the visual instrument of database tables and the relations between Profit, Interest, Day Book, Loaner etc. It used structure data...
Classifieds Management System ER Diagram

Classifieds Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Classifieds Management System Entity. The entity-relationship diagram of Classifieds Management System shows all the visual instrument of database tables and the relations between Location, Categories, Advertisement, Listing etc. It used...
Timetable Management System ER Diagram

Timetable Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Timetable Management System Entity. The entity-relationship diagram of Timetable Management System shows all the visual instrument of database tables and the relations between Attendance, Student, Timetable, Teacher etc. It used...
Call FreeProjectz WhatsApp FreeProjectz