Category Archives: IT assignment examples

MS SQL TASK:

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

Apples provided by Sunshine Ltd: 3.08 (expiration date 2016.07.20)
Apples provided by NewFood: 3.88 (expiration date 2016.07.30)
Apples provided by FreshGoods: 2.53 (expiration date 2016.06.25)
Potatoes provided by Sunshine Ltd: 1.61 (expiration date 2016.10.01)
Potatoes provided by NewFood: 2.01 (expiration date 2016.12.11)
Tomatoes provided by Sunshine Ltd: 3.65 (expiration date 2016.05.20)
Tomatoes provided by NewFood: 5.30 (expiration date 2016.05.25)
Eggs (pack of 12) provided by Sunshine Ltd: 4.59 (expiration date 2016.06.13)
Eggs (pack of 12) provided by FreshGoods: 3.13 (expiration date 2016.06.01)
Carrots provided by Sunshine Ltd: 2.50 (expiration date 2016.08.22)
Carrots provided by FreshGoods: 3.30 (expiration date 2016.07.30)
Carrots provided by NewFood: 2.80 (expiration date 2016.08.10)
Onions provided by NewFood: 1.95 (expiration date 2016.05.20)
Onions provided by FreshGoods: 1.35 (expiration date 2016.05.10)
Onions provided by FreshFoods: 5.25 (expiration date 2016.05.25)
Plastic bags provided by Sunshine Ltd: 0.10 (no expiration date)
Paper bags provided by PaperFactory Ltd: 0.15 (no expiration date)
Paper bags provided by FreshMoods: 0.20 (no expiration date)
Handkerchiefs provided by FreshMoods: 0.30 (no expiration date)

Continue reading →

ANDROID TASK:

Create new Android application which shows a Happy New Year congratulation message and appropriate background picture. When the text corresponding to a family member getting congratulated is being clicked on by the user, it should respond with switching to a different family member (i.e. father, mother, brother, grandfather). Continue reading →

Hello! Today I want to teach you how to always win in tic tac toe game and show you the implementation of the C++ code!

You should start from the corner:

The essence of this strategy is that “X” performs the first move not to the central cell, but into the corner. In this case, the toe has several options. Continue reading →

First you should download freeglut and glew archive and unzip it:
Continue reading →

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 →

Introduction: The aim of this project is to create a four function calculator using JavaScript programming language. The calculator designed performs addition, subtraction, multiplication and division of tow given numbers.

Code Implementation:

After the basic HTML declarations, we define the type attribute which specifies the type of document for the Internet media. In this project we define <style type="text/css"> which means that the content is CSS. Continue reading →