Help your JUNIOR!!!!!

HI SA28,

Help your junior, (SA-29, SA-30, .....) by posting your exam questions that you remember. If they only find out our SA27 old questions, it is not enough for them.
Please keep in touch with this blog by posting your articles, exam questions.

To SA29

Hello SA29,

How's everything in 1st Semester? Due to the mass requests in Cbox, I make the link for the question types for our SA27 batch. You can see the one in the Labels box. But we don't have SA28 questions. Pls ask them to upload. May be they don't have access to this blog or other reasons. SA27 and SA28 questions types are not similar. Anyway, u can at least know how ISS questions look like. Good luck.

We are more than happy to give u access to this blog. So, u all can also participate and upload ur questions also. Pls send issfriends@googlegroups.com this email address for blog author request. Pls include ur name, batch and blog userID there to check whether u r ISS students or not. We don't give the access right to Non-ISS students.

If possible, we also want to handover batch by batch and keep running this blog. We hoped SA28 to participate in this blog, but they were hardworking students and very busy with their study. We hope SA29 to spend some of your precious time in this blog.

The below are the links of ISS Groups from community site.
Friendster
Google Groups
Facebook
Ning

That's all. Good luck all our brothers and sisters from SA29.
SA27

Medical aid for people suffered from Cyclone Nargis

Dear All,

If any of you want to donate any kind of Medicine or Medical Equipments or Volunteer in Medical Service for victims in Ayeyarwaddy, please contact Dr. Kyaw Nandar (ph: 095099955).
**Tens of thousands of people are waiting for your help.

Thank you very much.

Cyclone heavily damaged commercial capital Yangon

A Myanmar official says a tropical cyclone packing winds of 190 kilometers per hour, or 120 miles, caused heavy damage in Yangon, tearing off roofs and knocking out electricity in much of the country's commercial capital.

The official from the country's Meteorology Department says he expects deaths and injuries from Saturday's storm. But he could not provide any figures. Herefused to be named because he is not authorized to speak to the press.

The meteorological bureau said in a special announcement broadcast several times Friday afternoon that tropical cyclone Nargis could hit the coast near Yangon, the country's biggest city. Nargis originated in the Bay of Bengal.

Nargis Activated!!!!!!!!!!!

This morning I got news from Yangon. Government announce weather alert at Yangon.
There will be Cyclone this evening (2 May 6 P.M local time).




Affected Cities

1.BoGaLay
2.Phyapon
3.LaPutta
4.Coco Island

5.Yangon
6.Kangyidaung
7.Bassein

8.Nattalin
9.Kyangin
10.Zigon
11.Gyobingauk
12.Pyuntaza

Read More Detail Here

Requirement Workflow Use Case Writing Process

I got this process from teaching PPT, I will support the link below.

1.Name the system scope and boundaries.
2.List the actors (Brainstorm)
3.List user goals for the system (becoming use case)
4.Capture the outmost summary use case to see "Who really cares" - seeking primary actors
5.Reconsider and revise summary use cases.Add, subtract or merge goals (Refining)
6.Select one use case to expand
7.Capture stakeholder interests and preconditions and guarantees (their requirements - there may be additional requirements)
8.Write the main succes scenario
9.List the extension conditions (Brainstorm)
10.Write the extension-handling steps
11.Extract complex flows to sub use case; merge trival sub use cases (Refining again)
12.Iterate and adjust

I think list number 1 to 6 will be helpful for SA28 who are now facing their exam on coming Monday.....

GOOD LUCK JUNIORS!!!!

Static Modelling & Dynamic Modelling in OOAD

Static Modelling : It is used to specify structure of the objects that exist in the problem domain (we will discuss this in next post). These are expressed using classes,objects and use case diagrams.It is Time Independent View.

Dynamic Modelling: It is Time Dependent View.It representing the object interactions during runtime , mostly represent by sequence, activity,collaboration and statechart diagrams.

Still confusing on System Actors and Internal Workers ?

Most of my juniors ask me about System Actor and Internal Worker –
a. Are they same?
b. What are Internal Worker and External Worker?
Usually those questions come up because of not getting the concept on Business workflow and Requirement workflow –

