DBMSPPT database creatiobn of data stststics and

Structure Overview A 300-word essay typically consists of an introduction, a body, and a conclusion. This structure helps organize thoughts clearly and express ideas effectively. source
📚 Example Insights Various examples illustrate how to create a 300-word essay, showcasing different themes and writing styles, such as personal narratives or descriptive pieces. source
🌳 Descriptive Techniques When writing descriptively, it’s important to focus on sensory details and emotional connections, enhancing the reader's experience and engagement. source

1. Atria Institute Of Technology Department of Masters of Computer Applications DATABASE MANGMENT SYSTEM Presentation On Jaipur Journeys: Unveiling the city of kings Presenters: Rohith H (1AT23MC080) Vinay Kumar A (1AT23MC107) Faculty: Prof. SWATHI.M Atria Institute of Technology

2. INTRODUCTION a Database Management System (DBMS) is very important. The DBMS will store and manage information related to Jaipur’s history, landmarks, events, cuisine, and login/signup. 1. Introduction to DBMS for jaipur Heritage Project A Database Management System (DBMS) allows for efficient data storage, retrieval, and management. In this project, the DBMS can help store information such as: Historical data of jaipur Details of historical landmarks Events and festivals related to the city's heritage User data for authentication (login/registration) This database system will consist of tables that store different types of information, with relationships between them represented using Entity-Relationship (ER) Diagrams .

3. ER Diagram for Heritage of Jaipur Entities in the ER Diagram User : Stores user information (for login and registration). Landmark : Represents historical landmarks with details like name, description, location, and image. Event : Represents historical or cultural events in Pune (event name, date, description). Cuisine : Represents famous Pune dishes with details like name, description, and popularity. Relationships: User-Landmark : Users can mark or favorite certain landmarks. Landmark-Event : Events may be hosted at historical landmarks. Cuisine-Landmark : Certain landmarks might be associated with famous cuisine spots in Pune.

4. ER DIAGRAM 1 1 N N

5. Code implementation Login and signup CREATE TABLE users ( firstName varchar(50), lastname varchar(50), email VARCHAR(255) NOT NULL UNIQUE, password VARCHAR(255) NOT NULL );

6. TABLE REPRESENTATION Login page:

7. Thank you