Cw Comp1302
FPT University – University of Greenwich
Topup Program – Ho Chi Minh City Centre
590 Cach Mang Thang Tam, District 3, HCMC
DATABASE DESIGN AND IMPLEMENTATION
COURSEWORK REPORT
Student Name: Bui Minh Quang
Class: GT60027
Lecturor: Huynh Anh Vu
Date of Submission: November 8th 2010
Database Design and Implementation – Coursework Report
Class: GT60027 – Student Name: Bui Minh Quang
Table of Contents
1.
2.
3.
4.
5.
6.
Business Rules ………………………………………………………………………3
Entity Relationship Diagram ………………………………………………………4
Relation Schema …………………………………………………………………… 5
3rd NF Checking …………………………………………………………………….6
SQL Script for A1 – A4 …………………………………………………………….7
Screen dumps …………………………………………………………………...8 -14
Page 2
Database Design and Implementation – Coursework Report
Class: GT60027 – Student Name: Bui Minh Quang
BUSINESS RULES
- System will record one team as the “Home team” (the team owns the basketball court that will be played on) and the remaining team as “Away team”.
- Amateurs also have to sign a contract wit h the team but their salary is zero. System will also record total amount of expenses that the team spent for that player.
- Each player (including amateur and professional) will be identified by their SSN (Social Security Number, aka ID).
- System also records the main manager, coach and owner (only one current person in each field) of each club.
- The previous contracts information of any player will be saved in the system.
- Each team can have many playing courts but must have at least one.
- Only record matches in the tournament. For international and other national matches, we only count the number
(Therefore the total national match may be different fro m total match in the tournament).
- A team can play on other team’s court as “Home team”.
- If a team causes a penalty, the opponent team may get two free throws. Each successful free throw will be rewarded one score. - Each match consists of two
Topup Program – Ho Chi Minh City Centre
590 Cach Mang Thang Tam, District 3, HCMC
DATABASE DESIGN AND IMPLEMENTATION
COURSEWORK REPORT
Student Name: Bui Minh Quang
Class: GT60027
Lecturor: Huynh Anh Vu
Date of Submission: November 8th 2010
Database Design and Implementation – Coursework Report
Class: GT60027 – Student Name: Bui Minh Quang
Table of Contents
1.
2.
3.
4.
5.
6.
Business Rules ………………………………………………………………………3
Entity Relationship Diagram ………………………………………………………4
Relation Schema …………………………………………………………………… 5
3rd NF Checking …………………………………………………………………….6
SQL Script for A1 – A4 …………………………………………………………….7
Screen dumps …………………………………………………………………...8 -14
Page 2
Database Design and Implementation – Coursework Report
Class: GT60027 – Student Name: Bui Minh Quang
BUSINESS RULES
- System will record one team as the “Home team” (the team owns the basketball court that will be played on) and the remaining team as “Away team”.
- Amateurs also have to sign a contract wit h the team but their salary is zero. System will also record total amount of expenses that the team spent for that player.
- Each player (including amateur and professional) will be identified by their SSN (Social Security Number, aka ID).
- System also records the main manager, coach and owner (only one current person in each field) of each club.
- The previous contracts information of any player will be saved in the system.
- Each team can have many playing courts but must have at least one.
- Only record matches in the tournament. For international and other national matches, we only count the number
(Therefore the total national match may be different fro m total match in the tournament).
- A team can play on other team’s court as “Home team”.
- If a team causes a penalty, the opponent team may get two free throws. Each successful free throw will be rewarded one score. - Each match consists of two