My classification is very simple (for dummies – like me). It is based on what we are focusing on .Let me explain with picture, cause single picture worth thousand of words.

First I pick Actors from case study. At this moment, I don’t care whether it is system or business actor. To pick Actors, there is definition – say – a person who is interacting with something. Something can be either business or system. For example, if we are discussing on Business workflow and there are a lot of people interact with the business. Those people may be (not are) Business Actors. If we are talking our requirements of business and to implement some system, people (not only human) who can interact (use) with our future system will become System Actors.

For instance, in manufacturing business, there are a lot of employees working in industry.
QCs, Engineers, Technicians, HRs, Managers, Accountants, Office Staffs, etc. Those people are working for this business – we call them Internal Workers of this business. So, in contrast, we can have External Workers . These External Workers may be Business Actors but not all External Workers are Business Actors. Same idea work for Internal Workers, not all Internal Workers are System Actors. It depends on who will use the system .

ANNOUNCEMENT FROM IVLE!!!!!!!!!!!!!!!!

Dear SA students,

Today I was shocked to find out that some of you have requested the internship company to increase your allowance. Please note that for such unprofessional behavior, ISS will take disciplinary action against you.

Regards,

Megan

Reference: ISS_104 Announcement

Binding ArrayList with DataGrid

I will discuss how to create an ArrayList of objects and bind it to a DataGrid control using DataSource property.

Step 1. Creating a Class

First step is to create a class. I call my class Developer, which is listed in Listing 1. It's properties are FirstName, LastName, Age, Skills, and Experience.

public class Developer

{
private string firstName;
private string lastName;
private int age;
private string skills;
private int experience;
public Developer(string firstName, string lastName, int age, string skills, int experience )
{
this.firstName = firstName;
this.lastName = lastName;
this.age = age;
this.skills = skills;
this.experience = experience;
}

/// First Name
public string FirstName
{
get { return this.firstName ; }
}

/// Last Name
public string LastName
{
get { return this.lastName ; }
}

/// Age
public int Age
{
get { return this.age ; }
}

/// Skill set
public string Skills
{
get { return this.skills ; }
}

/// Number of year experience

public int Experience
{
get { return this.experience ; }
}
}

Listing 1. Developer class

Step 2. Creating an ArrayList of Objects

Now next step is to create an ArrayList object of Developer class. Listing 2 adds 6 items to the ArrayList.

private ArrayList GetList()

{
ArrayList list = new ArrayList();
list.Add(new Developer("Mahesh", "Chand", 30, "C#,ASP.NET,Windows Forms", 10)) ;
list.Add(new Developer("Michael", "Gold", 35, "GDI+, ASP.NET", 15)) ;
list.Add(new Developer("Bhasker", "Das", 26, "VB.NET, Web Applications", 4)) ;
list.Add(new Developer("Ashish", "Singhal", 24, "ADO.NET, GDI+", 4)) ;
list.Add(new Developer("Neel", "Beniwal", 3, "C#,ASP.NET,Windows Forms", 0)) ;
list.Add(new Developer("Melanie", "Talmadge", 25, "Java", 2)) ;
return list;
}

Listing 2. ArrayList of Developer

Step 3. Binding with DataGrid

Now we can bind our ArrayList using DataGrid.DataSource property and DataGrid would understand what to display in its columns. The following code binds the ArrayList to DataGrid.

ArrayList list = GetList();

dataGrid1.DataSource = list;

Step 4. The Result

Now if I run my application, the output in DataGrid looks like Figure 1.

**************Exam Question ***************

"Good luck SA28, we know all of you are only interesting exam questions . No one from SA28 celebrate this blog. We are so sad :( Please post comments and post Articles to this blog."

Paper 1: OOAD Exam

