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

Home   Course   Federation University, Australia Assignment Help
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

    Cyber Security Assignment Help

    cyber security assignment help - The following assignment talks about the cybersecurity of supply chains and discusses the various risks associated with it.

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