roditalia

Opa desculpa. mas a ideia q se alguém quisesse seria reembolsado. De qualquer jeito obrigado!

Se alguém estiver disposto a resolver este exercicio favor entrar em contato. italo59@hotmail.com Tem q ser feito em ingles e a data de entrega é dia 01/08 To develop a database system - by carrying out the following (development) phases: 1. Conceptual design 2. Logical design 3. Physical design and implementation 4. Data retrieval using SQL DML 5. Data retrieval and display through an Web-based interface Scenario PlaceBook is a site for sharing information about places, photographs and arranging meetings. Design a database that will enable PlaceBook members to add photos, places and visits. Members should also be able to allocate other members as friends who are able to browse all of the information they add. Places are identified and named by members. Their locations are described either by a point or an enclosing rectangle. Points consist of a pair of x,y coordinates. Rectangles consist of two pairs of x,y coordinates identifying the north‐west and south‐east corners. Members can add unstructured text and any number of optional tags to describe a place. Note that each member may add, describe and locate the same ‘place’ (e.g. Northampton Square) differently, but a member must give each of the Places they add a unique name. All photos are associated with a place Photos may also be optionally associated with a visit. The date and time at which each photo is taken is recorded in PlaceBook along with file name and a photo number that uniquely identifies each photo added by any individual member. Unstructured text and tags can be added by the photo’s owner to describe each photo. Any member who views a photo owned by one of their friends can rank it from 0‐5. Visits are periods of time when members are at particular places. Members sign up with a unique name. Their full names, dates of birth and time and date of most recent activity must be recorded in PlaceBook. For the purpose of this exercise assume that all Places are in London. Use the British National grid for coordinates, which should be within the following bounding box: North 200,000 South 150,000 East 560,000 West 500,000 Exercicio 1. Create an Entity Relationship diagram that models this scenario. Ensure all the requirements are captured. Do not include additional functionality. Use Enhanced ER modelling to show specialization/generalization where appropriate. Use the UML class diagram notation. Show the primary keys (PKs) in the (E)ER model, but not the foreign keys unless they are part of a composite PK. Generate records for five PlaceBook members, including members named Adele and Bruno. 2. Develop a Web page that shows … i. photos that are tagged “architecture”, rated 3 or higher on average and owned by friends of Bruno and that were taken this year ii. photos that are tagged “architecture”, rated 3 or higher on average and owned by friends of Bruno and that were taken this year of places visited by friends of Adele in the last month The page should include a single SQL statement that extracts the appropriate information from your database and use an HTML table to present the output.

Primeiro Obrigado por responder... Na verdade isso eu estou querendo aprender ...Me deixa frustrado quando eu quero fazer uma coisa e não consigo. A parte do trabalho era bem mais simples... era so selecionar o atleta com o maior numero de pontos no evento 'x' na fase final... Mas aqui esta o q eu consegui ateh agora... SELECT atleta.aNome as 'Nome', atleta.aSNome as 'Sobrenome', atleta.paisId 'Pais', evento.eventoNome as 'Evento', fase.faseNome as 'Fase', juiz.jNome as 'Juiz', eventoInfo.Data,(select SUM(nota.nota) From nota) as Total FROM atleta INNER JOIN eventoInfo ON atleta.atletaId = eventoInfo.eventoInfoId INNER JOIN nota ON nota.notaId = eventoInfo.notaId INNER JOIN evento ON evento.eventoId = eventoInfo.eventoId INNER JOIN fase ON fase.faseId = eventoInfo.faseId INNER JOIN juiz ON juiz.juizId = eventoInfo.juizId

Necessito ajuda urgente para consultar esse BD.. Eu tenho estas tabelas: `atleta` ( `idAtleta` int(15) `aNome` varchar(25) `aSNome` varchar(25) NOT NULL, `aDataNasc` date NOT NULL, `reserva` enum('Y','N') NOT NULL, `sexoId` char(1) NOT NULL, `paisId` varchar(5) NOT NULL, PRIMARY KEY (`IdAtleta`), ) evento ( `eventoId` int(5) NOT NULL AUTO_INCREMENT, `eventoNome` varchar(25) NOT NULL, `eventoAparato` varchar(25) NOT NULL, `sexoId` char(1) NOT NULL, PRIMARY KEY (`eventoId`), ) sexo ( `sexoId` char(1) NOT NULL, `sexoNome` varchar(15) NOT NULL, PRIMARY KEY (`sexoId`) ) Juiz ( `juizId` int(5) NOT NULL AUTO_INCREMENT, `jNome` varchar(25) NOT NULL, `jSNome` varchar(25) NOT NULL, `paisId` varchar(5) NOT NULL, PRIMARY KEY (`juizId`), ) Fase ( `faseId` int(5) NOT NULL AUTO_INCREMENT, `faseNome` varchar(25) NOT NULL, PRIMARY KEY (`faseId`) ) Nota ( `notaId` int(3) NOT NULL AUTO_INCREMENT, `nota` int(11) NOT NULL, PRIMARY KEY (`notaId`) ) InfoEvento ( `infoEventoId` int(3) NOT NULL AUTO_INCREMENT, `eventoId` int(5) NOT NULL, `data` date NOT NULL, `hora` time NOT NULL, `atletaId` int(15) NOT NULL, `juizId` int(5) NOT NULL, `faseId` int(5) NOT NULL, `notaId` int(11) NOT NULL, PRIMARY KEY (`infoeventoId`) ) Gostaria de saber como eu faço pra mostar: atletaNome: Joao do Pulo eventoNome: Salto com vara faseNome: SemiFinal data: 23/03/1978 hora: 15:23 juiz1: Maria dos Santos nota: 7 juiz2: Ze Doido nota: 6 juiz3: Joao Loco nota: 4 notaTotal: 17 já tentei de tudo e não consigo... Estou meio no desespero se alguém puder me ajudar... Agradeço desde já!!