Updated Readme

1 files changed, 81 insertions, 2 deletions

diff --git a/README.md b/README.md
index b959d91..55a721d 100644
--- a/README.md
+++ b/README.md
@@ -1,2 +1,81 @@
-<H1>Class 12 CS project</H1>
-<H2>House keeping managament</H2>
\ No newline at end of file
+# Guest Review Management
+### A Class 12 CS project
+
+Guest review management in hotels is the process of collecting and analyzing feedback from guests about their stay at a hotel or other hospitality facility. This feedback can be used to identify areas for improvement and optimize the guest experience, as well as to build a positive reputation and attract new customers.
+
+To manage guest reviews effectively, hotels can use a software solution that automates and streamlines the process of collecting and analyzing feedback. One way to develop such a solution is to use Python, a popular programming language, and MySQL, an open-source database management system.
+
+# User Management
+
+ - Super User 
+ - House Keepers
+ - Guest
+
+# Working and setting up
+
+**[1]  Initial Setup**
+
+➔ **Super Admin End (Hotel)**
+
+	○ The Super admin (Hotel Manager) should create an account
+
+	○They should register the rooms within the account
+
+	○Admin Should Register housekeepers (Staff) and assign rooms to them
+
+	○Once this is finished, the hotel is equipped with Guest management system
+
+➔ **User End (Guest)**
+
+	○User should create an account
+
+	○ They should choose which room are they staying in
+
+	○ Now initial guest setup is done
+
+**[2]  Giving Reviews**
+
+	● This is done by the guest
+
+	● They got 5 questions to rate the amenities + they can add more suggestion to the review
+
+**[3]  Receiving and Analyzing Reviews**
+
+	Once the review is done the Admin and housekeepers can view and analyze it through the admin dashboard
+
+# Installation
+First u have to create the databases in MySql by these Commands:
+1.For the reviews
+
+    CREATE  TABLE reviews(
+    review_uid VARCHAR(255) PRIMARY  KEY,
+    hk_uid VARCHAR(255),
+    sa_uid VARCHAR(255),
+    dateAndTime DATETIME,
+    room int,
+    meal int,
+    hospitality int,
+    washroom int,
+    overall int,
+    remarks VARCHAR(255));
+
+2.For Managing Users
+
+    CREATE  TABLE userdetails(
+    user_uid VARCHAR(255) PRIMARY  KEY,
+    username VARCHAR(255) UNIQUE,
+    password  VARCHAR(255),
+    name  VARCHAR(255),
+    user_role VARCHAR(255),
+    sa_uid VARCHAR(255));
+
+3.For Managing Different Hotels
+
+    CREATE  TABLE hslocations(
+    hsl_uid VARCHAR(255) PRIMARY  KEY,
+    sa_uid VARCHAR(255) NOT  NULL,
+    hk_uid VARCHAR(255),
+    place_name VARCHAR(255) UNIQUE);
+
+## Now Run the code and :)
+# Made with ❤️ by Rishi, Hamda, Leen, Sidhan, Ziya