COM636 Distributed Data.

Learning Outcome 1: Critically assess some of the more advanced developments in database technology, e.g.Distributed databases, Multidimensional Database, Multimedia Databases, Mobile Databases

Learning Outcome 2: Evaluate the current issues associated with theory to practical implementations in database research.

Learning Outcome 3: Explore advanced aspects of data warehousing, distributed data, data intensive computing, remote access and personalised data; encompassing the principles, research results and commercial application of the technologies.

You will be writing reports and designing Distributed Database Systems and Data Warehouse Systems.

Tasks

Task 1: Distributed Database Design

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 consultancy 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 reports 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.