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