Hello. So lists lists now start developing school application. The first system for developing a native application is creating the database. So the first thing we will do now is we'll create a database user and we will create the tables. After that we will go and create ADF application. So now I will go to the database, I will connect to the SIS, my sis user then I will create now database user I will say create user school ID to identify it by score.
Now I will create a user called school and depending on the database type this is Oracle database. So we can create a user like this. Now, user is created then I will grant good Nick resource to school. Now grant so now little disconnect from the system and create a new connection school username is school also school this should get it success. Okay. So now we have the School of course there is no tables at all it is just empty empty user.
So let's now create the system tables here a forms attachment you will find here school application You will find database DB script you can copy script and was it here and let's run the script here we create the database tables okay this now refresh and see the tables which is created. As you can see now I create a table called teachers has teacher ID to name, phone address, date of birth and gender I have table for students student ID name gender added to the birth birth name, parent email, parent phone and I create classrooms just through number and Zachary ID number two cruises room for which great then I create a student class which will which we will know from which class the student will be this is a relation between the student and classroom. And we have a teacher classes. This is a relationship between the teacher and the class room as well.
Here is the school information which will give me the school name, address, email, phone, fax, as this is a principal name, Principal username and password. This is the username and password which we will use to log into the system. Of course, you can have your own user table with username and password. But for this small application I just create one username and password is a table called school information. So as a principal only as a user who will able to log into the system and You will assign with a student to the classroom teacher to the class and he can see the student result the year and secret number and final results. So, here he is a principal can seize all information and the secret is that to the scoring, this is just a simple application.
And from this application, I will show you how you can develop a complete diff application I will use maybe some you will see some things new identic sibling during the course you will see it from here. From this publication, I will create a custom we will use a custom security. I didn't experience the custom security but I will explain it here and our application. Custom security will make you able to deploy your application in open source glassfish No need to deploy it in our project because we will As you can be plication server. So okay after we've created the table this is the first step for creating any identification. You should have your database ready.
Okay. After that we will go and start developing our ADF application. So see you next video