Produce a database of England Constituencies and the 2024 election results. Data will be supplied but need parsing. Need to be able to add and assign people to each constituency to manage.
1. User-id/password with captcha 2. Two user types – admin is full access and user is view only 3. Data supplied but will need parsing 4. Additional fields required for database: 4.1. Each constituency can have multiple people assigned known as Constituency Managers. 4.2. Each Constituency Manager can have multiple people assigned known as Helpers 5. Data fields for the Constituency Manager and Helpers are: 5.1. First name 5.2. Last name 5.3. Hometown 5.4. Email address 5.5. Mobile (Optional) 5.6. Origin (refers to how they were recruited: 5.6.1. Facebook 5.6.2. Instagram 5.6.3. Linkedn 5.6.4. Direct 5.6.5. Other – please specify 5.6.5.1. Free format field of 100 characters for explanation 6. All fields should be able to be added, amended or deleted 7. Reports 7.1. List of Constituencies (facility to sort by fields) 7.2. List of Constituency Managers 7.3. Summary of Constituencies with a Constituency Manager assigned including total percentage i.e. how many constituencies have a Constituency Manager 7.4. List of unassigned Constituency Managers 7.5. List of assigned Consistency Manager with Helpers 7.6. List of assigned Consistency Managers without Helpers
