Subject Code : COM636
Assignment Task :

Tasks

Task 1: Distributed Database Design                                      

Reliable Printing is a large printing company that does work for book publishers in Europe. The company currently has 50 offices, most of which operate autonomously, apart from the salaries which are paid by the head office in each country. Reliable Printing job consists of printing books or part of books. A printing job requires the use of materials, such as paper and ink, which are assigned to a job via purchase orders. Each printing job has several purchase orders associated with it. Similarly each purchase order may contain several purchase items. 

At present Reliable Printing use a centralised database and all offices access the details from the centralised server. The schema is as follows which lists the attributes for each entity along with the primary key and foreign keys:

 

To improve the sharing and communication of data, the company is thinking about implementing a Distributed DBMS. You have been asked by the Managing Director to investigate the data distribution requirements and provide expert advice on the potential use of Distributed Database System and Data Distribution scheme for Reliable Printing. 

 

  1. Write a report critically analysing the potential advantages and disadvantages of implementing a Distributed Database System and evaluating various data distribution options for Reliable Printing over a Distributed Databases System. Your report should recommend an appropriate data distribution solution for Reliable Printing with relevant justification.  

  2. Present your data distribution scheme in-line with your recommended solution using a diagram representing the nodes (please note you don’t have to represent 50 nodes) and data to be placed in the individual nodes or with the help of SQL statements.

 

Task 2: Data Warehouse  

A shipping company keep the details about the customers, products, location and shipper details. They are planning to design a data warehouse to analyse the shipment details. Initial analysis has resulted in identifying the dimensions like customer, time, product, from location, to location, and shipper to measure quantity, weight, cost, and charge. Cost is the cost of shipping, and charge is the shipping fee charged to the customer. Some of the dimensions are listed below with some recommended attributes.

 

This Computer Science Assignment has been solved by our Computer Science  Experts at UniLearnO. 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.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.

Eureka! You've stumped our genius minds (for now)! This exciting new question has our experts buzzing with curiosity. We can't wait to craft a fresh solution just for you!

  • Uploaded By : Grace
  • Posted on : July 17th, 2019

Whatsapp Tap to ChatGet instant assistance