This ER (Entity Relationship) Diagram represents the model of Marrige Buero Management Entity. The entity-relationship diagram of Marrige Buero Management shows all the visual instrument of database tables and the relations between Registration, Photograps, Partners, Multipile Types etc. It used structure data and to define the relationships between structured data groups of Marrige Buero Management functionalities. The main entities of the Marrige Buero Management are Partners, Registration, Contact Profile, Photograps, Documents Support and Multipile Types.
Marrige Buero Management entities and their attributes :
- Partners Entity : Attributes of Partners are partner_id, partner_name, partner_mobile, partner_email, partner_username, partner_password, partner_address
- Registration Entity : Attributes of Registration are registration_id, registration_user_id, registration_name, registration_type, registration_number, registration_date, registration_description
- Contact Profile Entity : Attributes of Contact Profile are contact_profile_id, contact_profile_partner_id, contact_profile_name, contact_profile_type, contact_profile_description
- Photograps Entity : Attributes of Photograps are photograps_id, photograps_partner_id, photograps_name, photograps_upload, photograps_type, photograps_description
- Documents Support Entity : Attributes of Documents Support are document_id, document_partner_id, document_name, document_type, document_description
- Multipile Types Entity : Attributes of Multipile Types are multipile_type_id, multipile_type_name, multipile_type_description
Description of Marrige Buero Management Database :
- The details of Partners is store into the Partners tables respective with all tables
- Each entity (Multipile Types, Contact Profile, Documents Support, Registration, Partners) contains primary key and unique keys.
- The entity Contact Profile, Documents Support has binded with Partners, Registration entities with foreign key
- There is one-to-one and one-to-many relationships available between Documents Support, Photograps, Multipile Types, Partners
- All the entities Partners, Documents Support, Contact Profile, Multipile Types are normalized and reduce duplicacy of records
- We have implemented indexing on each tables of Marrige Buero Management tables for fast query execution.