数据库代写 | ISYS1101/ 1102 Assignment 4: Database Optimisation Project

本次澳洲代写是Oracle + mongoDB数据库设计相关的一个assignment

Overview

The objective of this assignment is to reinforce what you have learned in the lectures and tute/lab sessions. Specifically, it involves examining a case study, developing the backend database, and demonstrating how to optimise the database.

The main emphasis in this assignment is the database backend.

Assessment Criteria

This assessment will determine your ability to:

  1. analyse the requirements outlined in the problem description;
  2. interpret a logical design, implement it into an SQL DDL, and populate with data;
  3. identify common queries, implement, analyse and optimise these queries through the use of partition, indexing, and other mechanisms;
  4. implement triggers and stored procedures;
  5. create views;
  6. design a MongoDB collection to support efficient analysis of user data
  7. write MongoDB queries;
  8. write a research report explaining your design.

Learning Outcomes

This assessment will assess how you attained the following course learning outcomes:

CLO 1: apply advanced data analysis and modeling concepts, physical design, integrity, and transaction management.
CLO 2: create triggers, stored procedures and functions to enhance the usability of a database;
CLO 3: apply techniques for efficient storing, accessing, securing, and recovering of data;
CLO 4: build an efficient database application with an emphasis on storage management, indexing, and query optimisation;

Assessment Details

Consider the scenario below:

  • You are required to model a backend database for a simplified version of an online auction site similar to Ebay (called Ebay-Lite).
  • Users should be able to register as buyers and sellers using a unique username.
  • Sellers can place items up for auction, while bidders can place bids on items.
  • In this simplified version there is no need to deal with reserve prices.
  • Items belong to a category, which can have zero or more sub categories, but each category has only one super category.
  • Eg. A used climbing harness could belong to the category “Sports and Fitness” which has a sub category of “Outdoor Equipment”, which in turn has sub categories of both“Climbing Equipment” and “Safety Equipment” Sellers can have a business with an associated business number and address.
  • When bidders place a bid, this is identified by the bidNo and the ItemID combination.
  • Winning bidders can leave feedback with an integer rating (out of 5) and a comment about the sale.

Below is a Logical design of the database system:


程序代写代做C/C++/JAVA/安卓/PYTHON/留学生/PHP/APP开发/MATLAB


本网站支持淘宝 支付宝 微信支付  paypal等等交易。如果不放心可以用淘宝交易!

E-mail: itcsdx@outlook.com  微信:itcsdx


如果您使用手机请先保存二维码,微信识别。如果用电脑,直接掏出手机果断扫描。

blank

发表评论