URGENT – PROJECT DUE MONDAY 9AM AUSTRALIAN TIME NO LATER
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 –
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)
Title varchar 80 characters
Level varchar 15 characters
Duration Number Integer
CourseId AutoIncrement Primary Key
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 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.
I similar examples if you need them.
All code needs comments or documentation and has to be well presented.
MUST BE About 90% grade !
3 freelancers are bidding on average $267 for this job
hi there, I will deliver you this on sunday mornng with complete testing and everything! to know more about us plz visit [login to view URL] am ready to start now, do you have a IM?