1 CSCI 3743 PHP and MySQL programming project Project introduction In the real life, you may use online database and online data processing. The database is defined based on designed tables in order...

Help with entire project


1 CSCI 3743 PHP and MySQL programming project Project introduction In the real life, you may use online database and online data processing. The database is defined based on designed tables in order to be used. Your project will pick one of this ONLINE database created by MySQL and process the data from the database using PHP. Project Description You design one online database using the three ways introduced in the class. In the project, you will use PHP for the data processing and show the result clearly using HTML such as FORM. Some topics you can choose, or you choose your own topic which you are familiar with: 1. Student registration system. The student can type in the course # , course title, and other related items. If the pre- required course was not finished, there is a warning. After everything is typed in, final schedule is created, and you must make sure no time conflict. 2. Student balance check system for computer science major: After you have the students’ course data with grade, the system can check that to make sure the students are ready for the graduation based on balanced sheet, which is similar to MYFVSU degree. 3. Online shopping checkout system. 4. Or one topic you are familiar with or some project you can help for the small business from your family or friends The requirements: 1) Online MySQL database design (You design data types, and table(s) using any three methods introduced in the class). 2) Implementation online data processing using PHP. 2 3) Realize the basic online data operations: add, remove, search, and etc. Bonus will be given with more operations. 4) Implementations of your database 5) Application of your database 6) Graphic user friendly design is used as the bonus by HTML language such as FORM Project Learning Objectives • Students will be knowledgeable of the concepts and techniques of creating database and data processing • Develop database creating code and understanding software life cycle • Familiar with operations on online data using PHP Computer Programming Learning Objectives Students will enhance knowledge in following areas: • Online table operations • Online database operations • HTML programming • Online data processing and operations • Graphic user interface design Learning Objectives • Upon the successful completion of the project, the students will gain a better understanding of following course concepts • The operations on the online database • The HTML programming to visualize the data processing results • The student will enhance the knowledge and skills in writing a well-documented PHP and MySQL program Program structure The program should include the following sections: • Table design: Describe the data types or data structure in the table 3 • Database design: Design relational database with operations • Application level: You should apply the project to the real life with basic operations in the implementation level Deliverable • Cover page containing project name, class name, your full name, and date • A brief introduction to the project • Description of the project-table structure • Design procedure for the operations in database • Discussion of results including the application level • Conclusion • Your code will be submitted as a separate file. Do not put your code in the report documentation. • Your code should include enough comments to make it readable. Grading rubrics • Correct TABLE and DATABASE design and implementation 15% • Correct programming code for interfaces and implementation 20% • Correction programming for applications 10% • Perfect documentation report as required 55% • Graphics user interface design bonus 5% • More applications for your data structure bonus 5% Due date Last day of the class: TBD The project reports and code are due on the same day by email to [email protected] CSIS 3743 Dr. Haixin Wang PHP Report By: your name date Introduction The purpose of creating this program Design Procedure The design procedure \ Simulation This image below is a screen shot of the webpage I developed. Discuss Conclusion As early stated all my functions work Remove Item