Learn smart - Learn online. Upto 88% off on courses for a limited time. View Courses
New User? Start here.
Error goes here
Please upload all relevant files for quick & complete assistance.
1 Computing Faculty of Arts, Science and Technology BSc (Hons) Computing, Computer Science Level: 6 Module: COM 6 ...
1 Computing Faculty of Arts, Science and Technology BSc (Hons) Computing, Computer Science Level: 6 Module: COM 636 Distributed Data Assignment: 1 Issue Date: 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 least 70% 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 Comments: Grade / Mark (Indicative: may change when moderated) 2 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 Systems. Tasks 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 purchase items. 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) Where: 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 3 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 statements. 10% 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 ) 4 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 Schema. (b& c - Schema Diagram s 15% ) Guidance 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 Submission 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 Student Handbook). Learning Outcomes 5 1. Critically assess some of the more advanced developme nts in database technology, e.g. Distributed databases, Multidimensional Database, Multimedia Databases, Mobile Databases 2. Evaluate the current issues associated with theory to practical implementations in database research. 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 - management) 9. Numeracy Assessment Criteria In order to achieve an A grade, the work must be excellent in almost all respects, only very minor limitations. 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 recommend.