You may NOT use/access:
Failure to abide by these guidelines will result in a zero for the assignment and the incident will be reported to the university provost as a violation of the university academic integrity policy. A second incident of academic dishonesty (whether from this course or another computer science course) will result in an F in the course.
This assignment is the first in a series that will continue for the rest of the semester. You will be building a simple community book-selling website in which users can list books for sale (title, condition, and price) and interested shoppers can contact the seller to arrange for the sale.
At the end of this assignment you will have a reasonably good looking site with the following features:
CREATE TABLE books ( book_id SERIAL, title VARCHAR(1000) NOT NULL, condition SMALLINT NOT NULL, price NUMERIC(5,2) NOT NULL, created_by INT, created_at TIMESTAMP WITH TIME ZONE DEFAULT current_timestamp, updated_at TIMESTAMP WITH TIME ZONE DEFAULT current_timestamp, PRIMARY KEY (book_id) );
Example queries you'll need:
SELECT title, price FROM your_schema_name.books -- list title/price of all books INSERT INTO your_schema_name.books (book_id, title, condition, price) VALUES (default, 'Cool!', 3, 12.95) -- insert book into database
It would make sense for you to use the basic styling and page arrangement you used for your final web page from last semester, but you are welcome to branch out and do something different.
IMPORTANT: Although it can be tempting to tweak code in place after an assignment is due you should not do so. Since I am grading the files in-place on the server all I have to go on are the time stamps on the files. If you open a file and then save it (even without making changes) the time stamp is changed. If there is a tweak you feel has to be made then let me know what file and what change you want to make.