Learn smart - Learn online. Upto 88% off on courses for a limited time. View Courses
Error goes here
Please upload all relevant files for quick & complete assistance.
Faculty of Arts, Science and Technology
BSc (Hons) Computing, Computer Science
Module: COM 6 ...
Faculty of Arts, Science and Technology
BSc (Hons) Computing, Computer Science
Module: COM 636 Distributed Data
Review Date: Tutorial Sessions
Submission Dates: 04th April 202 1 before 10.30AM
Estimated Completion time: 72 Hours
Lecturer: Jason Davies
Verified by: Bindu Jose
To be completed by student:
I certify that, other than where collaboration has
been explicitly permitted, this work is the result
of my individual effort and that all sources for
materials have been acknowledged. I also
confirm that I have read and understood the
codes of practice o n plagiarism contained
within the Glyndŵr Academic Regulations and
that, by signing this printed form or typing my
name on an electronically submitted version, I
am agreeing to be dealt with accordingly in any
case of suspected unfair practice. I also certify
that my attendance for the module has been at
Na me: ..........................................................
Student Number: .........................................
Date Submitted: .........................................
Student Signature: ..........................................
Are extenuating circumstances being claimed? YES / NO
If YES, give reference number: --------------------------------------
To be completed by lecturer
Grade / Mark (Indicative: may change when moderated)
COM 617 : Assignment 1
This assignment will entail reading a range of academic papers, journals and books. You will
be writing reports and designing Distributed Database Systems and Data Warehouse
Task 1: Distributed Database Design (6 0%)
Happy Day Marketing is a large marketing company that has 50 consultancy offices across
Europe. Most of these offices operate autonomously, with the exception of consultant
salaries that are paid by the head offices in each individual country. The marketing
consulta ncy roles involve the generation and printing of reports using specific system tools
and applications. Each job that a consultant does will require the use of systems and
recourses such as application and software licences, paper and Ink for printing repor ts etc.,
these resources are assigned to a job via purchase orders. Each job will have multiple
purchase orders associated with it. Similarly, each purchase order may contain several
At present Happy Day Marketing use a centralised databa se 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 :
COUNTRY: (countryNo , countryName)
ITEM: (ItemNo , iDescription, AmountInStock , Price)
OFFICE: (OfficeNo , oAddress1, oAddress2, oAddress3, oPostCode, oTelNo,
oFaxNo, mgrSNo , countryNo )
STAFF: (StaffNo , fName, lName, sAddress1, sAddress2, sAddress3, sPostCode,
sTelNo, DOB, sPosition, NIN, taxCode, salary, Office No )
CLIENT : (Cli No , cName, cCity, cTelNo, cFaxNo, officeNo )
JOB: (JobNo , Job No , JobData, JobDescription, JobType, supervisorSNo )
PURCHASEORDER: (PoNo , JobNo , poDate)
PO_ITEM: (PoNo , ItemNO , quantity)
COUNTRY – contains details of each country that Happy Day Marketing operates in
(UK, France, Germany, Italy, Spain)
OFFICE – contains details of each office along with office managers staff number
STAFF – contains details of staff and the office they work
CLIENT – contains details of client and the office they are registered with
ITEM – contains the details of all materials , licences etc. that can be used in
consultancy jobs along with quantity in stock in its warehouse and price
JOB – contains details of the current job along with the details of supervisor staff
assigned to the job and job type (Normal or Urgent )
PURCHASEORDERS – contains purchase order details for each job
PO_ITEM – contains details of the items on the purchase order
To improve the sharing and commun ication of data, the company is thinking about
implementing a D istributed 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 Happy Day Marketing .
a. Write a report critically analysing the potential advantages and disadvantages
of implementing a Distributed D atabase System and evaluating various data
distribution options for Happy Day Marketing over a Distributed Database s
System . Your report should recommend an appropriate data distribution
solution for Happy Day Marketing with relevant justification .
50% (at least 1500 words)
b. 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
Task 2 : Data Warehouse (4 0%)
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 sh ipment details . Initial
analysis has resulted in identifying the dimensions like customer, time, product, from
location, to location , and shipper to measure qua ntity, weight, cost, and charge . C ost 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 .
Customer – (nam e, street, city, state, country)
Time – (day, week, month, year)
From_ Location – (street, city, state, country )
To_Locatio n – (street, city, state, country )
Shippe r – (name, company, street, city, state, country )
a. Discuss the concepts associa ted with dimensional modelling , it’s association with
Data Warehouse Design , and explain the Star Schema and Snow Flake Schema in
a data warehouse design context .
25% (at least 750 words)
b. Design a Star Schema for modelling the data warehouse for the shipping company
data structure . You must identify the FACT table with appropriate details and keys for
the Dimensions .
c. Using the principles of normalisation convert the Star Schema to a Snow flake
(b& c - Schema Diagram s 15% )
Students will get assistance to complete the tasks through the tutorial sessions. Drafts will
be reviewed and formative feedback will be given in the tutorial sessions . So you are
much less likely to obtain a good grade if you don’t attend the tutorial ses sions. Support your
work with relevant references from books, journals and other quality information resources
using the IEEE Referencing System .
Task 1 is weighted as 60%, Task 2 is weighted as 40% of Assignment 1. Failure to
complete any of the above tasks or sub tasks in time will result in a loss of marks
The assignment should be word -processed. This specification document should be filed at
the front of the assignment, with the front sheet (with your Name, Student Number, Date and
Signature) visible at the front.
Work must be word processed and submitte d as a single file via Turnitin link provided
through VLE by 30 nd November 2020 .
The Glyndwr policy on assignment submission will be rigidly adhered to (see yo ur
1. Critically assess some of the more advanced developme nts in database technology,
e.g. Distributed databases, Multidimensional Database, Multimedia Databases,
2. Evaluate the current issues associated with theory to practical implementations in
3. Explore advanced aspects of data wa rehousing, distributed data, data intensive
computing, remote access and personalised data; encompassing the principles,
research results and commercial application of the technologies.
Key skills for employability:
1. Written, oral and media communication sk ills
2. Opportunity, creativity and problem solving skills
3. Information technology skills and digital literacy
4. Information management skills
5. Research skills
6. Intercultural and sustainability skills
7. Career management skills
8. Learning to learn (managing personal a nd professional development, self -
In order to achieve an A grade, the work must be excellent in almost all respects, only very
In order to achieve a B+ grade, the work should show strength in most respects, but perhaps
has limitations in one or two areas. A good piece of work nevertheless.
In order to achieve a B grade, the work should be of a satisfactory standard, showing
strength in some areas, but pe rhaps let down by poor presentation, poor practical work, or
poor written explanations where required.
In order to achieve a C grade, the work should be of a satisfactory standard but may have
significant shortcomings in some areas. Nevertheless shows at least a basic understanding
of the concepts and a basic practical ability.
A Refer grade will be given to work that is just unsatisfactory
Enter the password to open this PDF file:
MyAssignmenthelp.com has emerged as one-stop solution for students in USA. We have assembled a team of experts to help students from different fields of study. With a pool of 3000+ experts, we are capable of providing top-notch quality plagiarism-free assignments within any short deadline. Our assignment writing services cover more than 100 subjects such as accounting assignment help, maths assignment help, economics assignment help, law assignment help and statistics assignment help.
On APP - grab it while it lasts!
*Offer eligible for first 3 orders ordered through app!
ONLINE TO HELP YOU 24X7
OR GET MONEY BACK!
OUT OF 38983 REVIEWS
Received my assignment before my deadline request, paper was well written. Highly