<html><body><div style="color:#000; background-color:#fff; font-family:arial, helvetica, sans-serif;font-size:10pt"><div style="font-family: arial, helvetica, sans-serif; font-size: 10pt; ">Ola a todos,</div><div style="font-family: arial, helvetica, sans-serif; font-size: 10pt; "><br></div><div style="font-family: arial, helvetica, sans-serif; font-size: 10pt; ">não tenho experiencia com software open source contudo no ambito do curso que estou a frequentar <span style="font-size: 10pt; ">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.</span></div><div style="font-family: arial, helvetica, sans-serif; font-size: 10pt; "><br></div><div style="font-family: arial, helvetica, sans-serif; font-size: 10pt; "><br></div><div style="font-family: arial, helvetica,
sans-serif; font-size: 10pt; "><span style="font-size: 10pt; ">e a pergunta é</span><br></div><div style="font-family: arial, helvetica, sans-serif; font-size: 10pt; ">é possivel fazer com PostgreSQL, PostGIS, e QGIS queries sobre o seguinte (e se é fácil):</div><div style="font-family: arial, helvetica, sans-serif; font-size: 10pt; "><br></div><div><div><font face="arial, helvetica, sans-serif" size="2">1. Identify the ten local authorities from which most students come to the Department, listed in </font><span style="font-family: arial, helvetica, sans-serif; font-size: small; ">descending order. (List both the district names as well as total no of students in that district)</span></div><div><font face="arial, helvetica, sans-serif" size="2">2. What is the average distance in Kilometres of all schools from the university in kilometres?</font></div><div><font face="arial, helvetica, sans-serif" size="2">3. Identify the five schools that
have sent the most students to the Department and Calculate the </font><span style="font-family: arial, helvetica, sans-serif; font-size: small; ">average distance of these schools from Fartown.(Hint Two queries).</span></div><div><font face="arial, helvetica, sans-serif" size="2">4. The administrator also wants a map showing the top five schools selected in the previous query.</font></div><div><font face="arial, helvetica, sans-serif" size="2">5. The administrator has been invited to a student recruitment fair in the centre of Birmingham and </font><span style="font-family: arial, helvetica, sans-serif; font-size: 13px; ">wants to know whether it is worthwhile attending. How many students did the Department recruit </span><span style="font-family: arial, helvetica, sans-serif; font-size: 13px; ">last year from schools within 15 kilometres of Birmingham city centre? </span><span style="font-family: arial, helvetica, sans-serif;
font-size: small; ">Please explain briefly how you integrated this point into your database as part of your answer.)</span></div><div><font face="arial, helvetica, sans-serif" size="2">6. What percentage of students come from schools that are located within 10 km of the route of the </font><span style="font-family: arial, helvetica, sans-serif; font-size: small; ">M62?</span></div><div><font face="arial, helvetica, sans-serif" size="2">7. The administrator wants a map showing the selected schools from above query along with </font><span style="font-family: arial, helvetica, sans-serif; font-size: small; ">motorway</span></div><div><font face="arial, helvetica, sans-serif" size="2">8. There is going to be a meeting in the Department for schools within the Kirklees and Bradford </font><span style="font-family: arial, helvetica, sans-serif; font-size: 13px; ">local authorities. The administrator wants a list of ALL schools that have
previously sent students </span><span style="font-family: arial, helvetica, sans-serif; font-size: 13px; ">from these local authorities to the department. She also wants the contact details for these </span><span style="font-family: arial, helvetica, sans-serif; font-size: small; ">schools where they are known.</span></div><div><font face="arial, helvetica, sans-serif" size="2">9. The administrator has also asked you to provide her with a map to illustrate her report and to </font><span style="font-family: arial, helvetica, sans-serif; font-size: 13px; ">take to the above meeting. </span><font face="arial, helvetica, sans-serif" size="2">The map has to show the extent of the Kirklees and Bradford areas </font><span style="font-family: arial, helvetica, sans-serif; font-size: 13px; ">with the locations of schools within these areas. </span></div><div><span style="font-family: arial, helvetica, sans-serif; font-size: 13px;
">10. You anticipate that this sort of information will be requested annually and so you are determined to document </span><span style="font-family: arial, helvetica, sans-serif; font-size: 13px; ">your database so that the administrator will be able to operate the database in future. You do not want to </span><span style="font-family: arial, helvetica, sans-serif; font-size: 13px; ">have to do this task yourself every year</span></div><div><span style="font-family: arial, helvetica, sans-serif; font-size: 13px; "><br></span></div><div><span style="font-family: arial, helvetica, sans-serif; font-size: 13px; ">Obrigado</span></div><div><span style="font-family: arial, helvetica, sans-serif; font-size: 13px; ">Pedro</span></div></div></div></body></html>