Disseny i implementació d'una base de dades relacional per al manteniment d'aparells d'una empresa

Aquest projecte neix de la necessitat de la nostra empresa client de controlar la gestió del manteniment de tots els equips que té instal·lats en 32 centres i del qual s'encarreguen diverses empreses de serveis especialitzades. Així, per una banda, es tracta de fer l'anàlisi i disseny de la base de dades operacional, els scripts de creació necessaris per a crear la base de dades e implementar els procediments mitjançant els quals es gestionarà i accedirà a la informació de la base de dades. I per una altra banda, es tracta de fer l'anàlisi, disseny e implementació d'un magatzem de dades, per tal de poder explotar la informació per a la presa de decisions.

Disseny i implementació d'una base de dades relacional per al manteniment d'aparells d'una empresa

Realización del diseño e implementación de una base de datos relacional que cubra las necesidades del mantenimiento de los equipos instalados en los diferentes centros de una empresa. El acceso a las tablas y datos se ha realizado mediante la creación de procedimientos almacenados.

Disseny i implementació d'una base de dades relacional per al manteniment d'aparells d'una empresa

Una empresa ens contracta ja que té la necessitat de controlar la gestió del manteniment de tots els aparells que té instal·lats en els 32 centres de treball de que disposa (com poden ser extintors, calderes, aire condicionat, fotocopiadores, escàners, impressores, plotters, etc.), i el manteniment el porten a terme diferents empreses de serveis especialitzades. Aquesta gestió i l'accés a tota la informació necessària es realitzarà mitjançant procediments de Base de Dades.La Base de Dades que es crearà ha de ser capaç de portar a terme la gestió de manteniment de tot el maquinari existent en cadascun dels centres de l'empresa, i ha de disposar d'eines que permetin, per una banda, tractar correctament la informació referent als diferents tipus de manteniment (preventiu, correctiu, adaptatiu) que es pot aplicar als diferents equips, i per l'altra, que li permetin incorporar a la Base de Dades aquelles necessites futures, és a dir, que li permetin ser escalable.Aquesta Base de Dades també disposarà de mecanismes que li permetin tractar possibles problemes d'integració amb la resta del sistema, com per exemple, la creació d'un log de les diferents accions fetes amb la Base de Dades, o diferents mecanismes per fer diversos tests de les funcionalitats del sistema.A part de la gestió de manteniment, es disposarà també un magatzem de dades (DataWarehouse) per tal de poder analitzar la informació que conté la Base de Dades anteriorment esmentada, amb l'objectiu d'ajudar a prendre decisions sobre les dades existents en un moment donat.El projecte està dividit en dos blocs principals, on el primer es dissenyarà i s'implementarà una Base de Dades relacional, amb la seva definició de requeriments, l'anàlisi i disseny, desenvolupament de procediments de base de dades i proves per testejar el correcte funcionament, mentre que el segon es dissenyarà i s'implementarà un magatzem de dades (DataWarehouse) per explotar les dades existents en la base de dades relacional.

Get Healthwise this new year!

The Public Health Agency is encouraging people with specific health conditions to join the Healthwise scheme – a free 12 week physical activity programme to get their new year off to a healthy start. The scheme is available at registered leisure centres and Healthy Living Centres (HLCs) within the Belfast and South Eastern Health and Social Care Trust areas and is for people with certain health conditions who have been referred by their GP, nurse or other health professionals. The scheme is suitable for those with: • high blood pressure; • a body mass index (BMI) of more than 25; • asthma or chronic obstructive pulmonary disease (COPD); • diabetes; • osteoporosis; • hypertension; • coronary heart disease and associated risk factors; • anxiety; • stress; • depression.

PHA supports World No Tobacco Day

