Do You Need ITECH2004 Data Modelling Assignment Help? Then Hire Tutors From ExpertsMinds.Com!

Home   Course  
Previous << || >> Next

GET GUARANTEED SATISFACTION OR MONEY BACK UNDER ITECH2004 DATA MODELLING ASSIGNMENT HELP SERVICES OF EXPERTSMINDS.COM - ORDER TODAY NEW COPY OF THIS ASSIGNMENT!

ITECH2004 Data Modelling - Federation University

Overview

The purpose of this task is to develop student's skills in designing and implementing a relational database for a given case study.

Learning Outcome 1: Describe relational algebra and its relationship to Structured Query Language (SQL).

Learning Outcome 2: Interpret entity-relationship diagrams to implement a relational database.

Learning Outcome 3: Demonstrate skills in designing and building a database application using a commercially available database management system development tool.

Learning Outcome 4: Use a query language for data manipulation.

Learning Outcome 5: Design and implement a relational database using a database management system.

Learning Outcome 6: Utilise a query language tools and techniques to obtain data and information from a database.

EXPERTSMINDS.COM ACCEPTS INSTANT AND SHORT DEADLINES ORDER FOR ITECH2004 DATA MODELLING ASSIGNMENT - ORDER TODAY FOR EXCELLENCE!

Relational Schema

Relational Schema.jpg

WORK TOGETHER WITH EXPERTSMIND'S TUTOR TO ACHIEVE SUCCESS IN ITECH2004 DATA MODELLING ASSIGNMENT!

Question: Write the SQL command to change the season year for season number 3 to 2017.

Solution:
UPDATE SEASON
SET SEA_Year =2017
WHERE SEA_ID = 3;

SEA_ID                                                                        SEA_YEAR

1                                                                                   2015

3                                                                   2017

5                                                                   2017

7                                                                   2019

9                                                                   2011

Question: Write SQL command(s) to create a derived attribute that represents a new surrogate primary key for the Game table.

Solution:
ALTER TABLE Game
ADD GameSurrogateKey INT IDENTITY(1,1);

GAME_ID

SEA_ID

GAME_Location

GAME_Date

GAME_Conference

GI

1

Audi

2002

Eastern

G2

2

Audi Field

2004

Eastern

G3

3

Saputo Stadium

2003

Eastern

G4

4

Rio Tinto Stadium

2000

Western

G5

5

Childrens Mercy

2007

Western

 

 

Park

 

 

G6

6

Red Bull Arena

2001

Eastern

DO YOU WANT TO EXCEL IN ITECH2004 DATA MODELLING ASSIGNMENT? HIRE TRUSTED TUTORS FROM EXPERTSMINDS AND ACHIEVE SUCCESS!

Question: Write SQL command(s) to create a new table called EventTypes that contains a single listing of all Event types from EventsDataView

Solution:
CREATE TABLE EventTypes
AS
SELECT Distinct E_Type FROM EventsDataView;

Question Write SQL command(s) to create a new table for player statistics.

Solution:
CREATE TABLE PlayerStatistics
AS
SELECT P.PLAY_Name,AVG(D.T_PLAYER1_T1_X+D.T_PLAYER1_T1_Y+D.T_PLAYER2_T1_X+D.T_PLAYER2_T1_Y) as avg_pitch
FROM PLAYER P JOIN Team S
ON P.Team_ID=S.Team_ID
JOIN EventsDataView V
ON S.TEAM_ID=V.TEAM_ID
JOIN TracksDataView D
ON V.GAME_ID=D.GAME_ID
GROUP ByP.PLAY_Name;

Question: Write SQL command(s) alter the TracksDataView table to include a derived attribute named DistanceFromBall which represents the Euclidean distance between each player and the ball.

Solution:
ALTER TABLE TracksDataView
ADD DistanceFromBall double;

