CST2355 - Database Systems - Group Lab

Assignment Task

Assignment Overview:

Group Lab Assignment 2 will give you a chance to work in a team of 2 or 3 students to create a database application consisting of a Microsoft Access application that uses a separate Oracle 19c database to store application data in linked tables rather than in the Microsoft Access file itself.

In addition to your original tables from Group Lab Assignment 1, you will need to create a set of ‘views’ in Oracle that correspond to the fields from your original tables. This means your previous Access application should work if the linked tables are updated to point to the new Oracle Views.

You will also be creating a set of triggers (and stored procedures if desired) to allow INSERTS, UPDATES, and DELETES to the views so that if a value of a field gets changed, a history of those changes is kept in a new set of tables to store the multi-valued fields. We will be putting timestamps on the updates, so that we have a history of when each value was valid.

Task

1. Introduce at least one multi-valued historical data field in a table that is part of each of the following 3 types of relationships: Is-a, contains, is-related-to. This will mean that you have to update the forms that use those 3 tables to use your new view for each of the tables.

2. For each of the multi-valued field examples get your original group assignment 1 application still able to work using the new VIEWs. You will need to build a set of INSTEAD OF triggers for each these new views to handle the SELECT, INSERT, UPDATE, and DELETE commands sent from your application to the database.

3. Update your forms for editing each of the three original tables to have buttons or some other forms so that you are able to look at the historical data for each field in a new pop-up form specific to that field (with start and end timestamps).

This IT Computer Science Assignment Help has been solved by our IT Computer Science Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.