Hello. So now, we almost finished all transaction screen search and lookups. So, in this video, I will start talking about the dashboard, and how you can query the dashboard for your application. In this dashboard, I will show you how you can use a data visualization component it is data visualization component, we will create some graphs like bar graph, by graph line graph, we'll go to so I will cover four types of graphs and we will display some statistics. I will show you how we can design the page it will be something like this. You will find here once a user log in and see the dashboard, you will find here four graphs and here's some statistics likes account, number of classroom number of teacher number of students, and so on.
So, this is how our dashboard We'll looks like so behind each of these graphs, it will be like a database query, select the query, we will write this query and the same statistics, we need query for each statistics. So, actually, I have created this query, I will show it to you. And this query is attached to the this application as well, you can download from the application source. So let's now go through and see how what is the query which I wrote for each graph and all the statistics. Okay, so this is a query which I wrote to get the statistics and the graph. So this is we'll get, we'll get the old counts in the left hand side the statistics on the left hand side.
Here, for example, I need to get the whole count to the teacher in the system, or the count to the student. Count of classroom number. Oh, classroom in grade one grade 23456 the number of students who passed last year number of students who failed last year. This is the left hand side the statistics part for each graph here we have four graph Ricci graph has its own SELECT statement. So here the first graph will display number of students in the class. Here is number of the teacher for the class here like a go to give the average of the students who bust last year who success or in last year and a cigarette for number of the student for each grade grade one grade two grade three.
So this is the whole SELECT statements for all dashboard. To make this select the statement return some result and see some data I entered or inserted some data into the system. As you can see here, classroom I add some data in the classroom, teachers, students, I had some students like this a same class teacher, I assigned some class to some teachers. So I insert some data here so that I can see some data in the graphs. Okay, so now we add some data in the system, we now generated code SELECT statements. So now let's move on and start for developing the sport.
So see you next tivity