Activity 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 Activity Management System Entity. The entity-relationship diagram of Activity Management System shows all the visual instrument of database tables and the relations between Users, Timeslots, Activity, Particiapants etc. It used structure data and to define the relationships between structured data groups of Activity Management System functionalities. The main entities of the Activity Management System are Activity, Users, Activity Type, Timeslots, Attandance and Particiapants.

Activity Management System entities and their attributes :

  • Activity Entity : Attributes of Activity are activity_id, activity_title, activity_type, activity_date, activity_description
  • Users Entity : Attributes of Users are user_id, user_name, user_mobile, user_email, user_username, user_password, user_address
  • Activity Type Entity : Attributes of Activity Type are ac_id, ac_title, ac_description
  • Timeslots Entity : Attributes of Timeslots are time_slot_id, time_slot_name, time_slot_duration, time_slot_type, time_slot_description
  • Attandance Entity : Attributes of Attandance are attandance_id, attandance_user_id, attandance_date, attandance_descriptioa
  • Particiapants Entity : Attributes of Particiapants are particiapants_id, particiapants_name, particiapants_mobile, particiapants_email, particiapants_username, paticipants_password, participants_address

Description of Activity Management System Database :

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

Reseller Management System  ER Diagram

Reseller Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Reseller Management System Entity. The entity-relationship diagram of Reseller Management System shows all the visual instrument of database tables and the relations between Order, Company, Reseller, Company Type etc. It used structure...
Courier Tracking System ER Diagram

Courier Tracking System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Courier Tracking System Entity. The entity-relationship diagram of Courier Tracking System shows all the visual instrument of database tables and the relations between Customer, Manager, Courier, Delivery etc. It used structure data and...
Leave Management System ER Diagram

Leave Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Leave Management System Entity. The entity-relationship diagram of Leave Management System shows all the visual instrument of database tables and the relations between Branch, Leave, Company, Employee etc. It used structure data and to...
Sarkari Naukri Portal System ER Diagram

Sarkari Naukri Portal System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Sarkari Naukri Portal System Entity. The entity-relationship diagram of Sarkari Naukri Portal System shows all the visual instrument of database tables and the relations between Users, Resumes, Jobs, Registration etc. It used structure...
Company Canteen Management System ER Diagram

Company Canteen Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Company Canteen Management System Entity. The entity-relationship diagram of Company Canteen Management System shows all the visual instrument of database tables and the relations between Canteen, Sales, Company, Category etc. It used...
Art Gallery Management System ER Diagram

Art Gallery Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Art Gallery Management System Entity. The entity-relationship diagram of Art Gallery Management System shows all the visual instrument of database tables and the relations between Customer, Order Update, Arts, Arts Stock etc. It used...
Internet Cafe ER Diagram

Internet Cafe ER Diagram

This ER (Entity Relationship) Diagram represents the model of Internet Cafe Entity. The entity-relationship diagram of Internet Cafe shows all the visual instrument of database tables and the relations between Internet, Bills, Users, Login etc. It used structure data and to define the relationships...
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...

Onile Gas Booking System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Onile Gas Booking System Entity. The entity-relationship diagram of Onile Gas Booking System shows all the visual instrument of database tables and the relations between Connections , Bookings , Gas , Delivery etc. It used structure...
Garment Inventory System ER Diagram

Garment Inventory System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Garment Inventory System Entity. The entity-relationship diagram of Garment Inventory System shows all the visual instrument of database tables and the relations between Inventory, Garments, Brands, Customers etc. It used structure data...
Call FreeProjectz WhatsApp FreeProjectz