Title : University Library Database Management System
Team Members : Sanjay Chari, Athul Sandosh, Aditya Shankaran
Phase 1: The required documents for Phase 1 can be found in the Phase-1 folder.
Phase 2: Instructions for Phase 2: (1) Login as user postgres on the terminal by executing the command $psql -U postgres postgres and type system password when prompted for password.; (2) Type the command "\i Phase-2/create_project.sql" to create database and tables.; (3) Type the command "\i Phase-2/insert_project.sql" to populate the tables.; (4) Type the command "\i Phase-2/queries.sql" to view the output of the queries.; (5) The screenshots of the UI can be found in the folder Phase-2/UI Screenshots.;
Phase 3: Instructions For Phase: (1) Save the folder Phase-3 inside the htdocs folder of your XAMPP folder. (2) Open the file Phase-3/DBMS_PROJECT/Login_v_16/Login_v_16/login.html. You will be asked to login as faculty, or as student, or as admin. (3) Complex Queries have been incorporated as part of the UI, in the various PHP files (around 7).5 additional complex queries can be found in Phase-3/complex-queries.sql. (4) The final report and ppt can be found in the Phase-3 folder.