SQL Basics

 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me



Go Back   Tutorialized ForumsDatabasesSQL Basics

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Tutorialized Forums Sponsor:
  #1  
Old January 22nd, 2018, 10:53 AM
Dani91 Dani91 is offline
Registered User
Tutorialized Newbie (0 - 499 posts)
 
Join Date: Jan 2018
Posts: 0 Dani91 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 26 m 10 sec
Reputation Power: 0
SQL exercise

I need to create database for soccers quotas (odds).In database must be kept teams, leaque, matches according to the following rules:

1.For every team must be kept: name, coat of arms, city, founded year
2.For every leaque must be kept: name, sport (football, basketball...), start date of the season, date of the end of the season
3.For every matche, must to know: in which the league is played, which is the home team, who is visiting the team, the start time, the current home score, the current guest score
4.For each match, the quotas must be remembered, which can be: the winner, the next goal and the winner in the first half. These odds can be active or inactive from the match to the match (so one match can only have a quota for the winner, and some other match may have a quota winner and the next goal, while some third match may have all three odds).

Please I need a help.

Reply With Quote
Reply

Viewing: Tutorialized ForumsDatabasesSQL Basics > SQL exercise


Developer Shed Advertisers and Affiliates


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 

Powered by: vBulletin Version 3.0.5
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.

© 2003-2018 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap