Assignment Instructions

SWE5104: Advanced Database and Big Data.

Learning Outcomes Assessed
LO3: Distinguish between and appraise NOSQL and OODBMS solutions to a given problem.

Scenario:
Fast Forwarding Ltd. is a global freight forwarding company based in the UK for over 50
years. The company offers worldwide freight service including land, sea and air from the
offices in Asia, Europe and North America. The company has over 100 logistic partners
through its own offices and agencies. They ship thousands of containers per annum
throughout the globe.

The company goal is to full-fill any size of the consignment to any country. Currently, Fast
Forwarding is using an in-house management system to support customer 24/7 throughout
the globe. The company also use multiple software components such as databases, track and
trace and payment systems, from third parties. As the business growing every year, the
company produces a high volume of data, which needs to be managed efficient manner. The
management has decided to improve the existing management system and build a modern
information management system to meet the future goal of the company. The proposed
system requires the following functionalities.
• To be adaptable to the growth of the company
• To have appropriate database systems to meet the expansion plan of the company
• To have modern database systems that are scalable and capable of storing various
types of data
• To visualise the system performance
• To have the solution to handle various types of databases systems
• Customer must be able to track and trace their consignments

Project Task: Create and compare databases (LO3) (25% of overall Mark)
Company is currently using RDBMS to perform their daily tasks that include accounting,
tracking, storing freight data, customer information etc. However, with the rapid growth of
the company operations globally, data is coming in various formats, shapes and speed, which
may require to deploy different types of database systems like NoSQL and OODBMS. The
company needs you to create prototype database models in RDBMS, NoSQL and OODBMS.
You are asked to create a SQL and NoSQL database

  1. ERD and SQL script for MySQL with some dummy data (at least 10 rows)
  2. Create relevant NoSQL database (e.g., MongoDB) using your ERD and MySQL data
  3. Create an object diagram for the same ERD
    The prototype ERD should be constructed using the following entities. You may add extra
    entity if you require for the solution however, you must justify your choice.
    • Customers
    • Orders
    • Packages
    • Locations
    • Routes
    • Transports/transport options/transport media
    • Schedule
    • Containers
    • Container route

Write a report of 2500 words (including diagrams and tables) to inform the company
management that analysis and distinguishes between RDBMS, NoSQL and OODBMS. The
report should reflect your experience to find a solution to the company’s current systems
and future solution. You need to research relevant database systems to recommend an
appropriate solution to the Fast Forwarding along with the experience of building this
prototype system.
The report must be in either MS Word or PDF format in a single document. The report should
contain all the diagrams with a brief explanation or justification. The SQL script and NoSQL
documents should be added to the end of the report as appendices (should not include in the
word count).
You must submit your assignment through the appropriate Moodle Turnitin link by 23:55 on
18 December 2020.

The post SWE5104: Advanced Database and Big Data first appeared on Krita Infomatics.

SWE5104: Advanced Database and Big Data

Calculate Price


Price (USD)
$

Why Choose Us For Your Assignment?

Privacy

We value all our customers' privacy. For that reason, all information stays private and confidential and will never be shared with third parties.

Punctuality

With our service you will never miss a deadline. We use strict follow-ups with our writers to ensure that all papers are submitted on time.

Authenticity

We have no tolerance for plagiarism. All papers go through thorough checking to ensure that no assignments contain plagiarism.

Money Back

You feel unsatisfied with your results? No worries. We offer refunds to our customers if any paper is not written according to the instructions.

Clients Love Us

Client #121678
Client #121678
Read More
This is by far the best I have ever scored in a custom essay. I am surprised the writer handled this assignment so well despite the short notice. I will definitely use your service next time.
Client #21702
Client #21702
Read More
When I was recommended to you by my friends, I wasn't sure you could deliver excellent results for Masters research papers until I submitted my first order. I am all yours now.
Client #20730
Client #20730
Read More
Excellent Services! You are the only assignment helper I can rely on. I have worked with many before and your services are exceptional. I have recommended you to my friends and the results are similar.
Client #20387
Client #20387
Read More
I rarely write reviews online but your services are worth promoting. My paper was so urgent I was sure I was gonna miss the deadline but you turned things around. You are awesome!
Client #20189
Client #20189
Read More
I am a satisfied customer. I know I should have given a 5 star because you deserve it but I will give 4.6 because I almost missed a deadline because of a revision. Luckily it was minor and the writer acted promptly.
Client #20187
Client #20187
Read More
Great paper but there is still some room for improvement. I am impressed by your fast responses and how you tacked my concerns professionally. Thank you for being among the few genuine essay writing service providers.
Client #19783
Client #19783
Read More
I can't thank you enough for being a great part of my college life. I recommended you to two more of my friends. I am sure they will be making their orders soon. I love the fact that you offer free pages for referrals. I will be referring a few more and maybe I won't have to pay for my next two paper, LOL.
Previous
Next