29 Jul QUESTIONS ONE [40 MARKS]CASE STUDYGLOBALLY
QUESTIONS ONE [40 MARKS]CASE STUDYGlobally World Vision supporters/Donors currently sponsor 3.4 million children in almost 100 countries with over 54 000 children supported in South Africa. World Vision International (NGO) is running many droughts relieve projects around Limpopo Province. It is holding many conferences in many towns and growth points to all stake holders involved in the projects including its own staff members and volunteers. There is a very big need to capture all the information being gathered in those conferences throughout Limpopo Province. A list below shows some of the important aspects to be compiled.? Every conference has a name and a date that also states the duration after starting.? The stakeholders may attend one or more conferences around the province? For every stakeholder in attendance would supply personal information like name electronic mail and the conferences they wish to attend?? At each conference venue they are a number of workshop rooms depending on the project type each room is of fixed capacity. Meeting rooms are labelled with the floor number and meeting room number? Every workshop needs an allocated meeting room; where a workshop lasts for two days it will use the same room on both days.? Each conference around the province have a specified meeting room if the conference is going to last for 2 days automatically it will use the same meeting room for those 2 days.1.1.1 By using the information above draw an appropriate ER diagram showing this information make sure you show suitable relationships that may exists between stakeholders conferences meeting rooms and dates (10)(ii) After critical analysis of the NGO`s conferences some relevant additions where identified but not all of these can be included easily on a ER diagram.? Every conference must have a project leader among the conference stakeholders? No stakeholder must register more than one conference on the same day.? All stakeholders must register at least one conference compulsory.(a) Among the additions you have identified can you list only 3 of them and explain why you identify them as critical inclusions/additions.1.1.2 In addition for those 3 additions integrate them to the new updated ER diagram separately from part (10)(b) Assume a Database of students information are available. It is required to develop a front end application which will help in? inserting a record ? searching for a record if the registration number is given ? Creating reports containing the name registration number of the students who have got more than 60%.1.1.3 Explain clearly how this application will be developed using Open Database Connectivity ODBC (20)TOTAL: 100 MARKS
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Writedemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.