Advanced Database Management Project: Embracing the Challenge
This project is designed to mirror the real-world experience you’ll encounter in your database management career. Here’s what to expect:
- Independent Troubleshooting: You’ll be tasked with troubleshooting, researching, and finding solutions independently. This is a crucial skill in the field, as you’ll often face unforeseen challenges requiring independent problem-solving.
- Simulated Real-World Issues: Expect difficulties during installation, similar to what you might face on the job. For instance, installing PHP can sometimes be tricky, but this is a realistic scenario that will help you develop your troubleshooting skills.
- Database Connectivity: You must connect your PHP application to a MySQL database. This may involve using a web browser, command line (terminal), or IDE. Be prepared to troubleshoot any connection issues that arise.
- Unclear Instructions: Just like in real-world projects, instructions may only sometimes be crystal clear. This is an opportunity to hone your research and critical thinking skills to find the necessary information and solutions.
- Embrace the Learning Curve: This project is not meant to be a smooth ride. It’s designed to challenge and equip you with the skills necessary to thrive in real-world database management scenarios. View this as a valuable learning experience that will prepare you for the exciting challenges and rewarding opportunities in the job market.
Good Luck!
Project Requirements
Create a Word document with the doc or docx extension.
Add the following information to the first page of the Word document:
Project: PHP MySQL
Florida International University Student Name: (word doc with private info)
Department of Knight Foundation Student ID: (Word doc below with this private info)
School of Computing and Information Sciences
COP 4751: Advanced Database Management Systems
Summer 2024: Total Marks 16.66 points
Course Teacher: Dr. Kiavash Bahreini
Add the following fourteen steps as the titles of your sections in the Word document.
Open the following link on w3schools.com and follow the instructions:
1. Open the PHP MySQL Database page: PHP: MySQL Database (w3schools.com)Links to an external site. and follow all the instructions on this page from the top to the bottom. After doing step 1, you will open the following URLs and complete steps 2 to 14.
2. Open PHP MySQL Connect to the database (w3schools.com)Links to an external site. and follow all the instructions on this page from the top to the bottom. You need to install MySQL 8.0.34 or other versions from https://dev.mysql.com/downloads/installer/
Also, install MySQL Workbench 8.0.34 or other versions from https://dev.mysql.com/downloads/workbench/
3. Open PHP MySQL Create Database (w3schools.com)Links to an external site. and follow all the instructions on this page from the top to the bottom. Please figure out which version of the PHP you require to install. That is part of your project.
4. Open PHP MySQL Create Table (w3schools.com)Links to an external site. and follow all the instructions on this page from the top to the bottom.
5. Open PHP MySQL Insert Data (w3schools.com)Links to an external site. and follow all the instructions on this page from the top to the bottom.
6. Open PHP MySQL, Get the Last Inserted ID (w3schools.com)Links to an external site., and follow all the instructions on this page from the top to the bottom.
7. Open PHP MySQL Insert Multiple Records (w3schools.com)Links to an external site. and follow all the instructions on this page from the top to the bottom.
8. Open PHP MySQL Prepared Statements (w3schools.com)Links to an external site. and follow all the instructions on this page from the top to the bottom.
9. Open PHP MySQL Select Data (w3schools.com)Links to an external site. and follow all the instructions on this page from the top to the bottom.
10. Open PHP MySQL Select Data With WHERE Clause (w3schools.com)Links to an external site. and follow all the instructions on this page from the top to the bottom.
11. Open PHP MySQL. Select Data With ORDER BY Clause (w3schools.com)Links to an external site. and follow all the instructions on this page from the top to the bottom.
12. Open PHP MySQL Delete Data (w3schools.com)Links to an external site. and follow all the instructions on this page from the top to the bottom.
13. Open PHP MySQL Update Data (w3schools.com)Links to an external site. and follow all the instructions on this page from the top to the bottom.
14. Open PHP MySQL Limit Data Selections (w3schools.com)Links to an external site. and follow all the instructions on this page from the top to the bottom.
15. After doing every step mentioned above, you capture the screen of your database or the execution of your application and add the photo into the related section in your Word document.
16. Save your Word document.
17. Submit your Word document to Canvas before the deadline.
18. Never send me, your TA, or your grader your document via emails or Canvas messages. Your emails or the Canvas messages will not be considered, and you won’t be graded for your project.