The Public Health Agency is taking the opportunity to highlight this year's World No Tobacco Day which takes place on Tuesday 31 May.In Northern Ireland, around 340,000 people aged 16 and over smoke. Smoking contributes not only to many cancers, heart disease, bronchitis and asthma, but to other illnesses, including stroke. In fact, smoking causes around 2,700 deaths per year here, all of them avoidable.The PHA is committed to saving lives by reducing the percentage of people who smoke. The PHA:works with councils to ensure smoking-related laws are enforced; funds a range of support to smokers who want to quit; educates young people to not start smoking, through programmes like 'Teenage Kicks' and 'Smokebusters'. In January this year, the PHA also launched its smoking campaign 'Things to do before you die' to encourage smokers, particularly those aged 20-49, to stop smoking.Health Minister Edwin Poots said:"Smoking is the greatest cause of preventable illness and premature death in Northern Ireland. While good progress has been made in the last number of years to reduce the number of people who smoke, more needs to be done."I would appeal to all smokers to use the wide range of support services available to make every effort to stop smoking - it is the single best step you can take to improve your health and quality of life."Mark Mc Bride, Health Improvement Manager, PHA, said "Smoking is the single greatest preventable cause of death in the world today. Across Northern Ireland there are over 600 support services for people who wish to stop smoking. These are based in GP surgeries, community pharmacies, hospitals, community centres and workplaces."From April 2010 to end March 2011 more than 1 in 10 of all adult smokers sought help from the support services and approximately half had quit after four weeks. This is a substantial - roughly 50% increase - on previous years and shows the benefit of the PHA campaigns and the dedication of the many specialists who help smokers quit."I would encourage everyone who is either thinking about quitting or ready to log on to our Want 2 Stop website www.want2stop.info or to contacting the Smokers' Helpline on 0808 812 8008 a Quit Kit free of charge."

For your heart's sake stop smoking

On World Heart Day, 29 September 2011, the Public Health Agency is urging all smokers to stop smoking and reduce their risk of developing heart disease (cardiovascular disease - CVD) or suffering a stroke or a heart attack.Heart disease is one of the leading causes of death and illness in the UK. Research shows that smoking is one of the main contributors of the disease, causing around 25,000 deaths a year in the UK. Cigarette smokers are two times more likely than non-smokers to suffer a heart attack.The majority of people who suffer a heart attack before the age of 50 are smokers. Cigarette smoke causes heart disease by:· reducing oxygen to the heart;· increasing blood pressure and heart rate;· increasing blood clotting;· damaging cells that line coronary arteries and other blood vessels, causing narrowing of the arteries.From the moment smoke reaches your lungs, your heart is forced to work harder. Your pulse quickens, forcing your heart to beat an extra 10 to 25 times per minute, as many as 36,000 additional times per day. Because of the irritating effect of nicotine and other components of tobacco smoke, your heartbeat is more likely to be irregular. This can contribute to cardiac arrhythmia and many other serious coronary conditions, such as heart attack.For smokers who already suffer from heart problems, quitting will dramatically help. Many heart patients notice an almost immediate improvement when they stop smoking. Often, they need less medication and can cope better with physical exertion.Gerry Bleakney, Head of Health and Social Wellbeing Improvement, PHA, said: "Smoking is one of the major causes of cardiovascular disease and smokers are almost twice as likely to have a heart attackas someone who has never smoked. One in every two long-term smokers will die prematurely from smoking-related diseases, many suffer very poor health before they die. However one year after successfully quitting smoking, an individual will have reduced their risk of having a heart attack to half that of a person continuing to smoke."Across Northern Ireland, there are over 600 support services for people who wish to stop smoking, based in GP surgeries, community pharmacies, hospitals, community centres and workplaces. I would encourage everyone who is thinking about quitting to log on to our Want 2 Stop website: www.want2stop.info and order a 'Quit Kit' free of charge alternatively contact the Smokers' Helpline on 0808 812 8008."

Smoking causes mouth cancer, PHA warns

Mouth cancer awareness week begins on the 13 - 20 November. With this in mind the Public Health Agency is urging everyone to be aware of the signs and symptoms of mouth cancer and is encouraging all smokers thinking about stopping smoking to make the decision to stop today.In Northern Ireland 195 people were diagnosed with mouth cancer in 2009. The disease causes one death every five hours in the UK and yet it is one of the least well-known cancers. Smoking and excess alcohol consumption is associated with an increased risk of developing mouth cancer, which can occur in or on any part of the mouth, tongue, lips, neck and throat. In its very early stages, mouth cancer can be easy to ignore. Most people with mouth cancer have no early symptoms at all, but others may have:an ulcer in the mouth or on the lip that won't heal; constant pain or soreness; red or white patches in the mouth;a lump on the lip, tongue or in the neck; bad breath; unexplained bleeding in the mouth; numbness in the mouth; loose teeth.The earlier the disease is caught, the better. Survival rates rise to 90 per cent if the cancer is treated before it has spread. Gerry Bleakney, Head of Health and Social Wellbeing Improvement, PHA, said: "Certain lifestyle choices can increase an individual's risk of developing mouth cancer. Tobacco is considered to be the main cause of mouth cancer, with three in four cases being linked to smoking. Excess alcohol consumption is also a known factor, with those who both smoke and drink excessively being up 30 times more likely to be at risk. "Mouth cancer and the treatment required can be traumatic for the patient as this may affect functions such as speech, chewing and swallowing. The positive news is that stopping smoking is associated with a rapid reduction in the risk of oral cancers. Regular trips to the dentist are also a must because half of all mouth cancer cases are detected by dentists."I would encourage everyone who is thinking about quitting to log on to our Want 2 Stop website www.want2stop.info and order a 'Quit Kit' free of charge. Alternatively contact the Smokers' Helpline on 0808 812 8008. "Health Minister Edwin Poots said: "Smoking is the single greatest cause of preventable illness and premature death in Northern Ireland.It is a major risk factor for oral cancer, as well as coronary heart disease, strokes and other diseases of the circulatory system. Approximately 2,300 people die each year in Northern Ireland from smoking related illnesses. Quitting smoking is the single most effective step people can take to improve their long term health."A key objective of the Department's new ten-year tobacco control strategy, due to be published next month,is to prevent people from starting to smoke. Funding provided by the Department for smoking cessation services has resulted in around 650 such services being made available in Northern Ireland in a range of settings, including pharmacies, GP surgeries and community centres. These services have helped almost 80,000 smokers to set a quit date between 2008/09 and 2010/11."The Minister added: "It is also important for people to look after their oral health by regularly attending the dentist for check-ups, as any problems can be picked up and treated at an early stage."

