CSE 532 -- Project Page

Please note: project assignments are available only through the Blackboard system.

There will be three projects, each using a different system. You are expected to install those systems on your laptop or in your Departmental or SBU account.

Project 1

Project 1 will be using the Flora-2 system.

Documentation:

• Flora-2 user's manual (PDF).

Project 2

For Project 2 you will be using the PostgreSQL DBMS.

Documentation:

• Manual: in HTML and in PDF.
• Always consult the list of SQL commands and, especially, CREATE TABLE and CREATE TYPE. Note that PostgreSQL types are rather weak compared to the SQL standard, but CREATE TABLE is quite powerful. In particular, tables can inherit from other tables and the non-standard WITH (OID=TRUE) feature is supported. This causes tables to have a special column called oid, which contains object Ids.
• FAQ

Project 3

For Project 3, you will be using the eXist-db XML DBMS.

Documentation:

• Manuals and tutorials.

Source code repository

You will be required to maintain your code in private Git repositories on Github Classroom (one repository per each part of the project). If you do not have a Github account, get one now, before things get very busy.

We recommend that you do not use command line interface to Git but rather one of the graphical front-ends, such as SmartGit or GitKraken, which work on all platforms. On Windows, you can also use TortoiseGit and SourceTree. The latter also works on the Mac. Some general Git tutorials:

• https://www.atlassian.com/git/tutorials
• http://www.vogella.com/tutorials/Git/article.html

• A video tutorial on Git.
• This tutorial is on using SmartGit with Bitbucket but it is basically the same with Github.

Note: for this project you will likely need only the basics like cloning, pulling, pushing, staging, and committing.