COS60009 Data Management for the Big Data Age Assignment

Reference no: EM132422219

COS60009 - Data Management for the Big Data Age - Swinburne University of Technology

Assignment Description

This is an individual assignment. Students are referred to the Faculty's policy on plagiarism. The aim of this assignment is to develop skills to use XML (and JSON) to design and query semi-structured data, and to evaluate the difference between document- based NoSQL databases and SQL databases.

Task 1: XML and DTD

A simple database for a company is described below:

The database is part of a company information system, and contains four tables; Division describing the divisions of the company, Project describing the projects within the divisions, Employee containing information about employees within the divisions, and Assign describing employees' involvement in projects. The schema for each of the tables is shown below, with the primary key attributes underlined, the foreign key attributes in italic font, and some more information about each table.

You are required
Design a proper DTD called company.dtd for the above relational database schema. The valid XML documents under this DTD must have a tree structure with as much nesting as possible. The DTD must also capture all the primary key and foreign key constraints.
Populate an XML document called company.xml by referring company.dtd. It has at least 2 divisions. Each division has at least 2 projects and 3 employees. Each project has at least 2 employees in the same division working on it, and each employee works for at least 1 project. You are required to use company.dtd to validate company.xml externally. The domains for all attributes described above can be used to input values of attributes.

Task 2: XPath and JSON

For the XML document classes.xml shown below, write the XPath expressions for the following queries.
a) Find titles of all classes.
b) Find the classID of all classes with "Doug" as an instructor.
c) Find titles for those classes with "yes" in attribute req of credits.
d) Find titles for those classes with more than one instructor.

Convert the XML document classes.xml to its JSON format.

Attachment:- Data Management for the Big Data Age.rar

Reference no: EM132422219

Questions Cloud

What is the sample standard deviation : What is the sample standard deviation, rounded up to the nearest integer?

Optain a point estimate for the porportion of adults : Question info: in a poll, 250 of 1000 randomly selected adults aged 18 and over stated that they believe there is too little spending on national defense.

Determine the gasoline mileage : Determine the gasoline mileage, in miles per gallon, that make up the middle 75% of mileages for this hybrid car.

What is the class interval : The highest value is 1080 and lowest value is 960. What is the class interval? Please provide the complete solution of this problem.

COS60009 Data Management for the Big Data Age Assignment : COS60009 Data Management for the Big Data Age Assignment Help and Solution, Swinburne University of Technology - Assessment Writing Service

Probability of selection and a sample of size : A population consists of 5 units: X = 5, 7, 9, 11, and 13. All units are given equal probability of selection and a sample of size 2 is selected

Determine the combination of first baseman : Using linear programming (microsoft excel Solver) determine the combination of first baseman's gloves and catcher's glove that result in the maximum possible

Majority of the population supports the governor : Explain why the following statement is true: The 95% confidence interval for a poll suggested that support for Governor Garcia is between 55% and 60%.

What is the standard error of the mean in experiment : What is the standard error of the mean in this experiment? What is the probability that the sample mean is between $3.78 and $3.86?

User Account

All Pages