Paper 1, section A (Esther's)

1. Given a case make a system use case, elaborate your scope, give explanation why you do it that way, any other notes if you want to, and explain each process,

2. Give a domain model based on your use case and explain each bussiness entity,

3. From your use case make an activity diagram with swim lanes. Point out internal worker if any,

4. Revamped your use case with extend, include, and generalization. Explain why you do it that way.

Paper 1, section B(Yuen Kwan's)

1. Given an explanation of the process of an activity. Do an analysis modeling(?) and draw a colaboration diagram,

2. From the same explanation, draw a sequence diagram that clearly depict the use of three tier system and ado.net,

3. Draw a class diagram, still from the same text.

4. Descript how you can improve your system with include, extend, and inheritance.

Paper 2: C# Exam

Paper 2, Section A(Programming/Venkat)

1. Given a case, write a program using basic programming technique and modular programming,

2.a From the same case, draw an appropriate user interface explaining the controls used,
2.b Still from the same case, find 3 validation that might be needed and write the validation,

3. Write an event handler to insert a new record to the database. Your event handler must include the connection to database, the sql command, actually doing the sql command, and showing a success message

4.a Write a Point class, attribute X, Y; method Move(i, j); method bool IsSame(Object o) to compare if two point is the same.
4.b Write a Line class, a line is made of two Point; method bool IsParalel(Line l) to tell if two line is paralel; make a validation, if two point is the same then don't make the line
4.c Write a driver program to test the Line class.

Paper 2, Section B(SQL/Yuen Kwan)

1.a Point out the primary and foreign key in a given table,
1.b From the given two table (employee and course) write a Select command to select table
1.c another Select command to display table employee and total sum of course fee
1.d one more Select command to select employee with course more than average course taken by employee
1.e Create view of employee with course fee lower then 2000

Paper 3, ASP.NET Exam

Part 1 : Eshta

1. Differences and Describe usage according to the given case study for the following :

i. Client Script and Server Script
ii. Application and State Management
iii. HTML Control and HTML Standard Control in .Net
iv. Grid View and User
v. Users and Roles in ASP.Net Security

2.
a) 5 Controls which support user navigations in the given case study
b) How to change the home page in a way that the admin does not have to update weekly
c) How to configure and set the settings for Shopping Cart Table in the given case study
d) Write Code for UpdateCart Button Event.
e) Security Implementation for given directory and file structures
(some people said that it's sitemap.xml, but some said web.config. It can be achieved in both ways. I don't know the right answer)

4 Screenshots of web sites is given in the exam and all question must apply that scenario.

Part 2 : Megan

