Went to search for my cabinet again with my dad.

My wardrobe takes up space so my cabinet length is quite a trouble for me to get.

My dad say maybe find people help me design the length, height, width, the color and storage size for me.

------------------------------------------------------------------

The whole day browsing at my wardrobe; I found that I very long never buy new clothes. 

Tmr, I going St James with Daphne and Selena.

Got to get myself a dress ~

Dear allow me to go club cuz he trust me ♥♥♥
So am I ~ J

I got to check mails, search for clubbing dress and help dear to check his poly stuff.

Take care, peers ~

Ciao J

Day 1 – AMK MRT

The uniform

We distribute the freebies in 45mins

Pink headband, Pink uniform, white skirt and covered shoe.

My sis says I look like going for golf J

 Day 2 – TAMPINES MRT

I was instructed to give age above 16 to 40s but a lot uncles and especially aunties take from me.

Than I told them is more suitable for their daughters to try.

 A lot thing happen like people keep taking freebies again and again, some wander around you want you to give them, it’s very obvious, some don’t take until I say it’s FREE. Ha-ha J Ended in 30mins.

Day 3 – BOON LAY MRT

Red, Orange, Yellow, Green, Blue, Violet, Purple = Rainbow!!

I saw 2 rainbows but another color much lighter so I did not take the photo.

Cute Fionn, Sweet Priscilla, Pretty Pamela, Princess Dawn J

They are sweet and nice. It’s great to know and work with them J

 We ended in 30mins.

Last day – TOA PAYOH MRT

I meet Daphne to Job Fair before work. A lot job but nothing I like.

We than had our nasi lemak at chong pang than head to my house.

Daphne accompany me to work J so sweet of her.

Today not much people want to take freebies. Why?? Or they thought is flyers? 

Well, I was allocated at differ exits and finally freebies given away.  Also end quite early.

We stroll along the street and saw baby’s clothing and we bought 2 for baby dawn J

I have never ever been to this lesson and yet I can type all these out.

Yap, teacher gave us 1 example and 3 questions out of 4. He told me that I have alr pass 90% of it.

I score the highest mark I think J

I indeed very happy cuz I pass the subject that I never attend before.

Hahahahahahaha ~

Actually is quite easy cuz is an open book test and you observe is like just copy everything.

You can just ignore what is below; I’m just contented with my test J

1a.create Table staff

           (emp_id VarChar2 (4)

                   Constraint emp_id_pk PRIMARY KEY,

           Surname VarChar2 (40),

           Name    VarChar2 (40),

           Address VarChar2 (50),

           PCode   Number (4),

           BirthDate       Date,

           Hired   Date,

           Salary Number (8, 2));

 

INSERT INTO staff

(EMP_ID, Surname, Name, Address, Pcode, BirthDate, Hired, Salary)

VALUES

('TE01','Tan','James','Bedok', 1111, TO_DATE (‘MAY 8, 1965', 'MON, DD, YYYY’), TO_DATE (‘1/5/1991', 'dd/mm/yyyy'), 2000);

INSERT INTO staff

(EMP_ID, Surname, Name, Address, Pcode, BirthDate, Hired, Salary)

VALUES

('TE03','CHEW','SHARON','Tampines', 2222, TO_DATE (‘AUG 26, 1964', 'MON, DD, YYYY’), TO_DATE (‘1/7/1991', 'dd/mm/yyyy'), 1800);

INSERT INTO staff

(EMP_ID, Surname, Name, Address, Pcode, BirthDate, Hired, Salary)

VALUES

('AD03','CHONG','MABEL','SIMEI', 3333, TO_DATE (‘JUL 11, 1968', 'MON, DD, YYYY’), TO_DATE (‘1/7/1991', 'dd/mm/yyyy'), 1600);

INSERT INTO staff

(EMP_ID, Surname, Name, Address, Pcode, BirthDate, Hired, Salary)

VALUES

('MK03','SIM','THERESA','HOUGANG', 6666, TO_DATE (‘NOV 23, 1970', 'MON, DD, YYYY’), TO_DATE (‘1/8/1991', 'dd/mm/yyyy'), 1600);

INSERT INTO staff

(EMP_ID, Surname, Name, Address, Pcode, BirthDate, Hired, Salary)

VALUES

('AD03','HO','LINDA','THOMSON', 4444, TO_DATE (‘APR 6, 1968', 'MON, DD, YYYY’), TO_DATE (‘1/9/1991', 'dd/mm/yyyy'), 1500);

INSERT INTO staff

(EMP_ID, Surname, Name, Address, Pcode, BirthDate, Hired, Salary)

VALUES

('TE03','CHUA','ESTHER','YISHUN', 5555, TO_DATE (‘FEB 12, 1965', 'MON, DD, YYYY’), TO_DATE (‘1/10/1991', 'dd/mm/yyyy'), 2000);

INSERT INTO staff

(EMP_ID, Surname, Name, Address, Pcode, BirthDate, Hired, Salary)

VALUES

('AD03','NG','ESTHER',', ' TO_DATE (‘MAR 21, 1970', 'MON, DD, YYYY’), TO_DATE (‘1/3/1991', 'dd/mm/yyyy'), 1300);

INSERT INTO staff

(EMP_ID, Surname, Name, Address, Pcode, BirthDate, Hired, Salary)

VALUES

('MK03','LIM','SERENE','HOUGANG', 6666, TO_DATE (‘SEP 26, 1966', 'MON, DD, YYYY’), TO_DATE (‘1/5/1992', 'dd/mm/yyyy'), 1800);

 

2a.SELECT name, birthdate, hired

   FROM staff

   ORDER BY name;

 

2b.SELECT emp_id, surname, name

   FROM staff

   WHERE surname='Tan';

 

2c.SELECT emp_id, surname, name

   FROM staff

   WHERE emp_id='TE';

 

2d.SELECT name, address pcode, birthdate

   FROM staff

   WHERE name='Esther'or address='Simei';

 

2e.SELECT name, salary

   FROM staff

   WHERE salary >1800 and not=1600

   ORDER BY surname;

 

2f.SELECT name, project, coursename, semester_2008

   FROM course

   WHERE project=compulsory;

 

2g.SELECT emp_id, name, surname as 'employee'

   FROM staff;

 

 

3. UPDATE staff set salary=3000

  WHERE emp_id='TE04';

 

 

I found this bear so cute at dear’s room

 

And he was force by me to take a picture with this bear J

We are allocated at these dates and venues.

Mon 23^rd AMK MRT

Tue 24^th TAMPINES MRT

Wed 25^th BOON LAY MRT

Thur 26^th TOA PAYOH MRT

Its 2 hour a day giving out free 1000ps BIORE mild cleanser.

Attire: White bottoms OR White skirt preferred with covered shoe

Dear and me, I love him so much ~

If you are together with a right person, everyday is Valentine’s Day ♥

Present from dear
 

Thanks dear J
One, two, three ♥


 

I used 1 week to bake cookies for my dear.

He told me the cookies was delicious and nice J

 

We went to Chinatown for his hometown steamboat

I just feel so happy whenever I am with my dear. He makes me smile J

I and dear went to have our hair cut before valentine day :)

We had Japanese food for our dinner.