Fathia Mohamed
WGA060021
Tutorial 1

How is Smoothing by Bin Medians?

Dear all,

Can anyone shed some light on how Smoothing by Bin Medians is performed?

Thanks.

Regards.

Mid-Sem Examination

Fellow classmates,

This post is to notify you guys that though Dr. Teh might be late this Friday, the mid-semester exam for Data Warehousing and Data Mining class will be conducted as usual, i.e. 6pm. If he's late, please wait patiently as he has to rush back from his training in KL.

Thank you for your cooperation and good luck everyone.

Regards.

University Hospital Star Schema

Justifications for fields/attributes used:

Table: Doctor
Purpose:
1. To be able to identify which department a particular doctor is from and the
number of positions the doctor is currently holding so to be able to determine
the doctor’s productivity, performance or KPI.

2. To enable the tracking of the number of doctors in the hospital to ensure
there are sufficient numbers to serve each of the departments in the hospital.

Table: Patient
Purpose:
1. To be able to identify common reasons for patient’s admittance so that the
hospital can take the necessary precautions to be better prepared, such as adding
more hospital bed if patients’ usually are admitted for surgeries and require long
length of stay.

2. To be able to track and project estimateions based on the revenues/income generated from the patients' total bills.

Table: Time
Purpose:
1. To be able to analyze the peak time of patient admittance into the hospital based
on Hourly, Daily, Monthly and Yearly basis.

Table: Fact Table
Purpose:
1. To be able to see the analysis from all three of the other dimension tables, i.e.
Doctor, Patient and Time so that a suitable Charge rate could be determined that
will be fair to both doctors and patients. For example, doctors working on peak
hour may have to handle more patients and should be paid a higher rate.

2. To be able to conduct counts for all type of measures from each dimension table
so to be able to assist in determining the charges.

New Year Goal

Name: Yalda Azarbarzin

Matric No: WGA050052

Subject Code :WMGA6317

Lecturer : Dr. Teh Ying Wah

CAREER OBJECTIVE

• To gain more knowledge so that I can be more productive especially in the managment information system era.
• Ambitious to acquire further exposure and improvement in my communication skills and also in administration which is I may work to my highest potential.
• Find part time job to earn extra money to stay more than this semteser in malaysia.

Studies

1. To finish my thesis this semester
2. Keep up my CGPA high

TO ACHIEVE GOAL

1. work harder on my thesis
2. looking for a job on star newspaper
3. send my resume toIT companies

New Year Goal

Name: Rathija Subramaniam
Matric No: WGA050015
Subject Code :WMGA6317
Lecturer : Dr. Teh Ying Wah

MY 2007 REVOLUTION!

Field: Education..

1. Keep up my CGPA high.
2. To improve my performance in both subjects.
3. To set my target in completing project paper.
4. Learn more to acquire more useful knowledge.

Field: Career...

1. Target for high performance.
2. Be more friendly colleagues and helpful to my students.
3. Aim for higher increment and bonus.
4. To be more friendly and enjoy the working environment.
5. To improve my working capability.

Field: Social...
1. Learn to be more independent.
2. Learn to smile more.
3. To be more friendly with housemates and friends.

Field: Money...
1. Save more and spend little.
2. Purchase quality products not to go for low quality goods.
3. Invest money for future use.4. Only spend for necessary things.

Field: Family...
1. Pay more visits to parents and family members.
2. Show love to my parents.
3. Be grateful to them and appreciate their sacrifices.

Star Schema for University Hospital

Description of Data Dictionary

Dimensional Table -Doctor

1)Doct_Id - A Unique for the doctors identification

2)Doct_Name - information about doctors name

3)Doct_Age - details about doctors agei

4)Doct_Unit - records about which operation unit does the doctor assigned

Dimensional Table - Patient

1)Pat_Code - A unique identification code is assigned to patient

2)Pat_Name - Details about the patients name

3)Pat_Age - Records about the patients age

4)Pat_Add - Details about the patient house add or staying address

Dimensional Table - Time

1)Hour,Month and Year - Details about the attendance of patient

Fact Table - Sales

1)Pat_Code - Unique id of patient

2)Doct_id - Unique if of doctor

3)Time_id - Attendance of patient

New Year Plan for 2007

Name : MURNI NAURAH MAT NOH
Matric No : WGA040079
Tutorial 2 : New Year Plan for 2007


MY MISSION FOR 2007

· To succeed well in my personal live, career and studies. To become a better person.


GOALS

1) Career:

· To complete the HR New System Project Implementation within Project timeline
· To get higher evaluation from my boss during PMS time
· To improve my knowledge in Human Resource Operations

2) Study:

· To complete my master degree with good results
· To improve my pointer
· To spent more time to study and doing all my assignments
· To start my thesis next semester


ACTION TO ACHIEVE GOALS

· To manage my time wisely
· To work smart and efficiently
· Study harder

An Open Place To Speak Up

Dear Data Miners,

The blog should be fully utilized by us through posting of questions and doubts that we have since there's not much 'discussion' during lectures.

Anyone that has answers or can help clear those doubts and questions from others can also post their comments. So, let's help make this blog as informative as possible.

As the saying goes:
"NO MAN'/WOMAN' IS AN ISLAND"

Regards.