FIT9132 Introduction to Databases
Assignment 2 - Creating, Populating and Manipulating Databases
Full brief available Week 12 Monday 5PM
|
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.
|
|
Late Penalties
|
● 10% deduction per calendar day or part thereof for up to one week
● Submissions more than 7 calendar days after the due date will receive a mark of zero (0) and no assessment feedback will be provided.
|
|
Support
Resources
|
See Moodle Assessment page
|
|
Feedback
|
Feedback will be provided on student work via:
● general cohort performance
● specific student feedback ten working days post submission
● a sample solution
|