Instructor: Hi guys and welcome back.
In this video, we're gonna look at a project overview
for the polling app we're gonna be building in this section.
Here are the project features.
Users are gonna be able to create polls,
view them and vote on them, and also check the votes
on a poll, who voted for what as a total
and as a percentage, and also pick a random person
who voted on the correct answer.
For example, if we had giveaways
and things like that, this would help with that.
The user interface is gonna look something like this.
This is the menu.
We have here different options
to create lists and vote on polls,
show the poll votes, and select a random winner.
And then if we enter one, we're gonna ask them
for a poll title and the poll owner
and that's gonna create the poll,
and then attached to the poll there are gonna be options,
and here they've entered three options,
JavaScript, Python, and Swift.
Polls and options are gonna go in different tables
as you'll see but we're gonna talk more about that later on.
If we enter two, we'll show them the polls
that are currently available and there,
in this case, is just one of them.
Notice that the one on the left is the poll ID
so we're gonna use that when they want to vote on polls.
Here they've entered three and then we ask them
for the poll they'd like to vote on.
They type one which was the poll ID.
We show them the options and then they vote on one of them.
We also get the username they'd like to vote as
so that different people can't vote twice.
Now we're not going to have users in this application,
like login, logout, et cetera, but you can imagine that
if we had that, which is a specific thing
that we're not gonna cover in this course,
but if we had login and logout,
this would be the replacement for that.
If they enter four, we're gonna show them the votes.
Here, for example, Python got one vote
and that's 100% of the votes.
If they enter five then we ask them for the poll
that they want to pick a winner for,
in this case it's poll with ID one, then we'll ask
what the winning option is, in this case it's two,
and the programme will select a random winner.
We're going to use a database
to find the random winner in this case.
That's about it.
If they enter six, they exit.
So, running this app on your own,
in your own computer, with no more users,
is not gonna be terribly useful,
but if we allowed people to vote through internet,
then it might become a bit more useful.
Of course in order to do this, we also need a user account,
login, logout, et cetera, but we've got some videos
on our YouTube channel on how to turn this app
into something you can vote on online
by using a web library as well.
And so once we finish with this section,
you're gonna understand all of the database aspects
of the application and you could potentially go
and watch this if you want to learn more
about web development and how to turn this app
into a website that you can vote in.
But in this section we're gonna cover all
of the database aspects of how to do everything
this app needs using the database, so that includes
all the data, the relational tables and stuff like that.
We're gonna look at selecting random people,
calculating percentages, and much more.
So thank you guys for watching this video.
I'll see you in the next one.