New image for my Android App “Action”
It is a business app for a world renowned accountancy firm! As the app depicts it has green values and will help save/make the firm money, increase client satisfaction, by means of reducing paper trails and...

New image for my Android App “Action”
It is a business app for a world renowned accountancy firm! As the app depicts it has green values and will help save/make the firm money, increase client satisfaction, by means of reducing paper trails and following work up much quicker. Work items are “actioned” much faster, even “on-the-go” in taxis/subways following meetings!

I will post up more information, code, screen shots very soon as I near completion!

Jurassic Systems

Welcome to Jurassic Park…………

Apple seeks a change for charging batteries......

'Tainted Love' Performed By Hard Drives Will Have You Geek Out

P r o g r a m m i n g I
- calculates the leap years from then
- then prompts the user if they would like to use it again
// One of the first programmes we done on the course utilising early skills

P r o g r a m m i n g   I

- calculates the leap years from then

- then prompts the user if they would like to use it again

// One of the first programmes we done on the course utilising early skills

Two Minute Computation

S o f t w a r e E n g i n e e r i n g
Assignment 1 - Replacement computer system for Queens University Belfast; Queens AWA system replacing QSIS- Preparation of Project Plan and Requirements Specification
UI mock-ups of Login Screen & Student Results...

S o f t w a r e   E n g i n e e r i n g  

Assignment 1 - Replacement computer system for Queens University Belfast; Queens AWA system replacing QSIS- Preparation of Project Plan and Requirements Specification

UI mock-ups of Login Screen & Student Results Page

CUMMINGS GLOBAL LTD
New company branding im currently working on - they are R&D Engineers who work in the Food Processing/Retail & Pharmaceutical Industries - Refrigeration Green Technology.

CUMMINGS GLOBAL LTD

New company branding im currently working on - they are R&D Engineers who work in the Food Processing/Retail & Pharmaceutical Industries - Refrigeration Green Technology.

D a t a b a s e s

- Queries

– display fixtures/result for specified date
select home_team.team_name, home_score, away_score, away_team.team_name from
 ((select game_number, team_name from plays where home_or_away = ‘H’) as home_team)
 join
 ((select game_number, team_name from plays where home_or_away = 'A’) as away_team) using (game_number)
 join game using (game_number)
where kick_off_time like ’%2013-12-07%’;
 


– get odds sheet for all matches
select concat(cast(home_team.first_term as char), ’-’, cast(home_team.second_term as char)) as 'Home Odds’,
 home_team.team_name as 'Home Team’,
 concat(cast(draw_odds.first_term as char), ’-’, cast(draw_odds.second_term as char)) as 'Draw Odds’,
 away_team.team_name as 'Away Team’,
 concat(cast(away_team.first_term as char), ’-’, cast(away_team.second_term as char)) as 'Away Odds’
from
 (select game_number, first_term, second_term, team_name
  from game
  join odds using (game_number)
  join plays using(game_number)
  where odds.result = plays.home_or_away
  and home_or_away = 'H’)
 as home_team,
 (select game_number, first_term, second_term, team_name
  from game
  join odds using (game_number)
  join plays using(game_number)
  where odds.result = plays.home_or_away
  and home_or_away = 'A’)
 as away_team,
 (select game_number, first_term, second_term
 from odds
 where result = ’D’) as draw_odds
where draw_odds.game_number = home_team.game_number
and draw_odds.game_number = away_team.game_number
and home_team.game_number = away_team.game_number
and home_team.team_name <> away_team.team_name;

D a t a b a s e s

- Database Creation

– DROP TABLES

DROP TABLE IF EXISTS plays;

DROP TABLE IF EXISTS team;

DROP TABLE IF EXISTS bets;

DROP TABLE IF EXISTS odds;

DROP TABLE IF EXISTS game;

DROP TABLE IF EXISTS staff;

DROP TABLE IF EXISTS customer_details;

DROP TABLE IF EXISTS account_details;

– CREATE TABLES

CREATE TABLE account_details (

    account_no int(6) NOT NULL auto_increment,

    balance NUMERIC(8,2),

    PRIMARY KEY (account_no)

);

CREATE TABLE customer_details (

    customer_id int(6) NOT NULL auto_increment,

    first_name VARCHAR(30),

    last_name VARCHAR(30),

    date_of_birth DATE,

    email VARCHAR(50),

    phone INT(11),

    street_address VARCHAR(50),

    city VARCHAR(20),

    postcode CHAR(8),

    user_password CHAR(8),

    account_no int(6),

    PRIMARY KEY (customer_id),

    FOREIGN KEY (account_no) REFERENCES account_details(account_no)

);

CREATE TABLE staff (

    staff_id int(6) NOT NULL auto_increment,

    first_name VARCHAR(30),

    last_name VARCHAR(30),

    PRIMARY KEY (staff_id)

);

CREATE TABLE game (

game_number int(6) NOT NULL auto_increment,

kick_off_time datetime,

home_score int (2),

away_score int (2),

result_code char (1),

PRIMARY KEY (game_number)

);

CREATE TABLE odds (

game_number int(6) NOT NULL auto_increment,

result char (1),

first_term int,

second_term int,

PRIMARY KEY (game_number, result),

FOREIGN KEY (game_number) REFERENCES game(game_number)

);

CREATE TABLE bets (

    bet_id int(6) NOT NULL auto_increment,

    amount NUMERIC(8,2),

    customer_id int(6),

    staff_id int(6),

    game_number int(6),

    result char(1),

    PRIMARY KEY (bet_id),

    FOREIGN KEY (customer_id) REFERENCES customer_details(customer_id),

    FOREIGN KEY (staff_id) REFERENCES staff(staff_id),

    FOREIGN KEY (game_number, result) REFERENCES odds(game_number, result)

);

CREATE TABLE team (

team_name char(25) NOT NULL,

position int(2),

stadium varchar (25),

city varchar (20),

PRIMARY KEY (team_name)

);

CREATE TABLE plays

(

game_number int(6) NOT NULL auto_increment,

home_or_away char (1),

team_name char (25),

PRIMARY KEY (game_number, home_or_away),

FOREIGN KEY(team_name) REFERENCES team(team_name),

FOREIGN KEY (game_number) REFERENCES game(game_number)

);