Reducing unintentional injuries in and around the home among children under 5 Years

Public Health England today launches 2 new resources for local authorities on preventing accidents to children and young people in the home and on the road. The reports show whilst the number of children and young people killed or seriously injured continues to fall in England there are still significant numbers of deaths and emergency admissions from preventable causes. On average each year between 2008 to 2012, 525 children and young people under 25 died and there were more than 53,700 admissions to hospital. The reports highlight actions local partners can take to reduce accidents including improving safety for children travelling to and from school and using existing services like health visitors and children’s centres. The Reducing unintentional injuries in and around the home among children under 5 Years and the Reducing unintentional injuries on the roads among children and young people under 25 reports include an analysis of data between 2008 to 2012. Key findings from the reports include: home injuries (under 5 years of age): an average of 62 children died each year between 2008 and 2012 these injuries result in an estimated 40,000 emergency hospital admissions among children of this age each year 5 injury types should be prioritised for the under-fives: choking; suffocation and strangulation; falls; poisoning; burns and scalds; and drowning hospital admission rate for unintentional injuries among the under-fives is 45% higher for children from the most deprived areas compared with children from the least deprived Road traffic injuries (under 25 years of age) there were 2,316 deaths recorded by the police among road users under the age of 25 years, an average of 463 under 25s each year there were 68,657 admissions to hospital as a result of road traffic injuries, an average of 13,731 each year in total there were 322,613 casualties of all severities recorded by the police, an average of 64,523 each year the rate of fatal and serious injuries for 10to 14 year olds was significantly greater for children from the 20% most deprived areas (37 per 100,000) compared with those from the most affluent areas (10 per 100,000)

Reducing unintentional injuries on the roads among children and young people under 25

Public Health England today launches 2 new resources for local authorities on preventing accidents to children and young people in the home and on the road. The reports show whilst the number of children and young people killed or seriously injured continues to fall in England there are still significant numbers of deaths and emergency admissions from preventable causes. On average each year between 2008 to 2012, 525 children and young people under 25 died and there were more than 53,700 admissions to hospital. The reports highlight actions local partners can take to reduce accidents including improving safety for children travelling to and from school and using existing services like health visitors and children’s centres. The Reducing unintentional injuries in and around the home among children under 5 Years and the Reducing unintentional injuries on the roads among children and young people under 25 reports include an analysis of data between 2008 to 2012. Key findings from the reports include: home injuries (under 5 years of age): an average of 62 children died each year between 2008 and 2012 these injuries result in an estimated 40,000 emergency hospital admissions among children of this age each year 5 injury types should be prioritised for the under-fives: choking; suffocation and strangulation; falls; poisoning; burns and scalds; and drowning hospital admission rate for unintentional injuries among the under-fives is 45% higher for children from the most deprived areas compared with children from the least deprived Road traffic injuries (under 25 years of age) there were 2,316 deaths recorded by the police among road users under the age of 25 years, an average of 463 under 25s each year there were 68,657 admissions to hospital as a result of road traffic injuries, an average of 13,731 each year in total there were 322,613 casualties of all severities recorded by the police, an average of 64,523 each year the rate of fatal and serious injuries for 10to 14 year olds was significantly greater for children from the 20% most deprived areas (37 per 100,000) compared with those from the most affluent areas (10 per 100,000)

