SQL PROJECT Presentation Of the Food.pptx

Sql project presentation of food database of the fc road street where customers buy online food

1. THE TOURIST GUIDE DATABASE OTHERWISE

2. THE MAHA-GUMAKKAD TEAM SHREYASH BABHULGAONKAR SHIVANI SHUKLA EESHANDIEP GREWAL PRATHMESH BENDBHAR KAIVALYA TOLMARE

3. AIM : To develop a comprehensive database schema that supports efficient management and retrieval of tourism-related data, including places, categories, reviews, users, tourists, hotels, bookings , attractions, and visits. OBJECTIVES : Integration of Tourism Entities Data Integrity Enhanced Query Capabilities Scalability and Expandability Application Flexibility Normalization and Efficiency

4. Tables Included : 1.Tourists Table 2.Hotels Table 3.Bookings Table 4.Attractions Table 5.Visits Table

5. 1.Tourists Table CREATE TABLE TOURISTS ( TOURIST_ID NUMBER(3) PRIMARY KEY, NAME VARCHAR(100 ) NOT NULL, EMAIL VARCHAR(100 ) CHECK(EMAIL LIKE ‘%@%’), PHONE NUMBER(10) CHECK(LENGTH(PHONE)=10), COUNTRY VARCHAR(50 ), );

6. 2.Hotels Table CREATE TABLE HOTELS ( HOTEL_ID NUMBER(3) PRIMARY KEY, NAME VARCHAR(100) NOT NULL, LOCATION VARCHAR(100), RATING NUMBER(1), PRICE_PER_NIGHT NUMBER(7,2 ) CHECK ( PRICE_PER_NIGHT>0), );

7. 3.Bookings Table CREATE TABLE BOOKINGS ( BOOKING_ID NUMBER(3) PRIMARY KEY, TOURIST_ID NUMBER(3), HOTEL_ID NUMBER(3), CHECK_IN_DATE DATE, CHECK_OUT_DATE DATE, TOTAL_PRICE NUMBER(10,2), FOREIGN KEY (TOURIST_ID) REFERENCES TOURISTS(TOURIST_ID), FOREIGN KEY (HOTEL_ID) REFERENCES HOTELS(HOTEL_ID ), );

8. 4.Attractions Table CREATE TABLE ATTRACTIONS ( ATTRACTION_ID NUMBER(3) PRIMARY, NAME VARCHAR(100) NOT NULL, LOCATION VARCHAR(100), DESCRIPTION CLOB, ENTRY_FEE NUMBER(10,2) CHECK(ENTRY_FEE>0), );

9. 5.Visits CREATE TABLE VISITS ( VISIT_ID NUMBER(3) PRIMARY KEY, TOURIST_ID NUMBER(3), ATTRACTION_ID NUMBER(3), VISIT_DATE DATE, FOREIGN KEY (TOURIST_ID) REFERENCES TOURIST(TOURIST_ID), FOREIGN KEY (ATTRACTION_ID) REFERENCES ATTRACTIONS(ATTRACTION_ID ), );

10. CONCLUSION: In the phase-1 of Project we have successfully created following tables: 1.Tourists Tables 2.Hotels Tables 3.Bookings Tables 4.Attractions Tables 5.Visits Tables This integrated schema now encompasses a broader range of tourism-related entities and relationships, allowing for comprehensive data management and querying capabilities. Adjustments can be made based on specific application requirements or additional entities that may need to be included in the database schema.

11. ANY QUESTIONS ?

12. THANKS FOR YOUR