Programming Homework Help

Assignment 1 download provides experience with creating PostgreSQL tables using the pgAdmin client. You need to complete 3 partial CREATE TABLE statements and write 4 new CREATE TABLE statements. You need to read the assignment carefully to see the details required for the CREATE TABLE statements. In addition to writing the statements, you need to populate the tables by executing the provided INSERT statements.

Before starting assignment 1, you should install the PostgreSQL server and pgAdmin client and read the background document about the Expense Reporting database.

PostgreSQL installation instructions download for Windows
Mac OS users should use the Postgres.app tutorial (Links to an external site.) or the MacOS tutorial for PostgreSQL.
Expense Reporting Database download background document
INSERT statements download for the Expense Reporting Database tables
Instructions to use remote desktop download for PostgreSQL and pgAdmin client. You can use remote desktop if you cannot install the PostgreSQL server and pgAdmin client.

To submit your assignment, please follow these steps:

You should ensure that your submitted file contains snapshots showing subsets of rows for each table. You can include the snapshots after each CREATE TABLE statement or together at the end of the document.
You will lose substantial points for syntax errors. A syntax error prevents execution of the CREATE TABLE statement.
Submit your CREATE TABLE statements in one document file with a naming scheme like “LastNameFirstNameA1″ as the file prefix where LastName and FirstName are your last and first name respectively. Make sure that you use straight quotes, not smart quotes (default in MS Word). PostgreSQL does not recognize smart quotes so you will have syntax errors.