This element consists of an OO Database development to showcase the use of Oracle’s object relational features . At the start of the module you will be introduced to the various OO features supported by Oracle which should be incorporated into your development. For the case study provided you are required to:
1. Produce a class diagram for the scenario provided (West London Social Netball Association).
2. Implement the design, incorporating OO features (UDTs, collection types, inheritance, methods, etc); insert some sample data into the tables you have set up; provide data entry scripts for each table; provide 6 outputs that meet some stated requirement of the case study. Your outputs should also be chosen to best demonstrate your OO features
The West London Social Netball (WLSN) organises netball tournaments in the West London area for anyone interested in playing netball for fun. It has a number of leagues, for varying abilities of player. Players sign up and pay a small annual membership fee. On registration, as well as being asked for personal, contact info etc, they are asked to list the three positions they like to play in (Centre, Wing defence, Goal Defence, etc), in order of preference. Occasionally guest players (friends of members etc) are allowed to play free of charge, but they are only allowed to play in two fixtures per season - if they register for any more they are required to pay the membership fee.
A schedule outlining the date/time, location of matches, etc is published at the start of the season. A league can have many teams but the membership of each team playing in a league match (7 players and two substitutes) can vary depending on the availability of its players. The final list of team members and the positions they are playing in must be made available at least a week before the date of a match. Each fixture requires an umpire. Umpires are paid a small fee for each match. They must demonstrate that they have had the requisite training to be an umpire and that this training has been updated every year. Their training/qualifications are checked on a regular basis.
The result of each fixture needs to be stored. In addition, a player is picked as ‘player of the match’ and this also needs to be recorded, as the player with the most ‘player of the match’ nominations is presented with a prize at the end of the season.