[Portugal] postgre

[pedro soares]

Ola a todos,

não tenho experiencia com software open source contudo no ambito do curso que estou a frequentar foi-me pedido para um trabalho com open source. os dados são-me disponibilizados. o que tenho de fazer é um modelo conceptual da bd (já agora alguem sabe o que é o "Third Normal Form"?), mapas em qgis, linhas sql da bd e das queries.


e a pergunta é

é possivel fazer com PostgreSQL, PostGIS, e QGIS queries sobre o seguinte (e se é fácil):

1. Identify the ten local authorities from which most students come to the Department, listed in descending order. (List both the district names as well as total no of students in that district)
2. What is the average distance in Kilometres of all schools from the university in kilometres?
3. Identify the five schools that have sent the most students to the Department and Calculate the average distance of these schools from Fartown.(Hint Two queries).
4. The administrator also wants a map showing the top five schools selected in the previous query.
5. The administrator has been invited to a student recruitment fair in the centre of Birmingham and wants to know whether it is worthwhile attending. How many students did the Department recruit last year from schools within 15 kilometres of Birmingham city centre? Please explain briefly how you integrated this point into your database as part of your answer.)
6. What percentage of students come from schools that are located within 10 km of the route of the M62?
7. The administrator wants a map showing the selected schools from above query along with motorway
8. There is going to be a meeting in the Department for schools within the Kirklees and Bradford local authorities. The administrator wants a list of ALL schools that have previously sent students from these local authorities to the department. She also wants the contact details for these schools where they are known.
9. The administrator has also asked you to provide her with a map to illustrate her report and to take to the above meeting. The map has to show the extent of the Kirklees and Bradford areas with the locations of schools within these areas. 
10. You anticipate that this sort of information will be requested annually and so you are determined to document your database so that the administrator will be able to operate the database in future. You do not want to have to do this task yourself every year

Obrigado
Pedro
-------------- próxima parte ----------
Um anexo em HTML foi limpo...
URL: http://lists.osgeo.org/pipermail/portugal/attachments/20120116/9dada8dc/attachment.html