NEVER LOSE YOUR CHANCE TO EXCEL IN ITECH2004 DATA MODELLING ASSIGNMENT - HIRE BEST QUALITY TUTOR FOR ASSIGNMENT HELP!

Question: Alter the Game table to include attributes that represent the final score of the game, and update with some simulated values.

Solution:
ALTER TABLE GAME
ADD FinalScore INT;

Question: Alter the EventsDataView and TracksDataView tables to include an attribute named PitchArea to store character data up to ten characters long.

Solution:
ALTER TABLE PLAYER
ADD DateOfBirth date;

Question: Write SQL command(s) to cerate a new table called TrackLogs and extract all tracklog data into this.

Solution:
CREATE TABLE TrackLogs
AS (SELECT *
FROM TracksDataView
WHERE id > 1000);

Question: Write SQL command(s) to see if any particular players have been sent off (Type="CARD", Subtype="RED") more than once by a particular referee.

Solution:
Select E_From,E_To From EventsDataView
Where E_TYPE='PASS' and E_TYPE='Red';

ORDER NEW ITECH2004 DATA MODELLING ASSIGNMENT & GET 100% ORIGINAL SOLUTION AND QUALITY WRITTEN CONTENTS IN WELL FORMATS AND PROPER REFERENCING.

Question: Alter the player statistics table to include attributes named "YellowCards" and "RedCards" which represent the count of these cards issued to a player. The attribute should not accept null values, and it should have a default value of 0.

Solution:
ALTER TABLE PLAYER
ADD YellowCardvarchar(255);
ALTER TABLE PLAYER
ADD redCardvarchar(255);

Question: Create a new table to contain the following statistics about each game: the number of Cards issued;the number of passes; and, the number of scoring attempts.

Solution:
CREATE TABLE GameStatistic (Stat_IDINT(10) NOT NULL PRIMARY KEY,
No_of_CardsINT(10),
No_of_PassesINT(10),
No_of_ScoreINT(10),
PlayerIDVARCHAR(10),
FOREIGN KEY (PlayerID) REFERENCES PLAYER (PLAY_ID));

Question: For each scoring event calculate derived attributes which represent the distance of the scorer from the goal line, and the distance from them to the nearest opponent.

Solution:
CREATE TABLE GoalG (Goal_IDINT(10) NOT NULL PRIMARY KEY,
Goal_ShotsINT(10),
Corners INT(10),
Fouls INT(10),
GAME_ID VARCHAR(10),
FOREIGN KEY (GAME_ID) REFERENCES GAME(GAME_ID));

ARE YOU LOOKING FOR RELIABLE ITECH2004 DATA MODELLING ASSIGNMENT HELP SERVICES? EXPERTSMINDS.COM IS RIGHT CHOICE AS YOUR STUDY PARTNER!

Below are the related courses in which ExpertsMinds precisely deal with:

  • ITECH1104 Cloud and enterprise computing assignment help
  • ITECH3001 User experience assignment help
  • ITECH1101 IT problem solving assignment help
  • ITECH1001 Communications and technology assignment help
  • ITECH2003 Web design assignment help
  • ITECH1103 Big data and analytics assignment help
  • ITECH2004 Data modeling assignment help
  • ITECH3002 Professionalism and entrepreneurship assignment help
  • ITECH3215 Information security assignment help
  • ITECH3100 Cloud and mobile security assignment help
  • ITECH2000 Mobile development fundamentals assignment help
  • ITECH2002 Systems modeling assignment help
Tag This :- ITECH2004 Data Modelling Assignment Help, WPS200841TASK3_ITECH2004

get assignment Quote

Assignment Samples

    China History Assignment Help

    china history assignment help - the paper is related to the china culture and also determines the relation to the past era.

    Enron Assignment Help

    enron assignment help - Enron was admired prior to 2000 for its effective management, high returns from investment and long term agreements with its customers.

Get Academic Excellence with Best Skilled Tutor! Order Assignment Now! Submit Assignment