5th_sem_database_design.drawio
5th_sem_database_design.drawio
M to M
M 1
User 1 1 Plan
M to 1
M 1
User 1 `1 Admin
M to 1
M 1
User 1 M Feedback
1 to M
1 1
User 1 1 Payment
1 to 1
1 1
Plan 1 M Adventurerv
1 to M
1 1
Plan 1 1 Admin
M to 1
M 1
Plan 1 M Feedback
1 to M
1 1
Plan 1 1 Payment 1 to 1
1 1
Admin 1 M Adventurerv 1 to M
1 1
Admin 1 M Feedback
1 to M
1 1
Admin 1 M Payment 1 to M
1 1
Adventurerv 1 M Feedback
1 to M
1 1
Adventurerv 1 1 Payment 1 to 1
1 1
9.User updates profile information.
0.0
2.Sahyadri Rovers Website processes registration data
8.Access granted or error message to the user.
Sahyadri Rovers Website
10.Sahyadri Rovers Website updates profile informati
4.Confirmation message to the user.
12.Confirmation of profile update 7.Credentials are checked against the User Database
1.0
2.0 conditions
2.Request to accepts terms and
Registration &
7.access grantedlogin
The system lists all the available plans related to the chosen adventure
12.the system and trekking
retrieves types.
specific details about that plan
13.the system confirms the booking of the selected plan for the user.
11.User selects a plan Plan Database
14.system requests user to personal details and the details of the members
16 .user details and plan stored in user data base
User Database
11.user enters the feedback 8.Booking Confirm
1.Based on the selected plan the system send the payment request
12.user feedback stored in
5.System send the amount to be paidthe database
Feedback Database
3 . access granted
Can change , Modify ,Create plans
enter admin login datils
6.all the changes, modifications and Creations of the plan stored in the data base
5.0 Admin MasterAdmin Database
Admin
4. access granted to all the data base 2. verifies admin login details
User Database 1.user report
2.Admin report
Admin Database
3.Payment report
6.Payment Reports
Plan Database
7.Feedback report
Feedback Database