smart gate pass and leave maintenance system ppt

The details of Passes is store into the Passes tables respective with all tables.

Shows Entity : Attributes of Shows are show_id, show_ticket_id, show_name, show_time, show_date, show_type, show_descriptionĭescription of Gate Pass Management System Database :.

Sales Entity : Attributes of Sales are sales_id, sales_customer_id, sales_amount, sales_type, sales_description.Pass Types Entity : Attributes of Pass Types are pass_type_id, pass_type_pass_id, pass_type_name, pass_type_description.

Customers Entity : Attributes of Customers are customer_id, customer_name, customer_mobile, customer_email, customer_username, customer_password, customer_address.Tickets Entity : Attributes of Tickets are ticket_id, ticket_customer_id, ticket_type, ticket_date, ticket_description.Passes Entity : Attributes of Passes are pass_id, pass_name, pass_type, pass_description.Gate Pass Management System entities and their attributes : The main entities of the Gate Pass Management System are Passes, Tickets, Customers, Pass Types, Sales and Shows. It used structure data and to define the relationships between structured data groups of Gate Pass Management System functionalities. The entity-relationship diagram of Gate Pass Management System shows all the visual instrument of database tables and the relations between Tickets, Pass Types, Passes, Shows etc. This ER (Entity Relationship) Diagram represents the model of Gate Pass Management System Entity.

Smart gate pass and leave maintenance system ppt