It is necessary to create a database in which there is a Circle table (there is a name, address, max. Number of children), a Coach table, which can lead several circles (it has a Name, Last Name, Telephone Number). Sports school, in which there are several circles, and also there is a coach (by attributes: Address, phone number). Group of children (Name, time of start / end of classes). Actually, the Activities themselves (attributes: Group, Start time, Duration). And also the Groups of Children themselves (First Name, Last Name, Telephone Number).

So with the creation of a database of questions no. There are some difficulties with creating requests for processing information in this database: You need scripts to view: 1. The circles themselves are grouped around Sport Schools 2. Creating new Groups of children, indicating Mug, Sport Schools and trainers. 3. Creating a roster for the Group, indicating all Occupations. It should all be for MySQL

Who can help please, thanks in advance!

  • Give an example of SQL queries (code) with which problems arise - Hekumok
  • These are the three requests, which I indicated in above - Karl Dopolsky
  • 1.Samikh circles, grouped by Sport.Shkolah 2.Creating new groups of children, indicating Mug, Sport.Schools and coaches. 3. Creating a roster for the Group, indicating all Occupations. - Karl Dopolsky 9:39

0