En cours

Small Project PHP/Mysql - URGENT

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 –

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.

I similar examples if you need them.

All code needs comments or documentation and has to be well presented.

MUST BE About 90% grade !

Compétences : PHP

Voir plus : preferred admin, php create table, mysql documentation, mysql data access, create table php, create mysql database using php, access to php mysql, php courses, urgent!, urgent requirement, urgent mysql, urgent c++ small project, Time study, project, project page, project c++, primary, php level 3, period, numeric, new characters, Mysql, mysql admin, met, diploma

Concernant l'employeur :
( 1 commentaire ) Melbourne, Australia

N° du projet : #34874

Décerné à :

izwan00

Sure can do it. Please contact me soon.

300 $ USD en 2 jours
(20 Commentaires)
5.2

3 freelance ont fait une offre moyenne de 267 $ pour ce travail

kumaranand

hi there, I will deliver you this on sunday mornng with complete testing and everything! to know more about us plz visit [url removed, login to view] am ready to start now, do you have a IM?

200 $ USD en 1 jour
(1 Commentaire)
3.9
OTL

Hi we have a big team in PHP with us and are ready to do your project and finish it in by [url removed, login to view] have a look on PMB

300 $ USD en 2 jours
(0 Commentaires)
0.0