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
_______________________________________________
Portugal mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/portugal
