FIT9132 Introduction to Databases Assignment 2 - Creating, Populating and Manipulating Databases

Purpose

Students will be asked to implement, via SQL, a small database in the Oracle

RDBMS from a provided logical model case study, followed by the insert of

appropriate data to the created tables. Once populated the database will be used to carry out specified DML commands and make specified changes to the

database structure via SQL. Students will then use SQL and NoSQL to write queries to produce specified output. This task covers learning outcomes:

1. Apply the theories of the relational database model.

3. Implement a relational database based on a sound database design.

4. Manage data that meets user requirements, including queries and transactions.

5. Contrast the differences between non-relational database models and the relational database model.

Your task

This is an open book, individual task. The final output for this task will be a set  of tables and data implemented in the Oracle RDBMS. In addition students will   create a set of relational (RA and Oracle) and non relational (MongoDB) queries which meet the user requirements.

Value

40% of your total marks for the unit

Due Date

Wednesday, 5th June 2024, 11:55 PM

(note: staff support is unavailable after business hours)

Submission

●   Via Moodle Assignment Submission

●    FIT GitLab check ins will be used to assess history of development

Assessment

Criteria

●   Application of relational database principles.

●    Handling of transactions and the setting of appropriate transaction boundaries.

●   Application of SQL statements and constructs to create and alter tables including the required constraints and column comments, populate

tables, modify existing data in tables, and modify the "live" database

structure to meet the expressed requirements (including appropriate use

of constraints).

●   Application of relational algebra operations to produce outputs that meet user requirements

●   Application of SQL select statements to produce outputs that meet user requirements.

●    Mapping of relational database data into non relational database data structure.

●   Application of MongoDB operations to produce outputs that meet user requirements.