1. One Good Thing and Bad Thing of the given case study web site
2. 2 personas and 2 scenario
3. 3 WireFrames (Home, 2nd Level Page, 3rd Level Page)
4. Navigation Question (I don't know what it is...)

For Megan's Part, The NUS Library Case Study is given 2 weeks before the exam.

Paper 4: Software Engineering Exam

Section A :

1. Presentation 22 Marks
2. 6 Interview for each Person (3 People) 18 Marks

Section B :

1. Precedence Diagram + Gannt Chart + Assumption 25 Marks
2. Errorneous Test Scenario 5 Marks
3. Straight Forward Test Scenario 10 Marks

*For Gannt Chart, they give the ready made time line to draw. So, don't worry about the layout of Gannt Chart.

Paper 5 : Java Programming Exam

Java 1 :
10 Marks - looping the array, calculate the time difference and show the total
15 Marks - some theories and practical related 4 short questions

Java 2 :
10 Marks - Connecting the DB Server using JDBC or Hybernate and write the code for Insert Record

Java 3 :
10 Marks - Get the array objects from Session and show in the browser using JSTL
15 Marks - some theories and practical related 5 short questions

Java 4 :
5 Marks - CommandAction Code for List Control
8 Marks - CommandAction Code for Inserting record into the data store
7 Marks - Getting Records from the data store and shown back to the screen

Quote of the Day

"A guy know's he's in love when he loses interest in his car for a couple of days."

-Tim Allen

"A man in love is incomplete until he has married. Then he's finished."

-Zsa Zsa Gabor

"I told my doctor I broke my leg in two places. He told me to quit going to those places."

-Henny Youngman

"You know why fish are so thin? They eat fish."

-Jerry Seinfeld

"A bank is a place that will lend you money, if you can prove that you don't need it."

-Bob Hope

"I don't consider myself bald. I'm simply taller than my hair."

-Thom Sharp

"This is a strange country we live in. When it comes to electing a president, we get two choices. But when we have to select a Miss America, we get 50."

-Jay Leno

"I figure you have the same chance of winning lottery whether you play or not."

-Fran Lebowitz

"Give a man a fish and he has food for a day; teach him how to fish and you can get rid of him for the entire weekend."

-Zenna Schaffer

"It's not that I'm afraid to die; I just don't want to be there when it happens."

-Woddy Allen

"I have my standards. They may be low, but I have them."

-Bette Midler

"I've been on a calendar, but I've never been on time."

-Marilyn Monroe

"If God meant us to be naked, he would have made our skin fit better."

-Maureen Murphy

"It's so simple to be wise. Just think of something stupid to say and then don't say it."

-Sam Levenson

"If winning isn't everything why do they keep score?"

-Vince Lombardi

Who is The most hated man in ISS?

Creating your Own e-commerce Website

Your website will always be a work in progress. In other words it will never be finished. You will constantly be adding new products and features and will have to make periodic changes and updates. So it doesn't have to be perfect when you first launch it.

You only need the following things to start with:

- A homepage to showcase what your site is all about.

- A contact/about us page so people will be able to contact you and so they can learn a little bit about who you are

- Several product pages that will explain what you're selling and give the visitor an opportunity to make a purchase.

Creating your website

Creating a website is not a hard as you might think. There are several different website authoring tools and each has it's own learning curve.FrontPage is very easy to use .Another good thing about FrontPage is that it's a Microsoft product so your site will work perfectly on the Internet Explorer browser.


Most websites are a continuous work in progress. So just surf the web and find a couple of sites that are offering something similar to your product or service. You can get a lot of great ideas from what others are already doing.

Your website does not have to begin as a supersonic aircraft. Yu can start off like the Wright Brothers' plane and continue to add and modify it until you have a supersonic website.

ref: http://www.inetwebbiz.com/Creating-Your-Website.htm

C# Vs Java

C# is not a competitor to Java. Well, this is what Microsoft claims it to be. Every time someone writes or compares Java to C#, Microsoft always cries out foul. It is unfair to compare the two languages. As more developers start to play around with C#, many are starting to see strong similarities between the two languages.

Productivity is the key for development team

You can develop applications for the Microsoft platform using Java. But it's more sensible to use a .NET language instead for one simple reason: productivity. Microsoft makes it easier to take advantage of the Windows platform than Java does. Creating Windows services, writing to event logs, debugging SQL Server stored procedures, accessing the registry, working with COM—all of these are simpler in terms of time to market in .NET than they are in Java. It's not that C# is better than Java. But Microsoft has created all the classes to handle Windows-based tasks and made them available through wizards, drag and drop, and point and click.

Java is designed to be platform independent, so naturally it doesn't ship with as many Windows-rich features. Java developers who sit through the .NET classes often let out audible gasps, followed by jokes about how Microsoft is putting developers out of jobs because of the ease by which much .NET development is done.

The .NET decision

A debate on the technical merits of one language vs. the other is for the most part a moot discussion; you can pretty much do the same things in both languages, with minor exceptions. So at this point, your decision should be based on the answer to this question: “Does the application need to run only on the Microsoft platform?” If the answer is yes, go with a .NET language—primarily C#.

Bear in mind that we will, no doubt, eventually see .NET-written applications run on Linux and other platforms, but that day is still some time away. For now, pick your platform first and your language second.

Post back in ASP .NET

In old ASP, classic ASP, using post method in form is to post the values of a Form to another page. The another asp page will receive the data and processing it on the server side.

With ASP .NET, it is already changed. They are separated a entity with ability to process its own posted data. So the values of the Form are posted to the same page and the same page can process the data. It is called post back.

This post back is a read only property with each ASP .NET Page (System.Web.UI.Page) class. This is false when the first time the page is loaded and is true when the page is submitted and processed. This enables users to write the code depending on if the post back is true or false (with the use of the function Page.IsPostBack()).

Control it with AJAX. Then you can get the nice performance.

Web Design Challenge

Hi SA 28,

Not so far to face with Internet Project after the exam.
Challenge upon your design for Web Project. With CSS or something else?

Cascading Style sheets(CSS) are a very powerful tool for the Web site developer. They give you the chance to be completely consistent with the look and feel of your pages, while giving you much more control over the layout and design than straight HTML ever did.

So just try with your own CSS or copy n paste CSS from somewhere, in your Internet Project. Then you can get experience in web designing and can apply in your internship period.

Cheers.

Just Luck of SA 28

Hi everybody,
SA 28 are so lucky that they can learn Ajax also in their course. So i share some information from internet about Ajax.

How Is Ajax Different?

For those who don't know, Ajax is a method of employing JavaScript, DHTML, and the XMLHttp behavior in the browser to provide truly dynamic content on a Web page without a page refresh.

Popular examples of this technology include Google's Suggest, Amazon's Diamond Search tool, and many of Flickr.com's interactive features.

Ajax effectively does away with the traditional "Click-and-Wait" Web-application architecture of yesterday, making it possible to provide the responsiveness and interactivity users expect from desktop applications.

Ajax's ability to pull data from the server after the page has loaded contrasts with what we now refer to as the "traditional architecture." In a traditional architecture, the user must wait for the entire Web page to reload to see new results from the server.

In an application that requires a lot of interactivity with the business layer sitting on the server, the user must reload the entire page many times. This has implications for the efficiency of workflow, the load placed on the server hosting the application, and the productivity of users.

Somebody share about AJAX that what you know to other...ok?

Please Vote the King and Queen for SA 28

Ohmar Kyaw: 5 votes, Ye Lin Htike :3 votes

May i have your attention please.
Only the students from SA28 are eligible to vote for queen an king.
For SA 27 students-Sorry :(.They are not permitted.
Thank You!

hey all !!

hello folks !

happy to leave a mesage after a long time .... how r u all ??? wats going on in ur companies ?

Difference between Composition and Aggregation!!!

Composition:

As we know, inheritance gives us an 'is-a' relationship. To make the understanding of composition easier, we can say that composition gives us a 'part-of' relationship. Composition is shown on a UML diagram as a filled diamond (see Figure 1).

If we were going to model a car, it would make sense to say that an engine is part-of a car. Within composition, the lifetime of the part (Engine) is managed by the whole (Car), in other words, when Car is destroyed, Engine is destroyed along with it. So how do we express this in C#?

public class Engine
{
. . .
}

public class Car

{

Engine e = new Engine();

.......

}

As you can see in the example code above, Car manages the lifetime of Engine.

Aggregation:

If inheritance gives us 'is-a' and composition gives us 'part-of', we could argue that aggregation gives us a 'has-a' relationship. Within aggregation, the lifetime of the part is not managed by the whole. To make this clearer, we need an example. For the past 12+ months I have been involved with the implementation of a CRM system, so I am going to use part of this as an example.

The CRM system has a database of customers and a separate database that holds all addresses within a geographic area. Aggregation would make sense in this situation, as a Customer 'has-a' Address. It wouldn't make sense to say that an Address is 'part-of' the Customer, because it isn't. Consider it this way, if the customer ceases to exist, does the address? I would argue that it does not cease to exist. Aggregation is shown on a UML diagram as an unfilled diamond (see Figure 2).

So how do we express the concept of aggregation in C#? Well, it's a little different to composition. Consider the following code:

public class Address
{
. . .
}

public class Person

{

private Address address;

public Person(Address address)

{

this.address = address;

}

. . .

}

Person would then be used as follows:

Address address = new Address();
Person person = new Person(address);

or

Person person = new Person( new Address() );

As you can see, Person does not manage the lifetime of Address. If Person is destroyed, the Address still exists. This scenario does map quite nicely to the real world.

Difference between abstract class and interface

There is no difference in the functionality of these two.The only difference is that a class cannot extend an abstract class if it already is extending some other class.An interface on the other hand can be implemented in any situation which makes them very powerful.Also user defined exceptions can be defined within an interface itself, which is not the case with an abstract class.
Moreover..
1. Abstract classes can have concrete method while interfaces have no methods implemented.
2. Interface do not come in inheriting chain, while abstract class come in inheritance.
3. Abstract classes are faster than interfaces.
4. By default, all members in Interface is Public whereas members in Abstract class may have different.

Blog Activity is Low

ISS blogs activity is very low compare to October 2007, since this blog was launched.
The number of posts in october was 37 posts, and in December 2007 only 1 post.
This month is 5 posts .

This Week Event!

Hi Buddies!
This week we will go to West Cost Park , Again :D

Stress Talk !!!!

Hey , buddies.....

Seems all are ok in Internship!! .. No stress .. Hopefully... :)
If you have stress or anything you want to say in order to relieve from those sufferings .... just tell here , give some comments ( including gossip on your supervisor in company )...

Let's share our experience on this internship...ok ?
for us, guys from Chartered, everything seems fine for this moment ...but there are some unsatisfied situations in work .... E.g: Boring , tired,etc.... Ha Ha :)

