$20 Bonus + 25% OFF
$20 Bonus + 25% OFF
Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
Add File

Error goes here

ITECH1006 Database Management Systems

tag 0 Download3 Pages / 518 Words tag Add in library Click this icon and make it bookmark in your library to refer it later. GOT IT

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, 1 USD Per Page

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 25 September 2021].

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

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


For years, MyAssignmenthelp.com has been operating as one of the cheap assignment help providers in the USA. We are one of the best college paper writing services that keep service price minimal. We do not let the affordability of our service to hamper the standard of our work. We have separate teams of experts to provide report writing help . At MyAssigenmnthelp.com, we believe in earning credibility, so students can pay for assignments only after getting satisfied solutions. Tough assignments bother you? Trust us with your project. You will not regret paying us to write assignments for you.

Latest Management Samples

MGMT2801 International Business

Download : 0 | Pages : 6

Answer Introduction The article on NAFTA negotiations by Robyn Urbac, dated July 28, 2017, was published by the CBC News. The North American Free Trade Agreement, often abbreviated as NAFTA, is being constructed carefully for over twenty three years, in order to create a satisfactory balance of protectionism and liberalization. In such trade negotiations, sum of the opposite views, not necessarily yield a satisfactory medium. This occurs espe...

Read More arrow

BSM2519 Oil And Gas Management

Download : 0 | Pages : 8

Answers 1a. Identify the areas where the parties’ objectives are aligned Obstinate Misconduct of the Investor, Duty holder, and Equipment Vendor or they disappointment to maintain or obtain any insurance that it is needed to maintain or obtain. Apart  from where they used reasonable activities to maintain or obtain some such insurance which is not done notified promptly to the participating of the participant proposing that’s w...

Read More arrow

ACCT20075 Auditing And Ethics

Download : 0 | Pages : 12

Answers: Answer to Question 1 Part 1: ratio analysis The ratio measures whether the investors or the shareholders money is utilized in an efficient manner or not. The efficient manner here relates to the generation of the revenues for the overall development of the company along with its shareholders. The ratio must be high to show that the company has been maintaining its efficiency as per the requirement. As per the table below, the compan...

Read More arrow

ITC505 ICT Project Management

Download : 0 | Pages : 13

Answers: 1. Part 1: Measurable Organizational Value (MOV) The Globex established a prior project on Rivarina Agriculture and Lifetime Show (RALS, a 3 days event) from 2000. This show demonstrates the local business, agricultural equipments suppliers and the lifestyle products as well. For proper management of the RALS projects the components those must be followed by the program developers include show stand co ordination, live display of the...

Read More arrow

SOCI 100 Sociology

Download : 0 | Pages : 3

Answer: The purpose of this essay is to analyze the issues of obesity in America. The essay deals the various factors that contribute to obesity in humans. The essay further deals with risks associated with a person affected with obesity and overweight. It also talks about the preventive measures for reducing the chances of being obese. Obesity, in simple terms, means to have fats in the body in an excess amount. Obesity and being overweight ...

Read More arrow
Next

5% Cashback

On APP - grab it while it lasts!

Download app now

*Offer eligible for first 3 orders ordered through app!

ribbon
callback request mobile
Have any Query?