DFD Level 0: Event Manager
DFD LEVEL 0
Level 1
Generated report for each events
Event manager
Sms and Email Checks current bookin gs
Customer
New event details
Checks for employees and event details
Customer & event details
Booking id
1. Booking
event details Customer & event details New event details
3. Updating and payment
2. Validation and
confirmation
4. Maintenance and job allocation
Event details
5. Report generation
Payment details Payment db
Customer & event details
Message details
Booking db Event detail updated by event manger Message db Event details
Em plo ye e det ails
Final report details
Update d details
Employee db
Events_m db
Report
db
Level2
Level2 booking
1.1
Booking details
1.2 Event booking
Customer _id & booking_i d
1.3 Event selection
Customer
Customer details
Custome r id
Custo mer details Customer id
Customer db
Event details
Selected event details
Event detail db
Event db
Booking id
Level2:Event Selection
Customer
Customer details Conference details conference db
1.3.1
Customer details
Conference Management
Event detail db Event details
Customer details
1.3.3 Wedding planning
Event details
Wedding details Wedding l db Customer details
1.3.4 Accommoda tion
Customer details
Event details
Accomodation details
Accomodation db
1.3.5
Customer details
Event details
Catering
Catering details Catering db
Event details
1.3.6 Transport
Transport details Transport db
Event details
1.3.7 Venue design
Venue details Venue db
Level 2 2 validation..
Validates
Event manager 2.
Validation and confirmation
Event details Event db Updated details Customer details
SMS and email
Customer
customer db
Message details
Message db
Level 2.3 Updation & payment
Customer id
Customer
Event details
3.
Updating and payment
Payment details Payment db
updated details event db
Customer details Customer db
Level 2.4 maintanance &job allocation
Event manager
Updated details
4.1 Employee maintenance
4.2 Job allocation
Job allocation details
Updated details Employee db
employee details employee details
Booked event details details Event db Job allocation db
4.3 Event maintenance
New or updated details Event _m db Existing event details
Level 2 5 Report generation
Event manager
Final report
5. Report generation
Final report db Report db
amount amount
Venue design
Payment db
5.9. TABLE STRUCTURE
Personal_details Table
Event_details db
amount
amount amount
Accommodation db
Catering details db
Transport db
Primary key: user_id Field name user_id Name Gender Age Occupation Address Phone_no Mobile Email Contact_person Contact_no Budget Data type Int Varchar(10) Char(1) Int Varchar(15) Varchar(50) Bigint Bigint Varchar(15) Varchar(10) Bigint Int Constraints Primary key
Event_details Table Primary key: event_id Foreign key: user_id Field name Event_id User_id Event_type Event_name Venue Data type int int Varchar(25) Varchar(25) Varchar(30) Constraint Primary key Foreign key
Location Deposit
Varchar(25) Float
Conference _Management Table Foreign Key:User_id,event_id COLUME NAME User_id Event_id Time More_info Audio_visual Lighting DATA TYPE int int Numeric(2,0) Varchar(50) Char(1) Char(1) CONSTRAINT Foreign Key Foreign Key
Wedding Table Foreign key: User_id,event_id COLUME NAME Event_id User_id Wedding_type Wed_time Parking Host&hosteses Car_dec DATA TYPE int int Varchar(15) Float Char(3) Char(3) Char(3) Default yes or no Default yes or no Default yes or no CONSTRAINT Foreign Key Foreign Key
More_info
Varchar(25)
Accomodation Table Foreign key: User_id,event_id COLUME NAME User_id event_id Adate Ddate Atime Guest_no Room_no Transport DATA TYPE int int Date Date Float Int int Char(3) Default yes or no CONSTRAINT Foreign Key Foreign key
Catering Table Foreign key: User_id,event_id
COLUME NAME User_id event_id Time Number Mrng_food_type
DATA TYPE int int Float Int Varchar(15)
CONSTRAINT Foreign Key Foreign key
Noon_food_type Eveng_food_type Dinner_food_type Mrng_time Noon_time Eveng_time Dinner_time More_info
Varchar(15) Varchar(15) Varchar(15) Float Float Float Float Varchar(40)
Transport Table Foreign key: User_id,event_id
COLUME NAME User_id Book_id Time Vehicle_type Veh_no Start_point End_point More_info
DATA TYPE int int Float Varchar(10) Int Varchar(20) Varchar(20) Varchar(50)
CONSTRAINT Foreign Key Foreign key
Venue_ Design Table Foreign key: User_id,event_id
COLUME NAME User_id event_id Time Guest_no Flower Ballon Chair_table_dec Lighting Design Design_name More_info
DATA TYPE Int Int Float Int Char(3) Char(3) Char(3) Char(3) Char(3) Varchar(10) Varchar(50)
CONSTRAINT Foreign Key Foreign key
Default yes or no Default yes or no Default yes or no Default yes or no Default yes or no
Venue _Finding Table Foreign key: User_id,event_id COLUME NAME User_id event_id Event_name Location Venue More_info DATA TYPE Int Int Varchar(25) Varchar(30 varchar(30) Varchar(50) CONSTRAINT Foreign Key Foreign key
Billing Table Foreign key: User_id
COLUME NAME User_id Client_name Advance_paid Total_amount Bal_amount
DATA TYPE int Varchar(20) Float Float Float
CONSTRAINT Foreign Key
Login Table Foreign key: Emp_no Field name Emp_no password Designation Data type int Varchar(6) Varchar(10) Constraint Primary key
Employee Table Primary key: Emp_no
COLUME NAME Employee_no Employee_name Designation Salary
DATA TYPE int Varchar(20) Varchar(20) Float
CONSTRAINT Primary Key
Job _allocation Table Foreign key: Emp_no,event_id
COLUME NAME Event_id Employee_no Time Date Venue Location
DATA TYPE Int Int Float Date Varchar(25) Varchar(20)
CONSTRAINT Foreign Key Foreign Key
Add_event(Event maintenance)Table COLUME NAME Event_name Event_type Event_item amount DATA TYPE Varchar(25) Varchar(30 varchar(30) Varchar(50) CONSTRAINT
Add _venue Table COLUME NAME Event_name location Venue_name DATA TYPE Varchar(25) Varchar(30 varchar(30) CONSTRAINT
Amount _Calculation Table Foreign key: User_id
COLUME NAME User_id Cor_amount Wed_amount Ac_amount Cat_amount Venue_find_amount Trans_amount Venue_desgn_amount Tot_amount
DATA TYPE Int Float Float Float Float Float Float Float float
CONSTRAINT Foreign key
Feedback Table Foreign key: User_id COLUME NAME User_id User_name Feedback DATA TYPE Int Varchar(15) Varchar(40) CONSTRAINT
