/Book-Crossing

Quicker for books with add-on functionalities

Primary LanguageTSQL

Book-Crossing

Logo

Quikr like application for books with some other functionalities

The frontend of this application is developed using PHP and css and in the backend lies a postgreSQL database which handles all the add, delete, update, search etc querries.

The database has all kinds of features like contraints, triggers, transactions, views etc which is fairly complex.

image

Organization


Documentation.pdf contains the database configured at backend for the site.
The main.html is the home page for the application.
Detailed information about tables, their schema, constraints and triggers has been specified.
The Sources for where data was obtained/scraped/generated have been mentioned in file how data is generated.txt.

Requirements


A working postgreSQL database and a browser to start the application
All the instructions and data to initialize the database are present in scripts in

DB/ 
tables/
trigger/

Contributing


  1. Fork it!
  2. Create your feature branch: git checkout -b my-new-feature
  3. Commit your changes: git commit -am 'Add some feature'
  4. Push to the branch: git push origin my-new-feature
  5. Submit a pull request :D

Credits


Devansh Dalal
Shivam garg
Prateek Chaudhry

Screenshots


image

image

image

image

image

All is well

second last

last