School Electoral System (1 Viewer)

Toffee

New member
Local time
Today, 02:35
Joined
Jun 15, 2019
Messages
3
Hy guys,
Please help.
Q.1 Is it possible to develop a voting system using database?
Q.2 How does one create a table field that automatically generates values from another table when a field in the current table is similar to one in the other table?
Lemme explain. Example: Table 1 has two fields; Position, and, Contestant name. Then Table 2 has the same fields. So i want to be able to generate a lookup for Contestant names(those that have the same position) automatically in table 2 whenever i insert the position name in table 2. So the two tables relate but i don't know how to automate the search in table 2. Table 1 is filled manually.
Hope you understand my problem and can help ASAP.:confused::eek:
 

Toffee

New member
Local time
Today, 02:35
Joined
Jun 15, 2019
Messages
3
Hy guys,
Please help.

Instructions to Candidates

1. Use a Database Management System when developing the project.

2. A softcopy of the work must be stored in a removable storage medium.

3. Name and index must appear on the cover page of your documentation.







REHEMA SCHOOL PREFECTS ELECTORAL SYSTEM

Rehema school is a day secondary school with 5 streams each in form one, form 2, form 3 and 4. The students’ administrative structure is in 3 levels; school level, form level and class level. The school level students’ leadership positions comprise of the head boy, head girl, D.H captain, games captain and library captain. The form level positions comprise of form captains who are in charge of all the streams in their respective forms. The class level positions comprise of the class prefects who are in charge of their respective classes and are answerable to their respective form captains. All the positions are elective and the holders serve for a one-year term.

The school elections are held at the beginning of each year. Only form 3 students are eligible for school level positions. The school level prefects are elected by all the students in the school. A form level captain is elected by all the students in the streams in his/her own form. A class prefect is elected by members of his/her own class.

Those students who intend to vie for the positions are required to be vetted by the school administration. The successful candidates are required to provide their personal details which would be used in the ballot papers. The school level and form level contestants are vetted by the school administration, while the class level contestants are vetted by their respective class teachers. One of the requirements in the vetting is that each contestant must have been proposed and seconded by their electorate. Those seeking school level positions are required to be seconded by a student from each class in their respective forms. Those seeking class level positions are required to be seconded by two students from their respective classes.

Elections are carried out in every classroom concurrently, where the respective class teacher presides over the exercise. On the day of the election, the class teachers collect ballot papers for each of the elective positions for their respective classes. During the polling, students are required to indicate their preference in the ballot papers by placing a tick ( ) alongside the candidate of their choice and inserting the ballot papers in their respective ballot boxes.

Counting of votes is carried out in their respective classes and the results are recorded, announced and taken to the tallying centre. At the tallying centre, the form level and school level vote results from the classes are combined and the total votes for each candidate recorded. The candidate with the highest number of votes for each post is registered as the winner. The results of the election are forwarded to the school’s principal who then approves and announces the final results.



Develop a well-documented computerized prefects election system that will

a) Maintain:

i. Records of classes and their respective class teachers;

ii. List of contestants for each post;

iii. List of electoral positions;

iv. List of students per class;

v. List of proposers and seconders;

vi. Results for each level.

b) Compute:

i. Total votes for each contestant at:

· School level

· Form level

ii. The winner for each post;

iii. Determine the contestants with adequate proposers and seconders.

c) Generate the following reports:

i. Voters list;

ii. List of contestants for each post;

iii. List of class teachers;

iv. List of winners for each post;

v. List of spoilt votes from each class;

vi. List of contestants and the votes garnered.
 

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 17:35
Joined
Oct 29, 2018
Messages
21,358
Hi. Welcome to the forum. Typically, we recommend not storing the same/duplication information in more than one table.
 

jdraw

Super Moderator
Staff member
Local time
Yesterday, 20:35
Joined
Jan 23, 2006
Messages
15,364
Threads merged --same topic, same poster, with responses.
 

Users who are viewing this thread

Top Bottom