Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
loader

Phone no. Missing!

Please enter phone for your order updates and other important order related communication.

Add File

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Guaranteed Higher Grade!

ITECH1006 Database Management Systems

tag 0 Download 3 Pages / 518 Words tag 28-07-2021
  • Course Code: ITECH1006
  • University: Federation University
    icon

    MyAssignmentHelp.com is not sponsored or endorsed by this college or university

  • Country: Australia

Question:

The following are the requirements for a design of a database for a new premier soccer league in Australia.Representatives of current Australian state soccer clubs have come together to form the new Australian Premier League (APL). They have set up a Management Board to oversee the creation of this new league, and have commissioned you to design the database. For this first stage, APL are only interested in maintaining data at the club level, to ensure that the clubs are tracking well for future success. Therefore, the APL needs information regarding the running and maintenance of the clubs, including their players and coaches, stadiums, sponsors and sponsor contributions, members, and all saleable merchandise. Any other club financial requirements, including club assets and running inventory are kept on separate financial databases, and are not part of this database project.

All attributes containing metrics will be sourced from club databases and are accumulated values in this database. i.e. player attributes like “number of tackles” etc., will be read from the club database and then added to the current value in this database.
Using the following business rules, design a database that will allow the new Australian Premier League to track their soccer clubs:
The Australian Premier League needs to store the name, city, state and email of all clubs. Each club also needs a unique ID to identify them.

Each club may have one or more sponsors to help finance them during the course of the year. It is also possible that a sponsor may sponsor more than one club.
The league needs to keep a record of a sponsor’s name, email address, and the type of sponsorship and funding amount for sponsorships given to clubs. Each sponsor also needs a unique ID.
A club may also have many members who belong to it. However, a member can only belong to one club. A member would need to have a separate member ID to belong to another club. The league has set this rule to better gauge how many members a club actually has.

The league needs to store the member's ID, first and last name, address, city and post code, and their email address.
Each club stocks a variety of merchandise that they can sell. All clubs have the same types of items, i.e. “Scarf”, “Beanie”, “Jacket”, “T shirt” etc., the only difference between them is the club logo and club colours/patterns.
The club can only sell the merchandise with their branding on it.
The Merchandise needs an ID that shows that it distinctly belongs to the respective club, and what type it is. The selling price and amount sold also need to be stored.
Each club has only one stadium, and stadiums are not shared amongst clubs. If a stadium is unable to be used by the home club team(s), then the game will be played at the other club’s stadium. 
Download Sample Now

Earn back the money you have spent on the downloaded sample by uploading a unique assignment/study material/research material you have. After we assess the authenticity of the uploaded content, you will get 100% money back in your wallet within 7 days.

Upload
Unique Document

Document
Under Evaluation

Get Money
into Your Wallet

Total 3 pages

Cite This Work

To export a reference to this article please select a referencing stye below:

My Assignment Help. (2021). Database Management Systems. Retrieved from https://myassignmenthelp.com/free-samples/itech1006-database-management-system/australian-premier-league.html.

My Assignment Help (2021) Database Management Systems [Online]. Available from: https://myassignmenthelp.com/free-samples/itech1006-database-management-system/australian-premier-league.html
[Accessed 03 December 2022].

My Assignment Help. 'Database Management Systems' (My Assignment Help, 2021) <https://myassignmenthelp.com/free-samples/itech1006-database-management-system/australian-premier-league.html> accessed 03 December 2022.

My Assignment Help. Database Management Systems [Internet]. My Assignment Help. 2021 [cited 03 December 2022]. Available from: https://myassignmenthelp.com/free-samples/itech1006-database-management-system/australian-premier-league.html.


Stuck on Any Question

Our best expert will help you with the answer of your question with best explanation.

question
We will use e-mail only for:

arrow Communication regarding your orders

arrow To send you invoices, and other billing info

arrow To provide you with information of offers and other benefits

Phone no. Missing!

Please enter phone for your order updates and other important order related communication.

loader
250 words
Error goes here

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

We Can Help!

Get top notch assistance from our best tutors !
Excel in your academics & career in one easy click!

icon

Other Samples

Content Removal Request

If you are the original writer of this content and no longer wish to have your work published on Myassignmenthelp.com then please raise the content removal request.

icon

5% Cashback

On APP - grab it while it lasts!

Download app now (or) Scan the QR code

*Offer eligible for first 3 orders ordered through app!

screener
ribbon
callback request mobile
Have any Query?