justify each assumption in terms of the business, for example, it is assumed that each customer must have at least one order because it is assumed that the business does not record customer details until the customer places an order.

High school basketball competitions in CQBasketball have gained popularity in CQ towns in recent years as a result of government funding support and sponsorship from a number of businesses, including CQU, Woolworth, Harvey Norman, and BHP. John Smith, the chairman of the CQ Basketball Youth Association, wants to organize numerous continuous competitions for high school kids in the CQ region. He invites each team to play in the competition, which consists of a number of matches and urges every school to join a team. He must create a relational database to keep track of the match outcomes and pertinent data. Your objective in this project is to take into account the following requirements and create an E-R model for a database conceptual model to facilitate the creation of such a database system. Each school’s students must band together to form a team in order to compete. Each team may consist of as many students as feasible, but only five students are grouped together to form a smaller team for each competition. It goes without saying that such a database would need to maintain track of player information; each player’s name, residence, phone number, and age would need to be noted in addition to their unique identification number. Additionally, the team’s name, foundation date, and description of its symbolic flag are all stored in the database. Typically, each team has a coach, either a head coach or an assistant coach. Each coach must possess a current blue card. Along with their names and phone numbers, the principal coach’s tenure as such is noted, while the assistant coach’s level of sports coaching certification (given by the State Sports Committee) is required. Each tournament’s title or name and the location in which it is played are recorded in the database. For illustration, consider The potential title “2014 CQU Cup Basketball Tournament”. Each competition consists of a number of matches. The database’s most crucial component is its ability to keep track of each match’s outcome, along with the date, competition, and participating teams. Each match is given a special identification number, and the necessary data, including the start date and time, referee, and stadium, must be stored in the database. Two teams compete in each match, and throughout the tournament, each team will play in numerous matchups. It is important to note the score each team earns in a given match as well as the result (whether they win, lose, or draw). Each game will be played in a specific stadium, and one referee will serve as the judge for each round of competition. The referee’s name and phone number must be noted. A referee can, of course, officiate a variety of games. The crucial data to record in the to-be-created database for each stadium includes the name of the stadium or athletic center, address, and a description of the facilities that are offered. Typically, a few sponsors lend their financial support to each tournament. A sponsor could provide funding for several competitions. They must appropriately report in the database how much sponsorship money they received for each competition. The system must also record the amount of cash prizes that each team takes home after competitions. Because one of your duties for this project is to do your analysis and research based on the case study description and general knowledge, the preceding specification may not have all the details. Relational data model for entities You must create an ER model to reflect the information needs for a database that will be used by the CQ Basketball Youth Association, as stated on the previous page. • Display all required entities, attributes, and relationships in your ER model. Showing unique identifiers, multi-valued characteristics (sometimes known as repeated attributes), and, if applicable, associative entities. Use consistent and suitable naming for entities and characteristics across the board (see Chapters 2 and 3 of the set text). Use the notation described in the set text. You might not understand all of the case study’s details after reading it due to certain business rules or other factors. If this is the case, you should either ask your lecturer or tutor for clarification, or you can assume it is, in which case you should adjust your ER model. For instance, the case study may not have covered all pertinent participation data (also known as minimum cardinalities). If so, you can guess what the minimal cardinalities should be and display them in your ER model in accordance with your assumption. For instance, it is assumed that each customer must have at least one order since it is assumed that the business does not record customer information until the client places an order. You should support each assumption with examples from the business. To get started, consider the following question: “What would I need to keep a list of if I were running this business?” Put such things in writing. What details would you need to keep track of for each item? Brief definitions for the entities and attributes in your model must be written. Write a phrase that briefly summarizes the significance of each item and attribute in your model. Refer to the set text’s Naming and Defining Entity Types and Naming and Defining Attributes sections for more information. For instance, STUDENT: An individual who has registered for one or more programs at the university is known as a student. High school students enrolled in Start Uni Now are included in this; prospective students are not. Student No. : Identifies each student specifically. Student Name: The student’s complete name. Date of Birth: The pupil’s birthdate. A program is a course of study offered by the university. Programmed in: each program is identified specifically. The complete name of the program is its name. … What you ought to send: You must deliver a Microsoft Word document that includes Your entity-relationship model(s) in duplicate. • A summary of the business principles that the case study makes clear. • A summary of any assumptions you made, along with any reasons (including any clarifications from your professor). • Definitions of your entities and attributes. Your paper should be properly formatted and contain the necessary identifying information (your student number, name, course number, etc.). For instance, your document should have headings for each section as well as a very brief opening that states the goal of the paper.