Bookselling database website in php

**Project Description** Your task is to develop an Internet bookstore (similar to [login to view URL]) where the Internet users can purchase their favorite books. The site will include html web pages and use **PHP **to link to a **PostgreSQL** database. The system must support the following basic functionalities: 1) customer account creation 2) customer login and logout 3) book searching 4) shopping basket 5) checkout and payment In addition, you may want to provide information such as F.A.Q, service contact ***1. Design Phase:*** * Set up a project homepage, describing the overview of your system, the web pages you will develop and the kind of reports you plan to support. * Create an entity-relationship diagram for the model you plan to use in your system, showing cardinality constraints. * Design the relational (or object-relational) schema, and document it using the standard table representation (giving column headings and a sample tuple for each relation, underlining primary keys, and using arrows to represent foreign keys), showing security and integrity constraints. * Create an SQL definition of the data model, specifying attribute types, keys, foreign keys, constraints, and a sample value for each attribute given as a comment. * Write SQL queries to implement your sample queries. ***2. Implementation Phase:*** * System development. * You need to design and implement your own advanced functionalities and web designs which need to be clearly mentioned in your report. * Final report submission. **Project Files** Project files need to be stored in your **webfiles** directory and will use on a PostgreSQL database. Corresponding web URL: <[login to view URL]> ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform it will be ran on linux