iPopulation

A few weeks back, a friend of mine came up to me with an idea he had from a relative to build a database from scratch for a small ward (population less than 10 000).
I figured it would be fun making use of my free time to design something small for this guy.
When I started, it is not as small as I thought it was - there is no such thing as a small database.

Part A: Investigation
To be more precise, I needed to gather all the information needed for this database, so I began researching databases on the net that stores citizen population. I started comparing these details to the details needed for a prototype. Here's what I've listed

Name - (First Name, Middle Name, Last Name, Maiden Name*)
Date of Birth
Gender
Marital Status
Address (Postal, Residential)
Contact Details
Employment Details

Part B: Design
The database has to be designed before implementation so we do not have to re-structure once data is entered. Entity Relational Diagrams play an important role in this step. I figured I should put it down on paper first (I may have to scan the original document and upload it here).

Part C: Application Design
I sometimes fast forward to this part, because its the most interesting part. Trial and Error, until it works! That is my style. I started off with the data entry forms - peanuts!, moved onto the display table - all good. Now I can send the link to my friend to get it tested and get feed backs before moving onto the next steps!

By the way, you can give your feedback too!! visit: https://niuginidb.000webhostapp.com 

Popular

PNG Birth & National Identity Registration Form - Electronic Fillable

Image
Sorry guys. I wanted to upload this document here but for some reason I could not. The good news is, I've actually had it uploaded on my other blog site via wix. Here's the link PNG Birth Certificate and National Identity Application Form  I've converted into fillable form - meaning you can use your phone or computer using a pdf reader to actually fill in your details, sign, date and print or email You can share the link with your friends so they can be able to easily fill in the form.
See more »

MY JOURNEY INTO ADULTHOOD - Part 1

Image
It has been a pretty busy time of my life in the past years 2016-2021. I was busy with work, trying to find what works for me in this new life. I've been through so many crossroads and choices that I had to make over these few years outside of my comfy parents laps. Here's a bit of reflection over those years (If I can remember correctly). OCTOBER 2016  After I left university, I decided not to go home, but to pursue employment in PNG's most densely populated city of Port Moresby - the city of the filthy rich, the struggling middle-class, thugs and cultural and societal misfits. For me, it was a place to find a decent job. It wasn't too long before I figured it's not as easy as it was presented to us in the comforts of a lecture room. I bet all under-grads had the same dream as I had, thinking we've made it in life going into a University and it should be all downhill from there, getting a good job owning a house a car. Well that is not the case, as soon as you
See more »

YouTube as a YoutTuber part II

Image
From my last post - I was just starting. I didnt know what to expect from being a beginer, ie 'Brukim bush' as we say in Tok Pisin. Anyways for PNG Fighting Compilation videos obviously cannot work on my channel. I got 2 strikes and have to wait two weeks to upload more videos - sad story for a beginer. Lesson learnt, next time you want to try something new, make sure to ready all the guidlines (Especially Community Guidlines) so you know what you upload does not violate any of them. The idea to criticize memes may not be a good idea since I'd like to build an audience. One thing I found is that, once you know how to post attractive and interesting content, this improves your posts on other social media platforms - so whatever I'm learning from YouTube is excercised on my Facebook Pages and Instagram. Information is key, learn as much as you can so that you can be able to provide to your audience as much information as needed. I've watched a whole lot of v
See more »