Expecting at least someone, share with me of his/her experience....

C u around guys.... SA27

Tution fees will be increased at next intake

According to the reliable source from ISS, tution fees will be higher from 6000 S$ to
9000 S$. Bank loan will aslo be stopped.

When My supervisor is out of office

My supervisor take a leave for 5 days,so i m free and i get to work at
9 .30
i can go back home early.
How happy my life is

AD project results are announced

Today, AD project results are announced ,while students are strugling in their internship companies.
But ISS posted the result by mail and almost all of the students have not known the result yet.
Hopefully,we can see our result on comming Monday.
Only In- house internship student know the result.

Request for gathering has been rejected!!!!!!

It's too bad that they reject our plan :( .......
See what she reply to me ....so what do we do now...?
Friends, please think?

Dear Sai Lin Naung

This is to inform you that your request to hold a gathering in the MPH, has been rejected.

We appreciate if you can hold it outside ISS.

Thank you.

---

From: Sai Lin Naung
Sent: Monday, February 11, 2008 6:37 PM
To: Matilda Y Raj
Subject: Request for group gathering SA27

Dear Sir(s)/Madam(s) ,

We would like to request to hold gathering event for all Myanmar students attending in SA27 Batch on (17/2/2008) at MPH. We plan to have only one and half hour starting from 10 am. In that event, we would like to make welcome for SA28 Myanmar students ,and share our knowledge and experience to them. Moreover , there may be snack and softdrink provided to all students.

