Small PHP / Mysql Project

This is the proect. Im after a high 80% mark. I have similar examples if you need them. Using PHP and MYSQL, you will create a course application system. Step 1. Create a database that has 3 tables, Student, Course and Enrolment. The layout should be – Student table: Given varchar 50 characters Family varchar 50 characters StudId AutoIncrement Primary Key Enter Numeric Integer VTACld Numeric must be 9 digits – probably varchar in the database PreferredCourse Ingeger (course cose of preferred course – foreign key) Course: Title varchar 80 characters Level varchar 15 characters Duration Number Integer CourseId AutoIncrement Primary Key EnterReq Integer Places Integer Create a course application system The first page will allow administrators or applicants to choose the level of access. Administrators require password protections/authentication. The userid /Password for administrators needs to be admin /admin Administrators Administrators enter a course level, Title Enter requirement and number of places available in the course. Administrators need a way to enter new courses – this must apply some protection such as a password to restrict access to authorized administrators. The duration is a period in months of full-time study. The level is Certificate II, III or IV, Diploma, or Bachelor. Cert II is 6 month duration CertIII is 12 month duration CertIV is 18 month duration Diploma is 24 months duration Bachelor is 36 months duration Applicants need to be able to enter their details and An applicant must be able to choose a course. The applicant must have a sufficient ENETR score. So if there is a course called Dip IT NET Eng with an Enter of 60 and a student has an Enter of 50, that student must be informed that the student has not met the required Enter score and NO record saved. If the student has a sufficient Enter score, a record should be kept in the student table. You need to use a tool such as phpMyAdmin to create the tables and populate the course table with data.