University | University of Wollongong (UOW) |
Subject | ISIT312: Big Data Management Assignment |
ISIT312: Big Data Management Assignment, UOW, Singapore: Consider the following conceptual schema of an operational database owned by a multinational real estate company
Task 1
Consider the following conceptual schema of an operational database owned by a multinational real estate company. The database contains information about the real estate properties offered for sale, owners of the properties, potential buyers who are interested in the properties, and real estate agents involved in the selling of the properties.
Whenever a property is put on the market by an owner, a description of the property is entered into an operational database. Whenever a property is purchased, its description is removed from an operational database.
The real estate company would like to create a data warehouse to keep information about the finalized real estate transactions, properties involved in the transactions, sellers/owners, and agents involved in the real estate transactions. The real estate company would like to use a data warehouse to implement the following classes of analytical applications.
(1) Find the total number of real estate properties sold per month, year, street, city, country, and agent involved.
(2) Find an average asked price of real estate properties sold per month, year, street, city, country, and agent involved.
Hire a Professional Essay & Assignment Writer for completing your Academic Assessments
(3) Find an average final price of real estate properties sold per month, year, street, city, country, and agent involved.
(4) Find an average period of time on the market of real estate properties sold per month, year, street, city, country, and agent involved.
(5) Find the total number of times each real estate property has been sold in a given period of time.
(6) Find the total number of buyers interested in purchases of real estate properties sold per day, month, year, street, city, country, and agent involved.
Task 2
An objective of this task is to create a conceptual schema of a sample data warehouse domain described below. Read and analyze the following specifications of a data warehouse domain.
A person is represented as either a patient or a medical worker or an administration worker. Medical and administration workers work in medical facilities that have a name, address, and possibly specialization. Each medical worker is described as a unique staff number at a facility, name, address, and phone number.
A patient visits a medical facility for the service of a health problem. Each service involves a patient, a medical worker, and an administration worker. The service can be a diagnosis, treatment, or checkup. A description and date of each service are recorded. Time spent on service and the costs are recorded as well.
Stuck with a lot of homework assignments and feeling stressed ? Take professional academic assistance & Get 100% Plagiarism free papers
Are you a student at the University of Wollongong (UOW) in Singapore struggling with your ISIT312 Big Data Management assignment? Look no further! Our TMA, individual assignments, essay writing service, and assignment help Singapore are tailored to meet your needs. Whether you're grappling with the conceptual schema of a multinational real estate company's operational database or any other aspect of your assignment, our team of experts is here to help you.
Tags:-
- Imagine that you are currently working for a precision medicine startup: Machine Learning Paper Review in Precision Medicine, Written Assignment 1, NUS, Singapore
- Go Business offers PSG solutions for enterprises in Singapore: Collective Intelligence and Entrepreneurship, Assignment 1, JCU, Singapore
- Design an ontology based on- Accidents can be categorised as chemical, electrical, fire, kinetic or liquid: Collective Intelligence and Entrepreneurship, Assignment 1, JCU, Singapore
- Project Control Monitoring, Assignment, HU, Singapore: Deliberate Project MONITORING AND CONTROL or PMC Identification
- DSM500: Final Project Report, Coursework 2, UOL, Singapore
- DSM080: Financial Markets, Assignment, UOL, Singapore: A grapefruit juice futures contract is for 15,000 pounds of frozen grapefruit juice
- DSM080: Financial Markets, Assignment, UOL, Singapore: The share price of a certain stock today is $42.50, and five-month European style call options with a strike price of $45 currently sell for $4.25.
- DSM080: Financial Markets, Assignment, UOL, Singapore: A trader who is working in the gold markets is able to borrow money at the interest rate of 7% per annum
- DSM080 Financial Markets, Assignment, UOL, Singapore: A dollar-based American corporation has decided that it will have to pay 6 million UK pounds in three months
- Principle of Finance Assignment, UCD, Singapore: National Gaming Inc. (National) operates the weekly lottery in the country
UP TO 15 % DISCOUNT