DBMS

Description

The purpose of this assignment is to set up a DBMS for the web based application from the previous two assignments. The new version assumes the application state is stored in a PostgreSQL database instead of a CSV file.

Here is the assignment criteria:

• If not already installed, install postgresql and the psycopg2 python module using the package manager.

• Copy the updated web application code somewhere appropriate. (code) somewhere appropriate.

• Configure postgresql so that the web application can connect. Here are the assumptions of the web application:

  • The user is csc510
  • The password is mysecret
  • The database name is qotd

• The qotd.v2 directory contains a file named populate_db.sql that must be used to populate the data in the PostgreSQLqotd database.

• Update any other configuration files as needed.

Turning in the Assignment

To submit your assignment, create a gzipped tar file named project7.tgz of a DIRECTORY named project7 containing the following:

• A file named README that contains a step-by-step description of the setup process. Make sure to include the file paths of any files you created or modified. Note any steps you took to verify that the above criteria are correct.

• A copy of any configuration files you created or modified.

Then submit that file to the appropriate folder on D2L.

Grading Criteria

• Correct implementation of the specification