Database Management
Coursework Header Sheet 172806-18
Course Coursework Tutor
COMP1302: DB Design & Implementation DBDI - COLOMBO - DEC 10 - AC A Al-Zobaidie
Course School/Level Assessment Weight Submission Deadline
CM/UG 50.00% 09/11/2010
Coursework is receipted on the understanding that it is the student's own work and that it has not, in whole or part, been presented elsewhere for assessment. Where material has been used from other sources it has been properly acknowledged in accordance with the University's Regulations regarding Cheating and Plagiarism.
000592677 Tutor's comments
Grade For Office Use Only__________ Awarded___________ Moderation required: yes/no Tutor______________________
Final Grade_________ Date _______________
[INOKA MEDAGODA COMP 1302]
Page 1
Table of Contents
Content
Page
D1. Business Rules D2. ER Diagram D3. Relational Schema D4. Normalization D5. Database View D6. SQL Codes D7. Player Registration Form D8. Report D9. Master detail form Reference
02 - 03 03 - 04 04 - 05 05 - 06 06 - 07 07 - 08 08 - 11 11 - 13 13 – 15 15 - 16
[INOKA MEDAGODA COMP 1302]
Page 2
D1. BUSINESS RULES
1. An amateur player can have only one hobby. 2. A Match can be uniquely identified by its match date and the place. Therefore only one match can be played in a particular court at a particular day. 3. A club will have only one team therefore a club can be identified by the team. 4. A player can have multiple positions but at a given time slot he should hold a particular position.
[INOKA MEDAGODA COMP 1302]
Page 3
D2. ER DIAGRAM
FName
LName Hobby Salary Start_date Team No
Name Age
Amateur Professional
M
1
Belongs To
Team
Address
Player ID D Street
City
1
Postcode
Player
1 M M
Holds Perform_In
M
Match_Date
M M
Matches
Match_Place
M
Position ID
Position
Winning Team
Player of the match
Experiance
[INOKA MEDAGODA COMP 1302]
Page 4
D3.
Course Coursework Tutor
COMP1302: DB Design & Implementation DBDI - COLOMBO - DEC 10 - AC A Al-Zobaidie
Course School/Level Assessment Weight Submission Deadline
CM/UG 50.00% 09/11/2010
Coursework is receipted on the understanding that it is the student's own work and that it has not, in whole or part, been presented elsewhere for assessment. Where material has been used from other sources it has been properly acknowledged in accordance with the University's Regulations regarding Cheating and Plagiarism.
000592677 Tutor's comments
Grade For Office Use Only__________ Awarded___________ Moderation required: yes/no Tutor______________________
Final Grade_________ Date _______________
[INOKA MEDAGODA COMP 1302]
Page 1
Table of Contents
Content
Page
D1. Business Rules D2. ER Diagram D3. Relational Schema D4. Normalization D5. Database View D6. SQL Codes D7. Player Registration Form D8. Report D9. Master detail form Reference
02 - 03 03 - 04 04 - 05 05 - 06 06 - 07 07 - 08 08 - 11 11 - 13 13 – 15 15 - 16
[INOKA MEDAGODA COMP 1302]
Page 2
D1. BUSINESS RULES
1. An amateur player can have only one hobby. 2. A Match can be uniquely identified by its match date and the place. Therefore only one match can be played in a particular court at a particular day. 3. A club will have only one team therefore a club can be identified by the team. 4. A player can have multiple positions but at a given time slot he should hold a particular position.
[INOKA MEDAGODA COMP 1302]
Page 3
D2. ER DIAGRAM
FName
LName Hobby Salary Start_date Team No
Name Age
Amateur Professional
M
1
Belongs To
Team
Address
Player ID D Street
City
1
Postcode
Player
1 M M
Holds Perform_In
M
Match_Date
M M
Matches
Match_Place
M
Position ID
Position
Winning Team
Player of the match
Experiance
[INOKA MEDAGODA COMP 1302]
Page 4
D3.