Cw Comp1302 Essay

FPT University – University of Greenwich

Topup Program – Ho Chi Minh Town Centre

590 Cach Mang Thang W tamtym miejscu, District 3, HCMC

DATA SOURCE DESIGN AND IMPLEMENTATION

COURSEWORK REPORT

College student Name: Bui Minh Quang

Class: GT60027

Lecturor: Huynh Anh Assiste a

Date of Submission: The fall of 8th 2010

Database Design and Execution – Coursework Report

Category: GT60027 – Student Identity: Bui Minh Quang

Stand of Contents

1 .

2 .

3.

four.

5.

6th.

Business Rules ………………………………………………………………………3 Entity Relationship Diagram ………………………………………………………4 Regards Schema …………………………………………………………………… 5 3rd NF Checking ……………………………………………………………………. six SQL Script for A2 – A4 ……………………………………………………………. several Screen deposits …………………………………………………………………... almost 8 -14

Web page 2

Databases Design and Implementation – Coursework Record

Class: GT60027 – Student Name: Bui Minh Quang

BUSINESS RULES

- Program will record one crew as the " House team” (the team owns the hockey court that is to be played on) and the leftover team while " Aside team”.

-- Amateurs also have to sign a contract wit h the team but their income is zero. System may also record total amount of expenses the team put in for that player.

- Every single player (including amateur and professional) will be identified by way of a SSN (Social Security Number, aka ID). - System also information the main manager, coach and owner (only one current person in each field) of each club. - The previous contracts information of virtually any player will be saved inside the system. -- Each team can have many playing legal courts but will need to have at least one. -- Only record matches in the tournament. For international and other national matches, we simply count the number (Therefore the overall national meet may be diverse fro m total meet in the tournament). - A team can play on additional team's the courtroom as " Home team”. - If a team causes a penalty, the opponent group may get two free punches. Each effective free toss will be compensated one report.

- Each match consists of two 20-minutes halves.

- In a meet, player can play in a variety of positions.

Web page 3

Repository Design and Implementation – Coursework Record

Class: GT60027 – College student Name: Bui Minh Quang

ENTITY-RELATIONSHIP PLAN

Note

AMATEUR

PROFESSIONAL

M

TwoPtsMade

TwoPtsAttempt

SSN

FEATURES

d

HomeTeamScore

ThreePtsAttempt

MinutePlayed

AwayTeamScore

ThreePtsMade

N

Meters

PLAYER

N

ATTENDS

MATCH

Foul

HOBBIES

FreeThrowMade

Rebound

M

StartDate

HobbyID

one particular

PLAY_IN

EndDate

FreeThrowAttempt

HomeTeam

SIGNS

N

N

ContractID

N

SITUATION

PLAY_FOR

And

CONTRACT

one particular

HAS

D

1

Color note:

Organization

Entity with Subclasses

Marriage

Relationship with Attributes

Major Key Feature

Relationship Attribute

Derived Characteristic

PLAY_ON

one particular

N

PositionID

MatchID

(2, 2)

GIVES

1

GROUP

1

HAS

N

COURT DOCKET

TeamID

CourtID

Page four

Database Style and Execution – Schoolwork Report

Course: GT60027 – Student Identity: Bui Minh Quang

RELATIONAL SCHEMA

Interests (HobbyID, HobbyName, Description);

HobbyDetails (HobbyDetailsID, HobbyID, SSN, Note); /*HobbyID referring to Hobbies. HobbyID, SSN referencing Player. SSN*/

Player (SSN, TeamID, FirstName, MidName, LastName, Height, Fat, DateOfBirth, NoOfIntMatch, NoOfNatMatch, PlayerType, Occupation, NameOfInstitute, TotalExpenses); /*TeamID referencing Team. TeamID*/

PostionDetails (PositionDetailsID, PositionID, SSN, StartDate, EndDate); /*PositionID referencing Placement. PositionID, SSN referencing Person. SSN*/

Placement (PositionID, PositionName, Description);

Deal (ContractID, SOCIAL SECURITY NUMBER, TeamID, Type, DateOfStart, FinishDate, Salary, BindingCondition); /*TeamID referring to Team. TeamID, SSN referencing Player. SSN*/

Team (TeamID, TeamName, Province, District, Number, ManagerFName, ManagerMName, ManagerLName, CoachFName, CoachMName, CoachLName, OwnerFName, OwnerMName, OwnerLName);

Functionality (PerformanceID, SOCIAL SECURITY NUMBER,...

Popular

 Proposal intended for Web Based Placing your order and Management System Essay
Proposal intended for Web Based Placing your order and Management System Essay

CHAPTER We BACKGROUND FROM THE STUDY AND IT IS SETTING Introduction In the fast changing environment of business, technology played a fantastic role in advancing organization transaction to attain…...

 ECT122 Wk3 Assignment Article
ECT122 Wk3 Assignment Article

Chapter four Series Circuit Practice Problems 1 . All the following resistor combinations can be connected as shown in figure 5. 29. For each combination, determine the…...

 An Anaysis on a Streetcar Named Desire by Tn Williams Dissertation
An Anaysis on a Streetcar Named Desire by Tn Williams Dissertation

A Streetcar Named Desire is 1947 play authored by Thomas Lanier " Tennessee” Williams 3. It is based upon Blanche's visit to her sis and her conflicts with Stella's husband…...

 Millennium Overall health Goals Essay
Millennium Overall health Goals Essay

The purpose of this paper is usually to evaluate the effects that are used to measure improvement towards conference the Centuries health desired goals. This display would eventually provide details…...