UP TO 15 % DISCOUNT

Get Your Assignment Completed At Lower Prices

Plagiarism Free Solutions
100% Original Work
24*7 Online Assistance
Native PhD Experts
Hire a Writer Now
ISIT 312: Big Data Management Assignment, SIM, Singapore Conceptual modeling of a data warehouse An objective of this task is to create a conceptual schema of a sample data warehouse domain described
University Singapore Institute of Management (SIM)
Subject ISIT 312: Big Data Management
Posted on: 6th Jul 2023

ISIT 312: Big Data Management Assignment, SIM, Singapore Conceptual modeling of a data warehouse An objective of this task is to create a conceptual schema of a sample data warehouse domain described

Task 

Conceptual modeling of a data warehouse An objective of this task is to create a conceptual schema of a sample data warehouse domain described below. Read and analyze the following specification 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 (not obligatory) 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. A patient is eligible for his or her company health care benefits. Patient data includes name, id number (social security number), address (street, city, state, zip), and phone. A medical worker must hold one or more credentials that are granted to work in a particular medical facility. Doctors are allowed to deliver diagnoses and give treatment based on their specialization Paramedics are allowed to deliver only emergency diagnoses and treatment for any type of life-threatening problem. Nurses do not deliver a diagnosis, but they do participate in treatment, particularly if the patient must be prepared for surgery or remain at the facility overnight. The administration workers are concerned with personnel needs and assignments.

Each medical worker must have at most one assignment at a facility. Several administration workers can be assigned to one assignment. Medical facilities are located in different suburbs of different cities. A medical facility is uniquely identified by an address. A data warehouse must be designed such it should be possible to easily implement the following classes of applications. Management of the medical facilities would like to get from a data warehouse information about – the total number of medical services performed per medical facility, per year, per month per day, per city, and per medical worker, – the total length of medical services per medical facility, per year, per month per day, per city and per medical worker, – the average length of medical services per medical facility, per year, per month per day, per city and per medical worker, – total number of doctors/ paramedics/nurses involved in medical services, per year, per month per day, per medical facility, per city, – average time spend on medical services per year, month, day, – total costs of medical services per year, month, day, per medical facility, per city.

To draw a conceptual schema, use a graphical notation explained to you in a presentation 11 Conceptual Data Warehouse Design. To create a conceptual schema of a sample data warehouse domain, follow the steps listed below. Step 1 Find a fact entity, find the measures describing a fact entity. Step 2 Find the dimensions. Step 3 Find the hierarchies over the dimensions. Step 4 Find the descriptions (attributes) of all entity types. Step 5 Draw a conceptual schema. To draw a conceptual schema, you must use a graphical notation explained to you in a presentation 11 Conceptual Data Warehouse Design. To draw your diagram, you can use the UMLet diagram drawing tool and apply a “Conceptual modeling” notation, Selection of a drawing notation is available in the right upper corner of the main menu of the UMLet diagram drawing tool. UMLet 14.3 software is can be downloaded from the subject’s Moodle Web site in a section WEB LINKS. A neat hand drawing is still all right. Deliverables A file solution2.pdf with a drawing of a conceptual schema of a sample data warehouse domain.

Hire a Professional Essay & Assignment Writer for completing your Academic Assessments

Get Help By Expert

Are you a Singaporean student at Singapore Institute of Management (SIM) seeking professional assistance with your FYP (Final Year Project) or group-based assignments? Do you need reliable assignment help in Singapore or expert guidance for Report Writing? Look no further! Our expert team is here to provide comprehensive support tailored to your needs.

Categories:-
Tags:- ISIT 312: SIM MANAGEMENT ASSIGNMENT
Answer
Recent Solved Questions
No Need To Pay Extra
  • Turnitin Report

    $10.00
  • Proofreading and Editing

    $9.00
    Per Page
  • Consultation with Expert

    $35.00
    Per Hour
  • Live Session 1-on-1

    $40.00
    Per 30 min.
  • Quality Check

    $25.00
  • Total
    Free

New Special Offer

Get 30% Off

UP TO 15 % DISCOUNT

Get Your Assignment Completed At Lower Prices

Plagiarism Free Solutions
100% Original Work
24*7 Online Assistance
Native PhD Experts
Hire a Writer Now
My Assignment Help SG Services
My Assignment Help SG

Rated 4.9/5 Based on 22945 Singaporean Students