need some spaific steps for how to create the database, and table for employee.

 

FALL2016CSE / CIT 252 - Interactive Web DesignMODULE 4 THROUGH 6 - MYSQL, PHP, JAVASCRIPT - PROJECTDue: November 23, 2016You will create a skills registration web application for employers and employees. The employerswill post a needs statement, and the prospective employees will post their expertise.•If your GID ends in an odd number, you will develop the EMPLOYER side of theapplication, otherwise you will develop the EMPLOYEE side.•You will develop the backend database (Module 4)•You will develop the PHP for your target user (Employer/Employee) to communicate with hedatabase and enter and retrieve information (Module 5)•You will next integrate JavaScript front end capabilities such as error checking and othersecurity features such as CAPTCHA (anti-robot) verification (Module 6)•You may build the front end of the application using BOOTSTRAP or homegrown CSS, oranother third party style library. It’s your choice.•Authentication: For now you will perform authentication, but the username and passwordmay be hardcoded. That is, the employer/employee will call you to register, and youwill (collect your fees!) and email them a username and password.•For Extra Credit: You can team with your classmate building the complementary site and do amatch for the positions. That is, employer will match positions for employees, andvice versa.•The following represents the minimal information to be captured for employer and employee:•Employer:•Text Box: Name of the Company, Name of the Manager, Address, Phone, Email•A company may post manypositions. For each position, provide:•Text: Position Title•Text: Description•Drop Down: Location of the position (state)•Top 3 Skills: Skill (Pull Down), Experience: Pull Down - 0, 1-3, 3-5, 5-10, 10+•Need: Radio: Urgent (<1 month), Soon (1-3 months), Upcoming (3+ months)•Employee:•Text Box: Name, Address, Phone, Email, Radio Button: Availability (Now: <1 month,Soon (1-3 months), Exploring (3+ months)•An employee may post manyexperiences. For each experience:•Text: Company Title•Text: Job Title•Text: Description•Top 3 Skills: Skill (Pull Down), Experience: Pull Down - 0, 1-3, 3-5, 5-10, 10+•Radio Button: Team-Member, Team Leader, Manager,Executive•Grading:•The TA may periodically get in touch with you to monitor progress. The Moodle pagewill ask you to submit weekly progress, as well as the Professor would get intouch with you if it appears that satisfactory progress is not being made.•Final grade (individually assigned to three sub-projects) will be based on:•URL of the application hosted on a server.•ZIPPED file containing all the site code and•MySQL Dump of the database.

Attachments:

• 1494223290-Module-4To6-Project.pdf