Aplicación de representación de datos

Trabajo del área de Sistemas de Información Geográfica (SIG) en el cual, mediante la importación de datos procedentes de un archivo .xls, se crean gráficos estadísticos geolocalizados en centros geográficos de elementos de la leyenda de un GeoWorkspace de GeoMedia Professional 6.1.

AAA screening programme flyer

This flyer has been produced to help maximise awareness of the abdominal aortic aneurysm (AAA) screening programme in Northern Ireland. It provides important information on AAAs, the danger they pose to the health of men aged 65 and over, and the screening process. The flyers will be distributed to eligible men through the following channels, among others: public events, eg talks with men's groups, Farm Families Health Checks programme;health information stands in shopping centres, supermarkets etc;GP practices;pharmacies.

Estudi i millora del sistema d'administració i gestió acadèmica SAGA

Els centres d'ensenyament secundari que depenen del Departament d'Ensenyament, ja siguin públics o concertats, disposen d'un aplicatiu comú d'administració i gestió acadèmica anomenat SAGA. Actualment aquest sistema és d¿ús únicament de gestió, estant tancat a qualsevol interacció per part de membres de la comunitat educativa que no sigui direcció, professorat o personal d'administració. La intenció d'aquest treball és detectar mancances i/o deficiències del sistema existent, corregint-lo i obrint-lo a la resta de comunitat educativa, concretament als pares o tutors legals dels alumnes del centre. La intenció d'aquest treball és facilitar aquesta interacció tant de les persones que actualment treballen ja amb aquest sistema com de les susceptibles de poder-hi treballar en un futur.

REACH - Rethinking Eating and Activity for Children's Health

The aims of the REACH programme were to: - Provide a quality whole-family healthy lifestyle programme that is accessible and equitable to support children aged 4-7 and 8-11years who are above the healthy weight range in maintaining or achieving a healthy weight; - Target areas of poor health and high prevalence of childhood obesity; Contribute towards the prevention and reduction of obesity prevalence in South Gloucestershire; - Be a resource for other health professionals and services in South Gloucestershire. As this was a pilot of a child weight management programme being developed from scratch the objectives of REACH were to: Provide a high quality service which meets the needs of the local health community; - Improve childrens diet and nutritional intake and promote a healthy weight; Encourage exercise and physical activity participation; - Develop a range of skills with participants in order to increase their confidence and self esteem; - Be participant centred but also use a whole family approach to deliver healthy lifestyle messages; - Develop appropriate referral protocols, resources and course plans; - Advertise and promote the programme locally liaising with communications and the Public Health Team in NHS South Gloucestershire, GPs and staff working in the community such as School Health Nurses (SHNs); - Successfully recruit families on to the programme; Enable eligible new participants referred to the service to take part; - Encourage participants to complete the programme; - Deliver a service that helps to address health inequalities; - Monitor participants weight and lifestyle changes as part of a follow up programme; - Provide continuous professional development of service staff; - Ensure individuals and families are signposted and supported to access other services such as after school clubs, local sports clubs and leisure centres; - Provide equitable access to the service and ensure equitable outcomes are achieved by the service; Ensure continuous quality improvement;

A Cannabis Reader: Global Issues and Local Experiences

The EMCDDA’s cannabis monograph addresses one basic question. How can I find quality information on cannabis, amid all the bias and opinion? The monograph is divided into two volumes. The first volume centres on political, legislative, commercial and social developments relating to cannabis. Its core audience thus comprises policymakers, sociologists, historians, journalists and those involved in enforcement. The second volume is targeted at drugs professionals working in the fields of treatment, prevention and healthcare.This resource was contributed by The National Documentation Centre on Drug Use.

A Study on the Feasibility of the Inclusion of General Practitioners and Prisons in the National Drug Treatment Reporting System: Plan for the Implementation of the NDTRS in Prison and GP Services

The Drug Misuse Research Division of the Health Research Board operates the National Drug Treatment Reporting System (NDTRS). The system is used to provide epidemiological information on treated problem drug misuse in Ireland and informs policy makers, researchers and the general public. The NDTRS collates data from participating treatment centres in all Health Board areas, however a gap in information exists in that drug misusers in treatment units within prisons and those treated by General Practitioners are not included. This study aims to determine the feasibility of including these two groups to increase coverage of the NDTRS and outlines preliminary steps for their inclusion.This resource was contributed by The National Documentation Centre on Drug Use.