Implement a distributed database system to support

Assignment Help Computer Engineering

Reference no: EM133218008

Question: A hospital uses an information system to store data about staff, patients and the treatments administered to patients.

The following relations (tables) are part of the global schema for the system.

PATIENTS (Number, Name, NHS_no, Amount_due, Dept_no, Doctor, Medical_Treatment)

DEPARTMENTS (Dept_no, Name, Location, Director)

STAFF (StaffNum, Name, Dept_no, Task)

Define the fragmentation schema as follows:

(a) DEPARTMENTS has a horizontal fragmentation by Location, with three (3) locations

(eg Lusaka, Livingstone and Ndola). Each department is managed by one director.

(b) There are several staff members in each department. STAFF has a horizontal fragmentation derived from that of DEPARTMENTS and a semi-join on the Dept_no attribute.

How can you be sure that the fragmentation is complete and disjoint?

(c) PATIENTS has a mixed fragmentation. Attributes Number, Name, NHS_no and Amount_due constitute a vertical fragmentation and hold the data required for accounting purposes. Attributes Number, Name, Dept_no, Doctor and Medical_treatment constitute a vertical fragment used for describing each care programme. This last fragment has a horizontal fragmentation derived from that of DEPARTMENTS and a semi-join on the Dept_no attribute.

What assumptions are required in order to assure completeness and dis-jointness?

(d) Give the reconstruction statements for each global relation from its fragments.

(e) Using Oracle Database Links, implement a distributed database system to support your design above. Populate the database with enough rows to demonstrate the correctness of the design by running queries that support the applications requirements.

(f) Suppose that applications in Ndola are only interested in accessing data about patients and the treatment they receive, while the Lusaka and Livingstone applications are interested in staff records and the patients they have treated. Outline a possible allocation scheme that would support these applications' needs.

Required:

You will be required to submit a report outlining your solution to the coursework
You will also be required to demonstrate your Distributed Data Management solution to your tutors

Reference no: EM133218008

Questions Cloud

Average wages of females : Does the earnings gap between the average wages of females and the average wages of males prove labor market discrimination? Why or why not?

Impacts on success of an individual business organization : An assessment of extent to which working in international environment impacts on the success of an individual business organization".

Which of the predictors are statistically significant : Which of the predictors are statistically significant in each model? If you wanted to create the most parsimonious model (i.e., the one that did the best job

What was the most reports on a single day : What was the most reports on a single day in that month - construct an API that you can run in your browser to show the number of adverse event reports

Implement a distributed database system to support : Give the reconstruction statements for each global relation from its fragments and implement a distributed database system to support your design above.

Read the article-practical ethical challenges : Reflecting on this week's readings, read the article, "Practical ethical challenges and moral distress among staff in a hospital COVID-19 screening service.

Describe the problems that a project manager will face : Describe the problems that a project manager will face when working with a virtual team that is located in another country.

What is the ceh methodology or system hacking steps : What is the CEH methodology or system hacking steps and What is Metasploit? Make one argument to block its use of it and another to encourage its use

Describe the tangible and intangible values : organization that is implementing a new computer system. Describe the tangible and intangible values that the organization seeks from the new system

User Account

All Pages