COMP9120 Database Management Systems Assignment 2: Database Application Development

COMP9120 Database Management Systems

Assignment 2: Database Application Development

Group assignment (15%)

Introduction

The objectives of this assignment are to gain practical experience in interacting with a relational database

management system using an Application Programming Interface (API) (JDBC). This assignment additionally

provides an opportunity to use more advanced features of a database such as functions.

This is a group assignment for teams of 3 members. It is assumed that you will continue in your Assignment

1 group. You should inform the unit coordinator as soon as possible if you wish to change groups.

Please also keep an eye on your email and any announcements that may be made on Ed

wei: skyrainblue

Task 1: The Fine Food Kitchen (FFK) System

In this assignment, you will be working with the FFK system for staff use that you will be developing. The

system requires work in numerous areas, including the interaction with the database. Your main task in this

assignment is to handle requests for reads and writes to the database using your user interface (UI). We first

describe the main features that the FFK System should include from a UI perspective, and then discuss where

the majority of your database code needs to be implemented

 

Task 2: Functions Implementation

Core Functionality

In this assignment, you are provided with a Java skeleton project that must serve as the starting point for your

assignment. Your task is to provide a complete implementation for the

file

PostgresRepositoryProvider.java, as well as make any modifications necessary to the database

schema (i.e., FFKSchema.sql). Specifically, you need to modify and complete these five functions:

1. checkStaffLogin (for login)

2. findMenuItemsByStaff (for viewing menu items list)

3. findMenuItemsByCriteria (for finding menu items)

4. addMenuItem (for adding menu item)

5. updateMenuItem (for updating menu item)

wei: skyrainblue