Fashion Model Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Fashion Model Management System Entity. The entity-relationship diagram of Fashion Model Management System shows all the visual instrument of database tables and the relations between Models, Events, Fashion, ##keyword6## etc. It used structure data and to define the relationships between structured data groups of Fashion Model Management System functionalities. The main entities of the Fashion Model Management System are Fashion, Models, Judges, Events, Event Type and ##keyword6##.

Fashion Model Management System entities and their attributes :

• Fashion Entity : Attributes of Fashion are fashion_id, fashion_name, fashion_type, fashion_description
• Models Entity : Attributes of Models are model_id, model_name, model_mobile, model_email, model_username, model_password, model_address
• Judges Entity : Attributes of Judges are judge_id, judge_name, judge_mobile, judge_email, judge_username, judge_password, judge_address
• Events Entity : Attributes of Events are event_id, event_fashion_id, event_name, event_type, event_place, event_description
• Event Type Entity : Attributes of Event Type are event_type_id, event_type_name, event_type_description
• ##keyword6## Entity : Attributes of ##keyword6## are ##AttributeList6##

Description of Fashion Model Management System Database :

• The details of Fashion is store into the Fashion tables respective with all tables
• Each entity (##keyword6##, Judges, Event Type, Models, Fashion) contains primary key and unique keys.
• The entity Judges, Event Type has binded with Fashion, Models entities with foreign key
• There is one-to-one and one-to-many relationships available between Event Type, Events, ##keyword6##, Fashion
• All the entities Fashion, Event Type, Judges, ##keyword6## are normalized and reduce duplicacy of records
• We have implemented indexing on each tables of Fashion Model Management System tables for fast query execution.