With all regards,

Sai Lin Naung

( On behalf of SA27 Myanmar students )

New Technology developed by some SA27 Students

Hello coming SA students,

For IT life, you must know the strategy thinking way. So play the strategy game a lot to develop your brain such as war craft, and counter strike...and so on.

But I recommend you that don't play at school. :P
Just practice your home and come to us to discuss about that. :P
OK???

Newest Couple from SA 27 !!!

Wonderful wonderful wonderful news . I found newest couple in SA 27...
You can think "iT" couple. I think they will be success in future IT field.
Please say "Congratulation" to them....

Celebrate The Day!!!!!!!!!!!!!!!!!!!!!!!!!!

Hi All for SA Diploma Students...,

We are back... First We have to Celebrate The Day... 

We did it well and made very well.... Proude yourself , proude your team members proude your class mate. 

To win again
To never stop finding
Moving as one
Is the word for home
Begin to place
Yourself in the big frame
When you dream
When you dream
Away...away

En avant pour la victoire
En avant pour la victoire
C'est le moment de l'espoir
C'est le moment de l'espoir
Let the sweet air

Fill our hearts
Walk on and celebrate the...
Day the day the day celebrate the day etc.
Grab your drums
Paint your soul
Feel the roar and celebrate the...
To win again
To never stop climbing
The rising road
Of ultimate faith
Unity
The world in a heartbeat
When you dream
When you dream
Away...away

