Question

using SQL Database, my topic is to create a sports league managemt database table. was wondering...

using SQL Database, my topic is to create a sports league managemt database table. was wondering if i can get some insight on exactly what i am looking for in creating this table. perhaps a brief explanatjon of what exaclty a sports league managemnt database can consist of

Homework Answers

Answer #1

SPORT LEAGUE MANAGEMENT DATABASE

A sports league, at the most basic level, has the following entities involved:

  • A player who plays the match.
  • An admin who creates a tournament and approves of the tournaments.
  • The player participates in the tournament.
  • Every tournament has its own match schedule.
  • The manager of the tournament, who also manages the match scores.
  • Additionally, each tournament ,can have a notice that can be used to deliver useful information to the participating players.

In addition, if you like, you can also have the news and notifications related to each match schedule for the players to see.

This news should be uploaded by the admin. You can choose the attributes of your own for the entities mentioned above.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
(PHP and My SQL for Dynamic Websites) What version of MySQL are you using? if you...
(PHP and My SQL for Dynamic Websites) What version of MySQL are you using? if you dont know, find out now! What characters can be used in database,table, and column names? Should you treat database,table, and column names as case-sensitive or case-insensitive? What are the three general column types? What are the differences between CHAR and VARCHAR?
I am having a difficult time understanding what my professor is looking for in this research...
I am having a difficult time understanding what my professor is looking for in this research paper and he told me to reread his outline... I am at a loss of how to structure my research paper and would appreciate some quidence. Class: Healthcare Informatics Research paper topic: Information technology in public health disaster emergencies. Outline: -Your task is to produce a review of published literature (at least 70% of sources to be refereed journal papers, the rest can be...
Summary The Ch08_ConstructCo database stores data for a consulting company that tracks all charges to projects....
Summary The Ch08_ConstructCo database stores data for a consulting company that tracks all charges to projects. The charges are based on the hours each employee works on each project. The structure and contents of the Ch08_ConstructCo database are shown in Figure P8.1. Use this database to answer the following problems. Database Schema The schema for the Ch08_ConstructCo database is shown below and should be used to answer the next several problems. Click this image to view it in its own...
SQL DATABASE Task 4 [1.5 marks] Create Index (0.5 marks) Currently, the database only contains a...
SQL DATABASE Task 4 [1.5 marks] Create Index (0.5 marks) Currently, the database only contains a small number of records. However, the data contained within it is expected to grow significantly in the future. Creating indexes on commonly searched columns is a way performance issues can be minimized. Write a command to create an index on student_name column of the student table. Create view – 1 mark Write a command to create a view to list the student ID and...
Answer the following question it is solved using SQL and Lahmans baseball database it uses the...
Answer the following question it is solved using SQL and Lahmans baseball database it uses the 2 tables below. salaries yearID int teamID text IgID text playerID text salary int teams yearID int IgID text teamId text franchID text divID text Rank int G int Ghome text W int L int DivWin text WCWin text LgWin text WSWin text R int AB int H int 2B int 3B int Hr int BB int SO int SB int CS text HBP...
Please reply to this post by a classmate. 150 words minimum. This topic is very interesting...
Please reply to this post by a classmate. 150 words minimum. This topic is very interesting to me as I have never thought about my strengths or weaknesses of my writing skills. I believe a strength that I have in writing is the fact the I read and reread everything that I type before I send it on to anyone. I look to make sure all words are spelled correctly and that all my grammar is used correctly. I try...
create teaching session about smoking cessation Using evidence-based research findings that you apply to your topic,...
create teaching session about smoking cessation Using evidence-based research findings that you apply to your topic, develop the following: Learning objectives Identify your students/audience; what information is most important for them to know/incorporate into their clinical practice? Consider the topic; what are the focused, critical learning components you must assure your students take away from your session? What “clinical pearls” can you teach them that would benefit their patient populations? Research your topic, define the key areas of information you...
Using mySQL, tables at the end... This assignment uses the tables from the vets database. The...
Using mySQL, tables at the end... This assignment uses the tables from the vets database. The goal of the assignment is to get you to think about joins- inner join and outer joins.  If you do a join, where you have the names of two or more tables in the From clause, then you must use the condition join syntax or the column name join. Take care that you do not accidentally do a Cartesian product. If your result set contains...
Scenario 7 ?My husband and I have talked over the matter in great detail,? Marge Gower...
Scenario 7 ?My husband and I have talked over the matter in great detail,? Marge Gower said. ?We don?t care about the sex of the child, but we know exactly the kinds of features we want.? ?Mrs. Gower,? Dr. Louise Singh said, ?you?ve got to understand that we?re not running a mail-order-catalog business for babies.? ?I?m not trying to order a baby. I just want to tell you what I?m looking for in a sperm donor. I want somebody who...
Please create the queries listed below using the books database under question 4. Thanks for the...
Please create the queries listed below using the books database under question 4. Thanks for the help 1. List the number of books, the minimum price, maximum price, and average sales of history books. The format of output is: Number Min Price Max Price Average Sale 2. List the number of books and the average number of pages published by pub_id P01. 3. List the number of books and the total sales of the books with price greater than $15....