database design


Consider a database system for the organisation of fixtures and results in a soccer league. The data requirements are summarized as follows:

The people involved in the league include players, coaches, managers,and referees. Each person is identified by a unique personnel id. They are also described by their first and last names along with the date and place of birth. Players are further described by other attributes such as theirposition on the field (goal-keeper, defender, midfielder, or forward) and have a squad number associated with them.

Teams are uniquely identified by their names. Teams are also described by the city in which they are located and the division and league in whichthey play (such as premier division or first division). Teams have one manager, a number of coaches, and a number of players. One of these players is the captain. At the beginning of each season all fixtures should be available to view in the database. Each team plays every other team twice (once at home and once away). Games are played between two teams with one assigned referee. For any particular game on a particular date, there is one team designated as the home team and the other team designated as the away team. Once the game has taken place, the final result of the game is recorded. The score and the scorers are recorded for each team.

Habilidades: Design Gráfico, HTML, PHP, SQL, Design de Sites

Veja mais: teams design, system keeper, squad graphic design, premier design, home design games, home design game, graphic names design, graphic design manager, graphic design database, graphic design at home, design squad, beginning graphic design, the goal of graphic design is to, soccer design, premier league, database system, database design, captain, result soccer, database players, recorded game, design twice, available coaches soccer, database design php, soccer results

Acerca do Empregador:
( 6 comentários ) Essex, United Kingdom

ID do Projeto: #5121320

Concedido a:


Easy task can do [login to view URL] task can do [login to view URL] task can do [login to view URL] task can do [login to view URL] task can do [login to view URL] task can do it.

£84 GBP em 3 dias
(77 Comentários)

9 freelancers estão ofertando em média £135 para esse trabalho


Hello, We can definitely serve you with your requirements of creating an HTML5/CSS3 website. We will deliver you with a Flawless website as per your Specification briefed. The resultant website delivered to you w Mais

£180 GBP in 7 dias
(222 Comentários)

10+ years experience. 500+ projects completed successfully. I am very interested in this database design project. Do you want an ER diagram? Kindly send me complete details. Ready to start ASAP.

£142 GBP in 3 dias
(278 Comentários)

I have experience of 7+years PHP, Wordpress development. We are expert in php, wordpress, codeigniter, Opencart, Magento, DRUPAL, CakePHP, mysql, javascript using jquery, html5, css3, bootstrap, photoshop and psd to ht Mais

£250 GBP in 7 dias
(55 Comentários)

Hi, I am a php mysql expert. I am ready to work in your project. Pls look at some portfolio I am expert in E-commerce [login to view URL] [login to view URL] [login to view URL] Mais

£150 GBP in 7 dias
(29 Comentários)

A proposal has not yet been provided

£44 GBP in 3 dias
(11 Comentários)

Let's start and check my profile. want to know anything else just send me a message with detail requirements.

£100 GBP in 3 dias
(12 Comentários)

I'm an expert in building big DB's and fast queries. Optimized DB structure is a must when you have so many relations like in your project.

£150 GBP in 3 dias
(0 Comentários)

this is my previous work please check it we will Do this project 100% [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] Mais

£111 GBP in 7 dias
(0 Comentários)