Paper 4: Software Engineering Exam

Section A :

1. Presentation 22 Marks
2. 6 Interview for each Person (3 People) 18 Marks

Section B :

1. Precedence Diagram + Gannt Chart + Assumption 25 Marks
2. Errorneous Test Scenario 5 Marks
3. Straight Forward Test Scenario 10 Marks

*For Gannt Chart, they give the ready made time line to draw. So, don't worry about the layout of Gannt Chart.

Good Luck SA28

Paper 2: C# Exam

Paper 2, Section A(Programming/Venkat)

1. Given a case, write a program using basic programming technique and modular programming,

2.a From the same case, draw an appropriate user interface explaining the controls used,
2.b Still from the same case, find 3 validation that might be needed and write the validation,

3. Write an event handler to insert a new record to the database. Your event handler must include the connection to database, the sql command, actually doing the sql command, and showing a success message

4.a Write a Point class, attribute X, Y; method Move(i, j); method bool IsSame(Object o) to compare if two point is the same.
4.b Write a Line class, a line is made of two Point; method bool IsParalel(Line l) to tell if two line is paralel; make a validation, if two point is the same then don't make the line
4.c Write a driver program to test the Line class.

Paper 2, Section B(SQL/Yuen Kwan)

1.a Point out the primary and foreign key in a given table,
1.b From the given two table (employee and course) write a Select command to select table
1.c another Select command to display table employee and total sum of course fee
1.d one more Select command to select employee with course more than average course taken by employee
1.e Create view of employee with course fee lower then 2000

Paper 1: OOAD Exam

Paper 1, section A (Esther's)

1. Given a case make a system use case, elaborate your scope, give explanation why you do it that way, any other notes if you want to, and explain each process,

2. Give a domain model based on your use case and explain each bussiness entity,

3. From your use case make an activity diagram with swim lanes. Point out internal worker if any,

4. Revamped your use case with extend, include, and generalization. Explain why you do it that way.

Paper 1, section B(Yuen Kwan's)

1. Given an explanation of the process of an activity. Do an analysis modeling(?) and draw a colaboration diagram,

2. From the same explanation, draw a sequence diagram that clearly depict the use of three tier system and ado.net,

3. Draw a class diagram, still from the same text.

4. Descript how you can improve your system with include, extend, and inheritance.

Thanks to nekoReman in SA26 forum.

Paper 5 : Java Programming Exam

Java 1 :
10 Marks - looping the array, calculate the time difference and show the total
15 Marks - some theories and practical related 4 short questions

Java 2 :
10 Marks - Connecting the DB Server using JDBC or Hybernate and write the code for Insert Record

Java 3 :
10 Marks - Get the array objects from Session and show in the browser using JSTL
15 Marks - some theories and practical related 5 short questions

Java 4 :
5 Marks - CommandAction Code for List Control
8 Marks - CommandAction Code for Inserting record into the data store
7 Marks - Getting Records from the data store and shown back to the screen

Paper 3, ASP.NET Exam

Part 1 : Eshta

1. Differences and Describe usage according to the given case study for the following :

i. Client Script and Server Script
ii. Application and State Management
iii. HTML Control and HTML Standard Control in .Net
iv. Grid View and User
v. Users and Roles in ASP.Net Security

2.
a) 5 Controls which support user navigations in the given case study
b) How to change the home page in a way that the admin does not have to update weekly
c) How to configure and set the settings for Shopping Cart Table in the given case study
d) Write Code for UpdateCart Button Event.
e) Security Implementation for given directory and file structures
(some people said that it's sitemap.xml, but some said web.config. It can be achieved in both ways. I don't know the right answer)

4 Screenshots of web sites is given in the exam and all question must apply that scenario.

Part 2 : Megan

1. One Good Thing and Bad Thing of the given case study web site
2. 2 personas and 2 scenario
3. 3 WireFrames (Home, 2nd Level Page, 3rd Level Page)
4. Navigation Question (I don't know what it is...)

For Megan's Part, The NUS Library Case Study is given 2 weeks before the exam.