All posts by Editor

MS SQL TASK:

Create new MS SQL database. In this database, create a table called “library” with the following information:

Andrew Jacobson (2003 April 27) “Blue Gift”. Publisher: CRC Press
Bill Kauffmann (2005 March 6) “Willow in the Mist”. Publisher: Delirium Books
Bill Kern (2005 March 1) “Time of Silence”. Publisher: Del Sol Press
Catherine Wilde (2008 June 30) “Black Tears”. Publisher: CRC Press
John Becker (2008 May 2) “Splintered History”. Publisher: ABC Publishing
John Becker (2006 July 17) “Lost Ashes”. Publisher: Delirium Books
John Becker (2010 January 15) “Forgotten Girl”. Publisher: ABC Publishing
Michael Ernst (1954 December 4) “Tower in the Flame”. Publisher: Beyer Books
Natalie Haast (1988 February 25) “Frozen Legacy”. Publisher: Beyer Books
Samantha Steele (1999 October 8) “Doors of Danger”. Publisher: ABC Publishing
Samantha Steele (1993 February 11) “Diamond Petals”. Publisher: Beyer Books

Execute the following SQL queries and provide the results of their execution in form of screenshots: Continue reading →

DESIGN PATTERNS TASK:

Describe the following software design pattern: Abstract Factory

SOLUTION:

In this sample we will provide a description of Abstract Factory software design pattern. First of all, it deals with objects know as “factories”, which is (in terms of object-oriented programming) an object used for creating other objects. Continue reading →

JAVA TASK:

Create Java application capable of solving a 3×3 square filled with digits in order to determine if it is a magic square. User should be able to access such functionality as: filling the square with numeric values, checking the values in the current square, and checking the current square for being a magic square. Continue reading →

C# TASK:

Create a console window C# application that shows the following each time the Enter key is pressed:

1. 1. 1. NUM LOCK key state (using green text on a blue background);
      2. CAPS LOCK key state (using red text on a yellow background);
      3. a request for a user to input a message (using default text and background colors) which is then set as the new titlebar text for the application.

Continue reading →

C# TASK:

Create an application that allows the user to input money value for bank deposit, and deposit rate (in percents). Once the user provides this data, he should be able to derive the state of deposit based on amount of months he inputs. And vice versa, he should be able to derive amount of months required for the deposit to reach the amount of money he inputs. Use switch-case construct for handling the different choices of the user. Continue reading →