This ER (Entity Relationship) Diagram represents the model of Advertisement Management System Entity. The entity-relationship diagram of Advertisement Management System shows all the visual instrument of database tables and the relations between Advertisement Types, Payments, Advertisement, Places etc. It used structure data and to define the relationships between structured data groups of Advertisement Management System functionalities. The main entities of the Advertisement Management System are Advertisement, Advertisement Types, Sizes, Payments, Customers and Places.
Advertisement Management System entities and their attributes :
- Advertisement Entity : Attributes of Advertisement are advertisement_id, advertisement_title, advertisement_Type, advertisement_description
- Advertisement Types Entity : Attributes of Advertisement Types are advertisement types_id, advertisement Types_title, advertisement types_description
- Sizes Entity : Attributes of Sizes are sizes_advertisement_id, size_description
- Payments Entity : Attributes of Payments are payment_id, payment_customer_id, payment_date, payment_amount, payment_description
- Customers Entity : Attributes of Customers are customer_id, customer_name, customer_mobile, customer_email, customer_username, customer_password, customer_address
- Places Entity : Attributes of Places are place_id, place_name, place_address, place_description
Description of Advertisement Management System Database :
- The details of Advertisement is store into the Advertisement tables respective with all tables
- Each entity (Places, Sizes, Customers, Advertisement Types, Advertisement) contains primary key and unique keys.
- The entity Sizes, Customers has binded with Advertisement, Advertisement Types entities with foreign key
- There is one-to-one and one-to-many relationships available between Customers, Payments, Places, Advertisement
- All the entities Advertisement, Customers, Sizes, Places are normalized and reduce duplicacy of records
- We have implemented indexing on each tables of Advertisement Management System tables for fast query execution.