 In college what happens is we work on our interest, if we are interested in that subject we do the project very well, if we are not interested in doing something we leave it, same thing is with studies you know if I do not like the topic I leave it, but here for next 8 weeks you do not have a choice, whatever you do you have to do with full completeness wrong word full completeness basically it should be complete. So this is one thing which will happen for example say I am taking one example very simple example that suppose you are creating a page ok let me I want to know how many students are third year and how many are second year, so second year please raise your hats basically 50-50 I can say that easily as of now, so what happens is I do not know whether you have built any page for example let us look at a page and a field x field called name, so what happens when you take a field or when you do a program say factorial yes 101 or introduction to programming all of you have done, so one of the programs that we normally do is factorial right, so what we do we know the formula n factorial is equal to n cross n minus 1 right, if you are doing recursion otherwise you write a follow is it correct, this is how you do now when you do a program for a real time when the users on the internet are going to use or when you are making the same program for a product and what all things you need to check, can you just think about it what will be the difference, so yes it should not be non negative it should not be negative if I put 4.2 will it be fine, it should not be negative it should not be floating point or it should not cross integer limits and it should not be a character also, so input validation, so when you want to write a program which is for a general user two things are very important one are that any kind of input that comes from the user it should not go into a error like the page should not be blank, there should be a graceful termination of the program, second thing is that whatever input is taken from the user you validate each kind of units inputs available and then accept only the correct input and if the input is wrong a valid error message is required so very important thing is whatever input you take from the user validations number two if graceful execution graceful end of the program gracefully it should error out, now this is from there second thing is if I put 578 as a input what will happen somebody else who want to answer, so we need to also verify in our processing that whatever is the limitation of our processor that should be taken care of, are you all with me on that and then the output I cannot just print the number I have to write the entire message correct, now you can understand how much difference it is from this program which was written in CS101 and which you may have to write over here, can you all make it out, can you see the difference, so if it takes two hours to write in CS101 it may take eight hours to write over here there is another thing very important that here we have three kinds of servers one is a development server which probably may be your machine where you actually develop the code, once you develop your piece of code it will go to a test server in the test server one thing is interesting you cannot make changes to the code, so your code will be tested, now I think everybody has come is there someone who is left alone or can we say 90 percent of the people have come, so let me introduce myself my name is Shweta Tharani and I will be today covering my SQL with you folks, about me basically I run over here the blended MOOCs software and the blended MOOCs software lead and also IIT Bombay's MIS system lead and I have a small team of five members in which we take care whatever is required to run blended MOOCs and also whatever IIT Bombay's faculty wants any kind of information we collect that information and provide it, so it is an online system available, I think yesterday if you would have attended Avinash Sirs presentation and Mahendra's presentation you know some things about blended MOOCs and how many of you have participated in blended MOOCs program by any chance are there anyone who have participated last year in blended MOOCs program? No? Okay, probably next year this was about coding so probably I will take another five minutes of yours to talk about what kind of work, so this was all about coding and testing, so once the test server everything is fine then it goes to production, you do not even have a right probably you may not even have a right to enter the values in production because production users will be different right, so what I want to say is that the quality of the code has to be so good that when it goes to production it works fine, have you ever seen Facebook just crashing down like this even if it crashes then you get a message proper message that probably try it again or something is not working, so this is the kind of code that we expect you to write, coming to the design part, now you have to design the system in such a way that it is extendable and probably you may be writing a part of the system so you have to also take care of the integration with the other person with whom you are doing, so when you design your code you have to be careful about it, for example validations now when he said non-negative number not allowed right, so he probably may write a function everybody understands function right CS101, those who have come new and are wondering what we are discussing is we were discussing a small factorial program how it works, the issue is that there is a technical glitch so I thought we will discuss few things and then we will start with the MySQL, so what we were saying is that for a factorial you cannot have non-negative number, so a validation is required, so design issue could be write a function for validation and if your partner is also using the same function then you can always refer him saying use this function, so you have that validation function should be in library are you getting it, so this becomes very interesting till now when you used to do any project in pairs what you used to do you are my friend you finish the project we both will give the Viva correct, now here since you are working in an industry kind of environment everybody will be assigned some task he has to complete that task and if you start doing other person your friends task then you are nowhere already you are working 9-10 hours a day 10-10-20 non-sustainable it is very difficult people can do that some people are fast some people are slow but still I feel that it is bit difficult so you have to take care of your friends, so it is a very interesting thing it is not only learning at the point of view of what coding you will do definitely will improve in that but this is another thing which you have to take care third is the requirements part for example I will give you one example lot of projects yesterday did you attend all the projects that we did do you know everything is coming from most of them are from government of India correct so and there is something called RTI write to information, so one of the interesting things that is there in our project is we cannot delete any information because today if I delete for example let us look at T10KT training program okay your teacher registers and then finally what happens is that your teacher says no I will not do it so he will cancel the test okay so I have a software where it gets cancelled I cannot delete that name because tomorrow if there were 10,000 teachers and at the end we teach around say 9,980 teachers and ministry asked why were 20 teachers not taught so we have a cancellation of these list and the cancellation reasons along with it that because of these reasons these teachers were not taught it could be family emergency it could be some work in the college anything is possible right now in your case also you may realize that some of your friends may have wanted to join some program or some other place and they were not able to join because of some family issue sometimes some personal issue or they got a better opportunity etc is it possible it is possible right so these are the few things in the requirements which will be interest you so now give me five minutes I will set the things meanwhile I would request few of you were third year students and you have studied database very few third year students here okay how many are electronic and communication students okay so you do you know data structures have you done data structures course not extensively but you have some idea okay I was just thinking okay so for the benefit of food doesn't know database can someone explain databases to them good morning all this is Satirani and database is collection of data database is used to store data whatever the data is like social websites etc there must be a repository to store that now that's why database are used to store data and more or that there are many database are there like relational databases etc we can give queries to databases to retrieve data usually database are used to store data at the same time they try the data you can perform many operations on that that's it thank you in a crux says that any application on website which you have used or any application in your college which you have used needs a place to store data in a computer data is stored normally how they are stored hard disk hard disk how does it store files agreed now earlier all the data was stored in files so every file will have a file format etc slowly as it progressed there was a software which hide that information how to store it in the file and what happened is that data there was a management system created in which hide this information how the data is stored in files and users found it much easier to use it and that was a kind of database management system so that was database management system in terms of file management system is bit different you know it is more to do with blocks etc database management system is that you give the data in a particular format it may store in the file in any other format you may not know about it it may store in the same file it may store in two different files two types of data in the same file but that was the whole idea of having dbms database management system now over the years one of the database which is very common is relational database what is relational database is that data is stored in a table format let us take one example okay let's look at this do you all are present on social media all of you so first thing to be present on social media say Facebook what is important that you need to register on the Facebook account right everybody has seen the register page no someone who has not seen it okay great so what information do you feel okay great name email ID age nationality okay and can you please come and write it out okay so name age email ID and nationality so everybody of us will fill this information now this data should go into a table right otherwise it is very difficult because on social media you search for a name you search for your friend's name you get the information about that person right okay name age let us say we store we give a lot of information hobbies they ask so many pages of information right let us look at these five fields as of now so we all agree to this that we should store this information into a table right everybody someone who feels that it should be stored in a different format anybody no it is possible you can store in many formats yes what format it is possible that all of them will not provide age and date of birth so we don't need to provide space for that but in a table format we'll have to provide the space to maintain their table okay this is very interesting what he's saying basically what he's saying is that when we fill any data in on the social media form there are maybe say hundreds of fields to be filled your interest your college your parents so much information but as a user I may choose I choose that whether I may enter that information or may not enter that information so what he's saying is that there's a possibility that some people may not fill that data then that table will have lots of holes right look at this particular auditorium this is more than half empty right in a way we are wasting that space now this is very interesting what you have raised the point and this resulted into a database called document database on a no SQL database but I would not like to cover that topic away right now right but thanks you touch that topic as of today space is very cheap you realize that hard disk cost 80 GB hard disk what it will cost 3000 2000 anything like that right so it doesn't matter to us if 50% of a space gets goes free right but there is definitely another kind of database which is called object-oriented database which takes care of this information that normally people will not enter 90% of the data and then how to handle that kind of data so what I can do is I can give you a small taste of it by example ok I will need your information about this can you please provide this information to me home car ok home car correct 19 ok you can skip your date of birth Indian home cars had a gmail for example this much information is available so I can create a database like this in which I say let me call it person and then say if the next person comes in who will volunteer to give you their email ID we don't want any other information from you say you are a very private person you don't want to share anything else you just say name so basically a database will be such this is a another form of database not a form of table where this kind of information is told it's called document database or something called no SQL which is very in thing right now a lot of companies are using it the reason of it being over here there is that we believe that the processors are very fast and we have a lot of space but we want a searching to be faster so this helps searching to be faster than so those who have done databases they know that we store data in relational databases 3 nm but here data is stored at 1 nm ok so this is only for third year students second year students don't need to worry about it ok let me start this so anybody has worked on no SQL database anyone of you you have worked which database what do you mean wow so how did you find it how different it is have you used my SQL so how different it is from my SQL so when you use basic things all the basic facilities are available what are the basic facilities so what are the basic facilities available in my SQL very inquiring query the database very good inserting in the database from the database sorry deleting from the database inserting into database deleting from the database updating updating the database or updating a table right ok good what about create a create table in my SQL we have to create table sure ok but in no SQL it is all mixed up in form of like JSON like thing yeah so it's kind of a documents there is no structure in no SQL but my SQL is structured ok great so very interesting although I never wanted to cover it but it got covered and thanks to you all this is just for your information probably I don't think anyone of you will be using MongoDB by any chance ok but that the MongoDB is a document database so like you write a document the data is stored in that information in that format ok and in my SQL data is stored in tables are we all agree understanding that can you all think that data is stored in a form of a table right like you get your marks in a form of a table first semester marks subject one marks obtain this or a grade whatever you get CPI whatever subject to this subject 3 m3 suppose now I want to check for the entire class what it will have your roll number name subject one marks obtained name name to subject one marks obtained correct ok so now let us look at this particular thing let us come back to this example I like the example now you have to create a table for this ok now what should be the type of name like in your programming language you have a type attached to a variable right where care ok yeah so someone please come and write it down with name you can write what it is she said where can't write ok where care do you think we should assign a size to it because we are talking about a table so we are we need to know how many by its or how many characters it will 20 ok will it fit some people have names like Ram Nara and Krishna Moorthy and all that it will fit very important how big it should be what do you think what size that's what now so what should be the we are designing an application ok so if you are a designer what value would you like to put so we are looking at students from India so what do you think 50 length of characters will do people write such big names you know so we are when we are talking about India we are also talking about something here normally when you build an application you don't build for this particular set of years we have become global so we have to think globally and say so how big so one of the things which is very interesting is over here people have started writing in different languages right so we set our database type to utf-8 you know what is utf-8 okay let's leave it let's not divert it over there but normally any language can be data can be visible using a data type using a type colleague type called utf-8 just for your information because I think everybody will work on databases at least 70 to 80% okay so let us say 200 to be on the safe side space is cheap right but I don't want any of my program to error out because the sizes so what you have to take care in your form is that name should not be greater than 200 characters and if it is greater than 200 characters then you have to ask the user to truncate your name right correct okay age is integer minus 10 is it allowed no so what should it be unsigned in okay okay or we can give a we can say there is a constraint that it should be greater 0 we should not allow greater than 0 okay so we can write greater than 0 over there date of birth date field is correct okay this is perfectly fine nationality where can then how much do you want yes United States of America will it fit in 50 characters is there any country bigger than this USSR is no more okay and email ID 150 okay now one of the things in the database which we normally do is this is very nice thank you so much and this is how you create a table also what you do is you just put a comma over here and X nobody will understand after think of a database where you have 50 tables right can you understand X create table so very important table name should be good otherwise tomorrow when you leave and go then we would be thinking what is X what is why what is that what is it be right so the name should be very meaningful thank you so much thank you we will clap for everybody at the end but he did a really good job so this is how you create a table in my SQ okay one of the very important thing in the relational database is a unique column for example name like Omkar there could be thousands of students whose name is Omkar right to identify a record uniquely I will add a ID column type number and to save myself two people updating the database on same time etc. I will use something called auto increment auto increment okay this will be our primary key so anybody wants to explain what is primary key it has to be unique it cannot be null unique non-null unique correct so primary key the fund of primary key is that using that key you can identify the entire rule of the day correct so I here I can say you can see gamma primary key so I am not worried whether you get the syntax right or not the whole idea is that if you get a requirement you should be able to choose the fields what are the fields you should be able to decide what type it should be you should be able to decide the optimal size about it and you should be able to create a key for that okay I think we should be able to write anyone has questions on this because this will be the basis to go further so once we create a table next step comes is to insert the data into table correct is it insert so anybody who wants to help us in inserting the data into table anybody okay please come so meanwhile there are few examples which are there any name you can put your name so now everybody knows Omkar because Omkar was there and Cypress are those private person okay so few things which may help you further while you were developing an application is that many times we want to save a backup of the table right so what you can do is probably can just note it down for your troubleshooting purpose or something you want to try something and you want to save a backup of the table so we use a create table command we say for example create table person backup as select star from person so what it does is that entire table gets copied sometimes we want to just copy the structure of the table because say we are running a program which is related to data migration then we can say create table person underscore migration as select star from person where 1 equal to 2 is it possible to have ever 1 equal to 2 so no data gets selected and your table gets created so these are the few small things which may help you when you are developing your applications okay so those who have not understood it it's okay just something is there you know about it you probably may need to use it sometime whenever it is required night comes to your mind okay thank you so he said insert into person Omkar 20 he make made him one year older what is this is date of birth okay but he did not give the date of birth randomly don't generate ever generate in your application any random date of birth any random data please okay one thing you should be sure is that in your application you start creating something randomly and the person who is going to troubleshoot maintain it will have a tough time to find out from where that data is come okay thank you so much so when this data is not available what we can write here is null so null is a special value which is neither 0 nor empty codes nothing is there okay it's a special value when you say null that means that space is empty okay huh Indian and your address so he is a better data privacy person gave ABC okay now I have a table which is 100 fields right but we have asked user for only five fields right like here one two three four five correct so one way of saying insert is one issue where person values look the syntax is not that important what is important right now is that you should understand that this is how you insert the data these are the ways to insert the data okay so here if I decide that I will not take input as data but okay then what I can write over here is I can say name comma age comma nationality comma right so I will say insert into person name age nationality email values omka 20 Indian ABC accurate correct sometimes what we need to do is that we would like to insert data from one table to another table for example let us look at person database we are talking about students of India so you are students for four years then you go and do your jobs so I want to remove you from the person table but government project how can I remove you so I do this create table person underscore now you all may pass out by it said 2017 2018 17 18 right as select star prop person we are one equal to two okay now this is very interesting let us look at this now I have a table this person table this is a kind of a table I have right ages 19 20 19 nationality is Indian now this is very common we may write nationality but there will be people who will write Hindi who will write Punjab they are people who will write right Indian can be written in multiple ways correct but do you want your table to be like this so what you need to do okay drop-down list that means you need to create another table called nationality which shows one is India two is USA three is China okay like this right so we have a drop-down in a table and a good idea will be to store instead of India many times I can store the index ID 1111 now nationality in case of something called students of India is a very bad choice right is it to some extent right right so a state would have been a much more informative choice although we may have say point one person students which are outside India maybe part of exchange program or a NRI or anything but it hardly matters when I want to know any information about students because less than point one person I may not be interested also so very important thing is how you create your table what is relevant okay so the state would have been a more interesting thing because one of the things which every government or every report would like to know is what is the distribution how many students are from northeast how many students are from Jammu and Kashmir or if their colleges from Maharashtra they will be interested in knowing how many are Maharashtrian students because suppose I run a university and I want to start say a Marathi medium college then this could be a good data for me to start working right you got the point so let me change this and make it to state 13 being Maharashtra for example and 14 being Rajasthan so what happens is that I have a requirement saying that I want to see the list of students who are from Maharashtra okay correct so what I can do is I will go through the entire table and I will select the records which are from Maharashtra Maharashtra is 13 sorry correct are you with me all of you I only want their names what will I do with their age or I only want their email IDs because I probably may want to send the information by email saying that we have started with a new college in Maharashtra on Marathi if you are interested you can let your your you can join in or your friends can join in or you may start a Marathi drama group or something like that then does it make sense right so you select only those students who are from state equal to 13 and you select their email IDs so what it becomes it you make from person where are you all getting it so in a particular project if you are working with database creation of a table normally a project may have fifty to hundred tables so there would be hundred to fifty creates and each table you may have a insert right selection for one table it could be hundred also so querying a database is the maximum work that is done in a project compared to insertion and updation because when you take data the interest is what is there in the data what kind of data you are receiving what we can infer is it clear to you all of you sorry I just I was creating a table right that time select email from person I will show it on the screen so here the database that we are talking about is employee and department so if you see there's a department database department ID a department name employee last name and department ID simple two tables okay so sometimes you miss a particular column like in our case we missed our state right so we can say alter table table name add that column with that type right then you insert the data like we inserted the data when you select the data this is how you update the data my one question to all of you is that asking age from a person look at this particular table do you think is it a good idea to ask the age of a person date of birth is actually not necessary it's our personal choice if you want to enter it okay but it'll be helpful in like reminding birthdays or something okay otherwise you are saying age is better okay anybody else who is who want to counter that please very good you can say loudly okay yes secondly age changes from time every year the age should increase right then who will increase it in the database if I am writing the code I would not like to do that so you can calculate it using current type minus the date of birth okay so there's another point of view saying that if I get date of birth I can calculate it now in the social media you can also somebody's entering the information right there is no way we can say whether he's ethically at bring it correctly or not I showed you an example of Indian you know people can write XYZ people can write idiot and that is also acceptable right some people if you look at Facebook you type idiot you will get a lot of Facebook profiles right smart also you get too many so one thing which is very interesting about this computer applications is that you don't have any control over users so what you consider them is one way of saying it is that you consider them dumb and then you ensure that they put the right date still data could be wrong so one way is that you make date of birth mandatory and then you keep calculating the age if it is very important second thing is that you can especially in social media you have to have that acceptance checkbox saying that yes you are above 18 years of age and you could be part of the application right so there are various ways of doing it so very important when you create a table you know why I am coming back on the creation of table is because if your table is created correctly then all your applications will work fine otherwise I store Omkar as 19 years and after 10 years if I ping him I will think he is 19 years old so you will have all the teenage girlfriends okay so very important right this is something which we will never use in our projects delete but just for completeness this is how you delete so in this case how will you delete delete from person where name is Cyprus up it is deleting from the database right but in reality you don't delete a person there is something called a status field you use status field in that even in Facebook they don't actually delete your profile they just have a status field say in your case where care one which could be either zero or one okay zero means he's inactive one means he's active so this is called symbolic delete so if somebody says delete my internally you don't delete it you just say update person set status equal to zero where ID is equal to whatever ID yes one of the very important thing when you do update or a delete is that that you use ID field or a primary key to do it think if I say they'll update person set status equal to zero your name is equal to Omkar 10,000 Omkar will become inactive then everybody will start searching there is no Omkar in our account all their friends will be deleted and it becomes very difficult think if I delete someone with last name as Kumar then 50% of the students will be out so very important what you delete okay till you have everybody's fine this is another thing drop a table we will never drop a table so whenever you do no delete no drop because we work for government of India projects ideally any application because the space is so cheap we never delete it do you realize that now since the computers have become cheaper the prokarmas have become expensive and because of this now all these frameworks have come in which we build applications because the rapid development framework has come in right we will study about one framework now Django framework which is again a rapid application development framework so that everything you develop applications past programmers are damn expensive okay one table by itself has no meaning we always need to join tables okay so this is very interesting for example if I want to show this information to anybody can I show 13 14 15 I have to show Maharashtra Rajasthan Gujarat Maharashtra right so I have to join data of in person table with states table says states table how do you all want to see the report and someone give any requirement which state do you block Gujarat Uttam wants to see all his friends from Gujarat right Uttam's friends so he selects Gujarat okay so what will I do ideally I will join this to this like this I will say Maharashtra this is Gujarat this is Maharashtra Gujarat Rajasthan and then select people and display the information right so what I would say I will say is I will do a join of these two tables I would say select whatever from person comma state where how they should match this is a state and this is ID column right this is every table has an ID column so where person dot state that means this part should match with state dot with this part right okay so all Uttam's friends should come Sheena and Sai should come here okay and what should I select do I need ID column is Uttam interested in ID column so what will he need so person dot name comma a email ID may be person dot email comma person dot age is it correct what I have written do you think something is missing over here good so what he's saying is that the requirement of state being Gujarat has not been included so what should I write over here and what should be the requirement state dot state is equal to Gujarat right so first part was joined the second part is the condition of the data and third part is the projection what data we want to show so the whole idea is whenever you get any report or a thing you should think like this first how these two tables could be joined okay first whenever you get a requirement first you say these are the tables which I have to look then you look the relation between those tables we are talking about relational databases right you decide the relation you write those joints then you write the requirements and then you write what the user wants to see so let me take another requirement this is fine right joints because this is something which we will be using a lot and I totally agree that in one hour nobody loves my skin but the whole idea is that you have some idea and when you start working on it at least you know what to Google so now there is a requirement which says this is the requirement this is the kind of requirement you will get for example which says that I have list of all the students of India okay and I want a report like this here are all the states and here are the age group states and say types of college okay so types of engineering colleges that you have is one is the government college IITs NITs government colleges private colleges autonomous colleges colleges which belong to a university government university private university I'm just throwing that probably you can put it in better format correct there could be various so I want this kind of report so I have a state stable to all of them all the 29 states I have types let me define type stable as one as government to as private third is autonomous or as affiliated for example okay now I want this kind of data so I will say Arunachal Pradesh government colleges private autonomous affiliated Bihar Chattisgarh right so how can I get this data can I do a join on these two tables although it has no relation between them this is called cross join you have done cross of two sets right everybody has done cross of two sets A cross B it's same thing over here right what output this is how the report has to come right but what I need information is this table that I need is AP government AP private AP autonomous AP affiliated okay so very simple thing what you need to do is select from states comma types there is no wear clause because there is no relation right requirement table and this are you clear with it is anyone who is not clear it's called cross join so we are done with so in this example if you see there's a department ID column which is together this is cross join Cartesian product this is something which we did now right so once we get this data then we go back to person's table and find those students right and get their numbers over there so something like this it looks but in our case they were only two columns which we were joining inner join was something which we did before that it's called inner join if you don't write inner join like this look at the second query select start from employee department where employee dot department ID is equal to department or department ID this is what we did with states and person table very interesting null we saw a null that unique value was there now we have to specially take care of null we have to say whether it the value is null or not null for example I want to see on this particular person table how many users have kept data of birth as null so I will say select start from person where DOB is null so very important when you join null with any condition results to null so neither it is true nor false so it never gets selected so you have to be very careful about it each one is the same thing as inner join but it is equality comparison this is very interesting outer joins for example if I want to list all let us take this example once again I say these are the states of India and these are the number of students from each state now in our database there is a possibility although co as a engineering college this Sikkim there is no student from Sikkim so what will happen if I do a join of person with states Sikkim will never get selected right because we are doing a equi joint saying that person dot state I state is equal to state dot id right let us write that right so if I don't have anybody from Sikkim that per Sikkim state will not get selected but when if I want to display all the states so what I will do is I will see this state left outer join person left outer join means the table on the left will lead the day lead the joining facility so each value of state dot id will be used in the person's table to fetch data so how the data will come for Sikkim like this Sikkim C21 Sikkim because there is no data in the person table null null null and if you put it on the right if you want the right table to be the driving table you say right outer join so look over here select staff of employee left outer join department so this will select all the employees who do not belong to any department also for example you too you all do not belong to any project right now have you all been assigned projects probably by end of the day you will be assigned right so if I want to know information about you along with us I will say select start from employee because as of now for eight weeks you are our employees right but you don't belong to any department left outer join department so your department id will be null but I will be able to view so now let's take another example we have started some projects or say some departments only because you have come in we don't have so many resources so since you have joined we wanted to do some part which because of which we have called you like you are here so we will so basically you all will make a group and you will start working on that project okay so if I say select start from employee right outer join department okay so for example there's a project on big data which we don't run normally because we have come so the department big data will come but there will not be any employees because right now you are not assigned to any department right and you all will never come in because I did a right outer join with the department okay so very important when to do a left outer join when to do a right outer join and there's something called full outer join full outer join will ensure that you all also come in and also the departments which don't have employees also come in okay so in this case if I do a full outer join then I get those person who do not select any states I also get those states where no person exist so I get the entire data set so let us summarize it what all we studied anybody what all we did we did not do create database but we did create tables insert update delete yes okay what are the different types of choice okay I hope you understood it well or he had a good teacher in college anything else cross-join okay update delete we also talked about how to design if we have a requirement how to create a table right and I hope that this particular one hour will be useful to you sometime in next eight weeks okay do you have any questions so thank you