Process New Booking
Purchases Record (Joined Data)
| Trx ID | Client Name | Package Booked | Amount (BDT) | Date | Method |
|---|---|---|---|---|---|
| #GH-1005 | Rafiq Uddin | Sylhet Nature Retreat | ৳18,500.00 | 2026-08-13 | Cash |
| #GH-1004 | abdul hannan | Chattogram & Bandarban Explorer | ৳15,000.00 | 2026-08-13 | bKash/Nagad |
| #GH-1003 | Shafiqul Islam | Chattogram & Bandarban Explorer | ৳15,000.00 | 2026-08-12 | Cash |
| #GH-1002 | Nusrat Jahan | Sylhet Nature Retreat | ৳18,500.00 | 2026-08-11 | Bank Transfer |
| #GH-1001 | Rahim Uddin | Cox's Bazar Premium Getaway | ৳25,000.00 | 2026-08-10 | bKash/Nagad |
Register New Customer
Customers Directory (Customers Table)
| ID | First Name | Last Name | Phone | |
|---|---|---|---|---|
| 6 | Rafiq | Uddin | rafiquddin@gmail.com | 01513265478 |
| 4 | abdul | hannan | ahannanshakib@gmail.com | 01879000687 |
| 3 | Shafiqul | Islam | shafiq.islam@email.com | 01933445566 |
| 2 | Nusrat | Jahan | nusrat.j88@email.com | 01822334455 |
| 1 | Rahim | Uddin | rahim.uddin@email.com | 01711223344 |
Complete Package Details (Multi-Table Join)
This table joins Packages, Locations, Hotels, Transportations, and Activities.
| Package ID | Package Name | Destination City | Partner Hotel | Transport | Included Activity | Total Price (BDT) |
|---|---|---|---|---|---|---|
| PKG-01 | Cox's Bazar Premium Getaway | Cox's Bazar | Ocean Paradise Hotel & Resort | US-Bangla Airlines | Marine Drive Sightseeing | ৳25,000.00 |
| PKG-02 | Sylhet Nature Retreat | Sylhet | Grand Sultan Tea Resort | Novoair | Ratargul Swamp Forest Tour | ৳18,500.00 |
| PKG-03 | Chattogram & Bandarban Explorer | Chattogram | Radisson Blu Bay View | Sonar Bangla Express | Bandarban Chimbuk Hill Tour | ৳15,000.00 |
Activities Table
| ID | Activity Name | Cost |
|---|---|---|
| 1 | Marine Drive Sightseeing | ৳1500.00 |
| 2 | Ratargul Swamp Forest Tour | ৳1200.00 |
| 3 | Bandarban Chimbuk Hill Tour | ৳2500.00 |
Hotels Table
| ID | Hotel Name | Rating |
|---|---|---|
| 1 | Ocean Paradise Hotel & Resort | 5 Star |
| 2 | Grand Sultan Tea Resort | 5 Star |
| 3 | Radisson Blu Bay View | 5 Star |
Locations Table
| ID | City | Country |
|---|---|---|
| 1 | Cox's Bazar | Bangladesh |
| 2 | Sylhet | Bangladesh |
| 3 | Chattogram | Bangladesh |
️ Transportations Table
| ID | Type | Provider Name |
|---|---|---|
| 1 | Air | US-Bangla Airlines |
| 2 | Air | Novoair |
| 3 | Train | Sonar Bangla Express |