Write some Software in SQL regarding OORDBMS

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.

Taidot: Tietokannan hallinto, MySQL, SQL

Näytä lisää: use of use case diagram, use case to class diagram, use case diagram sample, use case diagram for software design, use case diagram for, use case and class diagram, types of data entry software, the use case diagram, software development info, sample use case diagram, oo design, london data entry, is regarding, free software for data entry, free data entry software, features of use case diagram, design use case diagram, data entry training software, data entry software free, data entry methods

Tietoa työnantajasta:
( 121 arvostelua ) Calcutta, India

Projektin tunnus: #6748545

4 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_18% %project_currencyDetails_sign_sub_19%/tunti tähän työhön


i m a new for this work but i m able to do work like [login to view URL] give me a chance to work with you, i satisfy your criteria.

₹250 INR / tunti
(11 arvostelua)

Hi, I have gone through your requirements,I am a Database Administrator at CMMI-5 Level company since August 2004.I am working on MS Access, Shell Script,MySql,MSSQL Server,Oracle database, I can do your job confidentl Lisää

₹1500 INR / tunti
(28 arvostelua)

I can make You database for this purpose. I guess I need one week to finish that. I think You will be satisfied.

₹400 INR / tunti
(0 arvostelua)

A proposal has not yet been provided

₹777 INR / tunti
(0 arvostelua)