WEBVTT 1 00:00:01.040 --> 00:00:02.510 Hi guys and welcome back. 2 00:00:02.510 --> 00:00:05.020 In this video, we're gonna look at a project overview 3 00:00:05.020 --> 00:00:08.810 for the polling app we're gonna be building in this section. 4 00:00:08.810 --> 00:00:10.100 Here are the project features. 5 00:00:10.100 --> 00:00:12.600 Users are gonna be able to create polls, 6 00:00:12.600 --> 00:00:15.790 view them and vote on them, and also check the votes 7 00:00:15.790 --> 00:00:18.610 on a poll, who voted for what as a total 8 00:00:18.610 --> 00:00:21.610 and as a percentage, and also pick a random person 9 00:00:21.610 --> 00:00:23.110 who voted on the correct answer. 10 00:00:23.110 --> 00:00:24.520 For example, if we had giveaways 11 00:00:24.520 --> 00:00:27.030 and things like that, this would help with that. 12 00:00:27.030 --> 00:00:28.900 The user interface is gonna look something like this. 13 00:00:28.900 --> 00:00:29.970 This is the menu. 14 00:00:29.970 --> 00:00:31.570 We have here different options 15 00:00:31.570 --> 00:00:33.470 to create lists and vote on polls, 16 00:00:33.470 --> 00:00:36.360 show the poll votes, and select a random winner. 17 00:00:36.360 --> 00:00:38.430 And then if we enter one, we're gonna ask them 18 00:00:38.430 --> 00:00:41.900 for a poll title and the poll owner 19 00:00:41.900 --> 00:00:44.000 and that's gonna create the poll, 20 00:00:44.000 --> 00:00:46.900 and then attached to the poll there are gonna be options, 21 00:00:46.900 --> 00:00:48.500 and here they've entered three options, 22 00:00:48.500 --> 00:00:50.450 JavaScript, Python, and Swift. 23 00:00:50.450 --> 00:00:52.400 Polls and options are gonna go in different tables 24 00:00:52.400 --> 00:00:55.800 as you'll see but we're gonna talk more about that later on. 25 00:00:55.800 --> 00:00:57.910 If we enter two, we'll show them the polls 26 00:00:57.910 --> 00:00:59.720 that are currently available and there, 27 00:00:59.720 --> 00:01:01.790 in this case, is just one of them. 28 00:01:01.790 --> 00:01:05.370 Notice that the one on the left is the poll ID 29 00:01:05.370 --> 00:01:08.010 so we're gonna use that when they want to vote on polls. 30 00:01:08.010 --> 00:01:10.390 Here they've entered three and then we ask them 31 00:01:10.390 --> 00:01:11.870 for the poll they'd like to vote on. 32 00:01:11.870 --> 00:01:14.040 They type one which was the poll ID. 33 00:01:14.040 --> 00:01:17.280 We show them the options and then they vote on one of them. 34 00:01:17.280 --> 00:01:19.340 We also get the username they'd like to vote as 35 00:01:19.340 --> 00:01:22.970 so that different people can't vote twice. 36 00:01:22.970 --> 00:01:26.210 Now we're not going to have users in this application, 37 00:01:26.210 --> 00:01:30.020 like login, logout, et cetera, but you can imagine that 38 00:01:30.020 --> 00:01:32.290 if we had that, which is a specific thing 39 00:01:32.290 --> 00:01:33.620 that we're not gonna cover in this course, 40 00:01:33.620 --> 00:01:35.780 but if we had login and logout, 41 00:01:35.780 --> 00:01:38.630 this would be the replacement for that. 42 00:01:38.630 --> 00:01:41.100 If they enter four, we're gonna show them the votes. 43 00:01:41.100 --> 00:01:44.290 Here, for example, Python got one vote 44 00:01:44.290 --> 00:01:46.830 and that's 100% of the votes. 45 00:01:46.830 --> 00:01:49.630 If they enter five then we ask them for the poll 46 00:01:49.630 --> 00:01:51.140 that they want to pick a winner for, 47 00:01:51.140 --> 00:01:54.470 in this case it's poll with ID one, then we'll ask 48 00:01:54.470 --> 00:01:58.190 what the winning option is, in this case it's two, 49 00:01:58.190 --> 00:02:00.420 and the programme will select a random winner. 50 00:02:00.420 --> 00:02:01.620 We're going to use a database 51 00:02:01.620 --> 00:02:04.303 to find the random winner in this case. 52 00:02:05.460 --> 00:02:06.293 That's about it. 53 00:02:06.293 --> 00:02:07.430 If they enter six, they exit. 54 00:02:07.430 --> 00:02:09.550 So, running this app on your own, 55 00:02:09.550 --> 00:02:12.020 in your own computer, with no more users, 56 00:02:12.020 --> 00:02:13.650 is not gonna be terribly useful, 57 00:02:13.650 --> 00:02:16.540 but if we allowed people to vote through internet, 58 00:02:16.540 --> 00:02:18.340 then it might become a bit more useful. 59 00:02:18.340 --> 00:02:22.240 Of course in order to do this, we also need a user account, 60 00:02:22.240 --> 00:02:25.120 login, logout, et cetera, but we've got some videos 61 00:02:25.120 --> 00:02:27.699 on our YouTube channel on how to turn this app 62 00:02:27.699 --> 00:02:30.170 into something you can vote on online 63 00:02:30.170 --> 00:02:33.300 by using a web library as well. 64 00:02:33.300 --> 00:02:35.120 And so once we finish with this section, 65 00:02:35.120 --> 00:02:37.820 you're gonna understand all of the database aspects 66 00:02:37.820 --> 00:02:40.370 of the application and you could potentially go 67 00:02:40.370 --> 00:02:42.000 and watch this if you want to learn more 68 00:02:42.000 --> 00:02:44.610 about web development and how to turn this app 69 00:02:44.610 --> 00:02:46.760 into a website that you can vote in. 70 00:02:46.760 --> 00:02:48.810 But in this section we're gonna cover all 71 00:02:48.810 --> 00:02:51.090 of the database aspects of how to do everything 72 00:02:51.090 --> 00:02:53.629 this app needs using the database, so that includes 73 00:02:53.629 --> 00:02:57.000 all the data, the relational tables and stuff like that. 74 00:02:57.000 --> 00:02:59.240 We're gonna look at selecting random people, 75 00:02:59.240 --> 00:03:01.940 calculating percentages, and much more. 76 00:03:01.940 --> 00:03:03.680 So thank you guys for watching this video. 77 00:03:03.680 --> 00:03:05.313 I'll see you in the next one.