small coding work

1)Please write a complete three tier web application to implement an URL shortener like [login to view URL] It should meet the following constraints: The shortened URL path (after the /) should not be longer than 6 – 8 characters, and they should be from the charset [A-Za-z0-9] Each unique URL should have a unique short URL and vice versa 2)Please review [login to view URL] and recommend 10 things we could do in order to improve the performance or Page Load Time Design a Single sign on feature that could be used across multiple domains and multiple publications, for example build a single sign on login/registration feature which will track a unified user profile across [login to view URL] and [login to view URL] 3) Please create a database schema to represent students and courses. Each student can sign up for multiple courses, and each course can be taken up by multiple students. Once you have designed the schema to capture the marks scored by each student for each course they have taken up, write the SQL queries to output the following a)Print all courses, the total # of students who signed up for each course, the average marks across all students who have taken that course b) Now print the same list as above, but print them in descending order of the average marks in each course c) Rank all students by the average marks secured across all courses taken by each student